SQL_添加语句

 

 SqlConnection con = new SqlConnection("Server=localhost;database=qcwx;uid=sa;pwd=sasasa");

                 con.Open();

                 SqlCommand cmd = new SqlCommand("InsertDate5", con);

                 cmd.CommandType = CommandType.StoredProcedure;

                 cmd.Parameters.Add("@s_name", SqlDbType.VarChar, 50).Value = this.tname.Text;

                 cmd.Parameters.Add("@s_sex", SqlDbType.VarChar, 50).Value = this.RadioButtonList1.SelectedValue;

                 cmd.Parameters.Add("@s_birthday", SqlDbType.VarChar, 50).Value = this.tdate.Text;

                 cmd.Parameters.Add("@s_phone", SqlDbType.VarChar, 50).Value = this.tcell.Text;

                 cmd.Parameters.Add("@s_mobile", SqlDbType.VarChar, 50).Value = this.tphone.Text;

                 cmd.Parameters.Add("@s_email", SqlDbType.VarChar, 50).Value = this.temail.Text;

                 cmd.Parameters.Add("@s_registerDate", SqlDbType.VarChar, 50).Value = this.ttime.Text;

                 cmd.Parameters.Add("@s_password", SqlDbType.VarChar, 16).Value = this.tpass1.Text;

                 cmd.Parameters.Add("@s_logname", SqlDbType.VarChar, 16).Value = this.tname0.Text;

                 try

                  { 

                       cmd.ExecuteNonQuery();

                       MessageBox.Show("用户信息添加成功！");

                  }

                  catch (Exception err)

                  {

                        throw new System.Exception(err.Message);

                   }

                  finally

                   {

                        con.Close();

                   }