更新数据库信息.txt

来自「学习积累的代码段」· 文本 代码 · 共 40 行

private void Connect()
        {
            SqlConnection conn=null;
            try
            {
                conn=new SqlConnection("server=.;uid=sa;pwd=;database=wudi");
                conn.Open();
                SqlCommand com = new SqlCommand();
                com.Connection=(SqlConnection)conn;
                com.CommandText = "insert into [users](username,password,nickname,email,birthday,tel,address,post) values(@username,@password,@nickname,@email,@birthday,@tel,@address,@post)";
                com.Parameters.Add("@username", SqlDbType.NVarChar);
                com.Parameters.Add("@password", SqlDbType.NVarChar);
                com.Parameters.Add("@nickname", SqlDbType.NVarChar);
                com.Parameters.Add("@email", SqlDbType.NVarChar);
                com.Parameters.Add("@birthday", SqlDbType.DateTime);
                com.Parameters.Add("@tel", SqlDbType.NVarChar);
                com.Parameters.Add("@address", SqlDbType.NVarChar);
                com.Parameters.Add("@post", SqlDbType.NVarChar);
                com.Parameters["@username"].Value = txtUserName.Text;
                com.Parameters["@password"].Value = txtPwd.Text;
                com.Parameters["@nickname"].Value = txtNickName.Text;
                com.Parameters["@email"].Value = txtEmail.Text;
                com.Parameters["@birthday"].Value = txtBirthday.Text;
                com.Parameters["@tel"].Value = txtTel.Text;
                com.Parameters["@address"].Value = txtAddress.Text;
                com.Parameters["@post"].Value = txtPost.Text;
                com.ExecuteNonQuery();
                Response.Redirect("WebForm2.aspx");
            }
            catch(SqlException)
            {
                Response.Redirect("WebForm1.aspx");
            }
            finally
            {
                conn.Close();
            }
        }