登录代码段

static string ConnectString = ConfigurationSettings.AppSettings["SMdataSQL"];

 

 SqlConnection Con = new SqlConnection(ConnectString);

 

public void loginbutton_Click(object sender, System.Web.UI.ImageClickEventArgs e)

{

     string name = this.userName.Text;

 

     string pwd = this.Pwd.Text;

 

     string sql = "select * from newuser where username='" + name + "' and password='" + pwd + "'";

 

      Con.Open();

      SqlCommand comm = new SqlCommand(sql, Con);

 

      SqlDataReader dr = comm.ExecuteReader();

 

      if (dr.Read())

       {

              Label1.Text = "登陆成功！";

              Response.Write(dr["username"].ToString());

              HttpCookie cookie = new HttpCookie("uid");

              cookie.Value = dr["username"].ToString();

              Response.AppendCookie(cookie);

               Response.Redirect("~/Default.aspx");

               dr.Close();

              Con.Close();

      }

    else

     {

          Label1.Text = "用户名或密码有误，请重新登陆！"; name = ""; pwd = "";

      }

 }