您所在位置：主题：一个很简单的登陆验证但是问题没找出来，求助~~！
322114492
[专家分：80] 发布于 2006-07-15 09:51:00
private void Page_Load(object sender, System.EventArgs e)
{
string UseNmae=Request.Form["UseName"].ToString();
string UsePwass=Request.Form.Get("UsePwass").ToString();
SqlConnection con=new SqlConnection("Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=LOGIN;Data Source=.");
con.Open();
SqlCommand cmd= new SqlCommand("select count(*) from login where UseNmae='"+UseName+"'and UsePwass='"+UsePwass+"',con");
int count=Convert.ToInt32(cmd.ExecuteScalar());
if(count > 0)
{
Response.Redirect("main.aspx?UseName=UseNmae");
}
else
{
Response.Redirect("login.aspx");
}
}
{
string UseNmae=Request.Form["UseName"].ToString();
string UsePwass=Request.Form.Get("UsePwass").ToString();
SqlConnection con=new SqlConnection("Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=LOGIN;Data Source=.");
con.Open();
SqlCommand cmd= new SqlCommand("select count(*) from login where UseNmae='"+UseName+"'and UsePwass='"+UsePwass+"',con");
int count=Convert.ToInt32(cmd.ExecuteScalar());
if(count > 0)
{
Response.Redirect("main.aspx?UseName=UseNmae");
}
else
{
Response.Redirect("login.aspx");
}
}