代碼-ASP.NET登陸頁面時如何查詢SQL Sever數據庫中用戶名和密碼是否相匹配

ASP.NET登陸頁面時如何查詢SQL Sever數據庫中用戶名和密碼是否相匹配

小弟是個新手，想請教下ASP.NET中如何通過TextBox控件去查詢SQL Sever數據庫中用戶名和密碼是否相匹配。求完整的代碼，謝謝各位前輩！

最佳回答：

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";
}