SqlConnectionconn=newSqlConnection();conn.ConnectionString="UserID=sa;InitialCatalog=User;DataSource=(local);Password=123456";if(conn.State==ConnectionState.Closed){conn....

SqlConnection conn = new SqlConnection(); conn.ConnectionString = "User ID=sa;Initial Catalog=User;Data Source= (local);Password=123456"; if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.CommandText = "insert into Table_1 ( Uname, Pass,Mark ,Sex,Tel,Address,Email) values('" + name + "','" + pass + "','普通用户','" + sex + "','" + tel + "','" + address + "','" + emial + "')"; int n = cmd.ExecuteNonQuery(); //判断返回的参数是否大于0，如果大于说明登录成功 if (n>0) { SqlDataReader read = cmd.ExecuteReader(); HttpCookie cookie = new HttpCookie("Name"); Request.Cookies.Clear(); cookie.Value = TextBox1.Text; cookie.Expires = DateTime.Now.AddDays(1); Response.Cookies.Add(cookie); read.Close(); Page.Response.Redirect("~/user-index.aspx");

} else { RegisterStartupScript("", ""); } conn.Close();

展开