ASP.NET登陆页面时如何查询SQL Sever数据库中用户名和密码是否相匹配

Question

小弟是个新手，想请教下ASP.NET中如何通过TextBox控件去查询SQL Sever数据库中用户名和密码是否相匹配。求完整的代码，谢谢各位前辈！

Answer 1

string connect = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=|DataDirectory|contacts.mdb";
string query = "Select Count(*) From Users Where Username = ? And UserPassword = ?";
int result = 0;
using (OleDbConnection conn = new OleDbConnection(connect))
{
  using (OleDbCommand cmd = new OleDbCommand(query, conn))
  {
    cmd.Parameters.AddWithValue("", UserName.Text);
    cmd.Parameters.AddWithValue("", Password.Text);
    conn.Open();
    Session["User"] = UserName.Text;
    result = (int)cmd.ExecuteScalar();
  }
}
if (result > 0)
{
  Response.Redirect("LoggedIn.aspx");
}
else
{
  Literal1.Text = "Invalid credentials";
}