net用戶登陸

再html文件中 創建2個textbox 和一個botton按鈕 然後再另外一個login.aspx文件中接受 如下是login.aspx代碼

private void Page_Load(object sender, System.EventArgs e)
  {
    
   string userName= Request.Form["T1"];

   string userPwd= Request.Form["T2"];

      

   SqlConnection con=DB.CreateDB();
   con.Open();
   SqlCommand cmd=new SqlCommand("select Count(*) from login where userName='"+userName+"' and userPwd='"+userPwd+"'",con);
   int count=Convert.ToInt32(cmd.ExecuteScalar());

   if(count>0)
   {
    Response.Redirect("updataLoad.aspx");
            }
   else
   {
    Response.Redirect("fail.htm");
   }
   
  }