asp.net中用c#怎么用login控件编写登入界面，要求链接数据库 ( 数据表.accd

private void BtnLogin_Click(object sender, RoutedEventArgs e)
{
string username = TXTUserName.Text;
string password = PWDPassWord.Password;

Operator op = new OperatorDAL().GetByUserName(username);
if (op == null)
{
MessageBox.Show("您输入用户不存在！");
}
else
{
string dbMD5 = op.PassWord;//数据库中存储的密码值
string myMd5 = CommonHelper.GetMD5(password + new OperatorDAL().SysPassword());
if (dbMD5 != myMd5)
{
MessageBox.Show("你输入的密码错误！");

}
else
{
this.Hide();
MainWindow mainwindow = new MainWindow();
mainwindow.Operator = username;
mainwindow.ShowDialog();
}

}
}
Operator op = new OperatorDAL().GetByUserName(username)这取数据库用户的方法。
我用的是三层结构，你可以参考下！
public Operator GetByUserName(string userName)
{

DataTable DS = SqlHelper.ExcuteSqlDataSet("select * from Operator where UserName =@UserName and IsDeleted =0",
new SqlParameter("@UserName", userName));
if (DS.Rows.Count <= 0)
{
return null;
}
else if (DS.Rows.Count > 1)
{
throw new Exception("存在重名用户！");
}
else
{
return ToOperator(DS.Rows[0]);
}
}

SqlHelper.ExcuteSqlDataSet是从数据库中读取表的方法！
public static DataTable ExcuteSqlDataSet(string sql, params SqlParameter[] parameters)
{
using (SqlConnection conn = new SqlConnection(Data Source=SQL服务器名; Initial Catalog=数据库名;User ID=用户;Password=密码))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
cmd.Parameters.AddRange(parameters);
DataSet DS = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(DS);
return DS.Tables[0];
}
}
}本回答被提问者和网友采纳

一两句话说不清

我教你追答

留下联系方式

追问

411139597