用c#设计的winform，用户登录时访问数据库，数据库是sql server身份验证的。登录代码该怎么写啊.3..

求详细正确的代码啊

我给你段代码 你参考下吧：我这个代码是web开发用的：
protected void Btn_Login(object sender, EventArgs e)
{
string name = this.UserName.Text.Trim();
string upwd = this.Password.Text.Trim();

//if (login.LoginInfo(name, upwd) > 0)
//{
// Response.Redirect("~/Domitory/Unallocated.aspx");
//}
if (this.UserName.Text.Trim() == "" || this.Password.Text.Trim() == "")
{
ClientScript.RegisterStartupScript(this.GetType(), "alert","alert('用户名或密码为空，请重新输入！')",true);
}
else
{
if (login.LoginSeesion(name, upwd) <= 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('用户名或密码输入错误，请重新输入！')", true);
//string role = (Session["User"] as Users).role;

}
else
{
Response.Redirect("../TemplatePges/Template.aspx"); //成功 跳转的页面
}
}
}

login.LoginSeesion(name, upwd)这个方法的代码：
public int LoginSeesion(string name, string upwd)
{
int i=0;
Users us = new Users();
strSql = "select * from 操作人员表 where UserName=@username and UserPass=@upwd";
if (sqlCon.State != ConnectionState.Open)
sqlCon.Open();

cmd = new SqlCommand(strSql, sqlCon);
SqlParameter[] param = { new SqlParameter("@username", name), new SqlParameter("@upwd", upwd) };
cmd.Parameters.Add(param[0]);
cmd.Parameters.Add(param[1]);
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
i = 1;
us.ID = int.Parse(sdr.GetValue(0).ToString());
us.name = sdr.GetString(1);
us.upwd = sdr.GetString(2);
us.role = sdr.GetString(4);
HttpContext.Current.Session["User"] = us;
}
sdr.Close();
sqlCon.Close();
return i;
}

public class Users//这个是我写的一个user类
{
public string name { get; set; }
public string upwd { get; set; }
public string role { get; set; }
public int ID { get; set; }
}
这里面我把用户的信息存储在了session中以供以后权限那里使用，你也可以不使用session以及user类这就简单了 那就调用下面的方法：
public int LoginInfo(string name, string upwd)
{
int i = 0;
strSql = "select * from 操作人员表 where UserName=@username and UserPass=@upwd";
if (sqlCon.State != ConnectionState.Open)
sqlCon.Open();

cmd = new SqlCommand(strSql,sqlCon);
SqlParameter[] param = { new SqlParameter("@username", name),new SqlParameter("@upwd",upwd) };
cmd.Parameters.Add(param[0]);
cmd.Parameters.Add(param[1]);
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
i = 1;
}
sdr.Close();
sqlCon.Close();
return i;
}

温馨提示：内容为网友见解，仅供参考

当前网址：https://11.t2y.org/zz/2sm8vffqv.html