level 1
baby再回首往事
楼主
string username = TextBox1.Text.Trim();
string pwd = TextBox2.Text.Trim();
string sqlconn = "Data Source =.;Database = user;Integrated Security = True";
SqlConnection myConnection = new SqlConnection(sqlconn);
myConnection.Open();
string sqlstr = "select * from UserInfo where Name='" + username + "' and PassWord='" +pwd+ "'";
SqlCommand com = new SqlCommand(sqlstr, myConnection);
SqlDataReader dr = com.ExecuteReader();//执行命令
if (dr.Read())
{
Response.Redirect("http://localhost:5429/bykcsj/首页.aspx", true);//登录成功跳转页面
//Session["myadmin"] = username;//保存登录名
}
else
{
Response.Write("<script language=javascript>alert('用户名或者密码不正确!请重新输入!');</script>");
}
dr.Close();
感觉不知道怎么一直显示后一项就是用户名错误或者密码错误,就是不知道哪里错了
2014年04月05日 11点04分
1
string pwd = TextBox2.Text.Trim();
string sqlconn = "Data Source =.;Database = user;Integrated Security = True";
SqlConnection myConnection = new SqlConnection(sqlconn);
myConnection.Open();
string sqlstr = "select * from UserInfo where Name='" + username + "' and PassWord='" +pwd+ "'";
SqlCommand com = new SqlCommand(sqlstr, myConnection);
SqlDataReader dr = com.ExecuteReader();//执行命令
if (dr.Read())
{
Response.Redirect("http://localhost:5429/bykcsj/首页.aspx", true);//登录成功跳转页面
//Session["myadmin"] = username;//保存登录名
}
else
{
Response.Write("<script language=javascript>alert('用户名或者密码不正确!请重新输入!');</script>");
}
dr.Close();
感觉不知道怎么一直显示后一项就是用户名错误或者密码错误,就是不知道哪里错了