菜鸟求一段登陆验证代码

[manplus]

数据库是sql server
求登陆验证代码

[wyl918]

你说的什么意思,没弄明白??

[mail_ricklee]

NickLee.Web.UI.VB.CaptchaControl

http://www.cnblogs.com/mail-ricklee

[beyondjay]

取密码对照嘛

[ying39]

private void btnLogin_Click(object sender, System.EventArgs e)
{
if( Page.IsValid==true)
{
string sql;
SqlCommand cmd;
string userName;

SqlConnection con=DB.createConnection();
sql="select userName from userinfo where userID='{0}' and password='{1}'";
sql=string.Format(sql,txtName.Text.Trim(),txtPwd.Text.Trim());
cmd=new SqlCommand(sql,con);
con.Open();

try
{
userName=(string)cmd.ExecuteScalar();
}
finally
{
con.Close();
}

if(userName!=null)
{
Session["userName"]=userName;
System.Web.Security.FormsAuthentication.RedirectFromLoginPage(userName,false);
//Response.Redirect("RepairInfo.aspx");
}
else
{
Response.Write("<script>alert('用户名或密码错误')</script>");
}

}
}

private void btnCancel_Click(object sender, System.EventArgs e)
{
txtName.Text="";
txtPwd.Text="";
}

[ying39]

上面的这句：SqlConnection con=DB.createConnection();
DB是自己建的一个类，里面返回一个SqlConnection对象。

[bufan2162]

顶过

[manplus]

up