ExecuteReader: Connection 属性尚未初始化。谁帮我啊!!!高手救我啊!!!
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string sms_connstr = System.Configuration.ConfigurationManager.AppSettings["SMS_dbconn"];
// 建立连接
sms_conn = new SqlConnection(sms_connstr);
sms_conn.Open();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string str_pwd = this.mypassword.Text.Trim().Replace("'", "''");
string sqlstr = "select usertype from Users where username='"+username.Text+"'and mypassword=@password";
SqlCommand cmd = new SqlCommand(sqlstr,sms_conn);
cmd.Parameters.Add(new SqlParameter("@password", SqlDbType.VarChar,50));
cmd.Parameters["@password"].Value = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(str_pwd, "MD5").ToString();//密码加密
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read() == true)
{
Session["user"] = this.username.Text.Trim();//管理员用户,Session进行传值
Session["type"] = dr["userType"].ToString().Trim();//管理员类型
FormsAuthentication.RedirectFromLoginPage(username.Text, false);
//sms_conn.Close();
}
else
{
sms_conn.Close();
mypassword.Text = "您必须输入有效的用户名和密码!";
}
}