项目：个人空间

1.创建用户的程序：

sqlcmm.CommandText = "insert into Users(usersname,mima)values(@u,@m)";
                sqlcmm.Parameters.Add(new SqlParameter("@u", TextBox1.Text));
                sqlcmm.Parameters.Add(new SqlParameter("@m", TextBox2.Text));

2.登陆的程序：

using (SqlConnection sqlcnn=new SqlConnection(SqlHelper.cnnstring))
        {
            using (SqlCommand sqlcmm=sqlcnn.CreateCommand())
            {
                sqlcmm.Connection = sqlcnn;
                sqlcmm.CommandText = "select mima from users where usersname='"+TextBox1.Text+"'";
                sqlcnn.Open();
                SqlDataReader reader=sqlcmm.ExecuteReader();
                NewsUser user = new NewsUser(TextBox1.Text);
                Session["name"] = user;
                while (reader.Read())
                {
                    if (this.TextBox2.Text == reader["mima"].ToString())
                    {
                        this.Response.Redirect("index.aspx");
                    }
                    else
                        Response.Write("账号密码错误！");
                }
            }
        }