【转载】ASP.NET简单登陆代码

1.新建两个页面default.aspx、show.aspx

2.在defult.aspx页面添加两个文本框和一个按钮。

主要代码：

    /// <summary>
    /// 登录代码
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Button1_Click(object sender, EventArgs e)
    {
       
        string Sno = TextBox1.Text.Trim();
        string Password = TextBox2.Text.Trim();

        string connStr = "server=.\\SQLEXPRESS;database=SelectTeacher;uid=liuhao;pwd=liuhao880202";
        string sql = "Select * from Student where Sid ='"+Sno+"' and Spassword ='"+Password+"'";

 

        if (TextBox1.Text != "" && TextBox2.Text != "")
        {
            SqlConnection conn = new SqlConnection(connStr);
            conn.Open();
            SqlCommand cmd = new SqlCommand(sql, conn);
            SqlDataReader sdr = cmd.ExecuteReader();
           
            if (sdr.Read())
            {
                Session["Username"]=sdr.GetValue(sdr.GetOrdinal ("Sname"));//获取该用户的用户名
                Page.Response.Redirect("show.aspx");
                sdr.Close();
                conn.Close();

            }

            else
            {
                Label1.Text = "用户名或密码错误";

            }

        }