string conn = Convert.ToString(ConfigurationManager.ConnectionStrings["kjwConnectionString"]); //链接SQL数据库“kjwConnectionString”为你的数据库链接名
SqlConnection con = new SqlConnection(conn);
//打开数据库连接
con.Open();
string str = "select * from kjw_admin where username='" + TextBox1.Text.Trim() + "' and password='" + TextBox2.Text.Trim() + "'"; //SQL语句将前台中TextBox中的存到数据库的字段中
SqlCommand cmd = new SqlCommand(str, con);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read()) //判断SQL执行登录是否成功,成功执行下面语句
{
Session["name"] = TextBox1.Text.Trim(); //将用户名保存到SESSION中
Response.Redirect("main.html");//成功后页面跳转
}
else //不成功提示登录失败
{
Response.Write("<script>alert('用户名或密码错误!')</script>");
}
con.Close(); //关闭数据库链接
}