asp.net第二天

 今天学了一些空间，最头疼的是做了注册跟登陆的连接（数据库）：

  protected void login(object sender, EventArgs e)
    {
        string username = this.uesrname.Value;
        string password = this.pass.Value;
       
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = @"server=WIN-FUTTI2D8OOL\SQLEXPRESS; Integrated Security=true; Initial Catalog=user";
        //"server=WIN-07Q4IAKLGNF\\SQLEXPRESS; Integrated Security=true;Initial Catalog=sales ";
        conn.Open();
        SqlCommand cmd = new SqlCommand("select * from Table_1 where usernam='" + username + "' and password='" + password + "'", conn);

        SqlDataReader sdr = cmd.ExecuteReader();//创建SqlDataReader对象
        sdr.Read();//读取
        if (sdr.HasRows)//验证用户名和密码
        {
            sdr.Close();
            cmd = new SqlCommand("select * from Table_1 where usernam='" + username + "'", conn);
            SqlDataReader sdr1 = cmd.ExecuteReader();
            sdr1.Read();
            conn.Close();//关闭链接
            sdr1.Close();
            Response.Redirect("login.aspx");
           
        }
        else
        {
            Response.Write("你输入的账号或密码错误！");
        }

←这是登陆

//  1.建立数据库连连接
            SqlConnection con = new SqlConnection();
           
            //con.ConnectionString = "server=.;uid=;pwd=;Initial catalog=sales";
            con.ConnectionString = @"server=WIN-FUTTI2D8OOL\SQLEXPRESS; Integrated Security=true;Initial Catalog=user ";
            con.Open();
            //利用dataAdapter取出数据
            SqlCommand adp = new SqlCommand("insert into Table_1(usernam,password) values ('" + this.tuser.Value + "'," + this.Pass1.Value + ")", con);
            adp.ExecuteNonQuery();
            con.Close();
            //SqlDataAdapter adpt = new SqlDataAdapter(

←这是注册的

实践出真知，一次实践会有一次新的体会！