protected void Button1_Click(object sender, EventArgs e)
{
string username = txtUserName.Text;
string password = txtPassWord.Text;
string constr = ConfigurationManager.ConnectionStrings["connectionstring"].ToString();
using (SqlConnection con = new SqlConnection(constr))
{
con.Open();
using (SqlCommand cmd = con.CreateCommand())
{
cmd.CommandText = "select * from stu where UserName='"+username+"'";
using (SqlDataReader reader=cmd.ExecuteReader ())
if (reader.Read())
{
string dbPassWord = reader.GetString(reader.GetOrdinal("PassWord"));
if(dbPassWord.Trim () ==password.Trim () )
{
Literal1 .Text ="登陆成功";
}
else
{
Literal1 .Text ="密码错误";
}
}
else { Literal1.Text = "用户名错误";
}
}
}
}
这个是我写的登陆系统的代码，有需要的不明白的地方可以问我。
其中数据库表的名是：stu，表里有两个列：UserName,PassWord.