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();
}