SQL_添加语句

来源：互联网发布：arcgis for js 点闪烁编辑：程序博客网时间：2024/05/22 00:50

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

}