using System.Data.SqlClient;
protected void btn_Click(object sender, EventArgs e)
{
string strconn = sds_user_reg.ConnectionString.ToString();
SqlConnection cn=new SqlConnection(strconn);
cn.Open;
string strsql1 = "INSERT INTO [user] (user_id, user_name, user_pwd, user_power) VALUES (@user_id, @user_name, @user_pwd, @user_power)";
string strsql2="INSERT INTO user_detail(user_id, user_name, user_sex, user_position, user_birth, user_date, user_xl, user_phone, user_prv_phone, user_email, user_qq) VALUES (@user_id, @user_name, @user_sex, @user_position, @user_birth, @user_date, @user_xl, @user_phone, @user_prv_phone, @user_email, @user_qq)";
SqlCommand cm = new SqlCommand(strsql1, cn);
SqlCommand cm2 = new SqlCommand(strsql2, cn);
cm.Parameters.Add(new SqlParameter("@user_id", SqlDbType.Int));
cm.Parameters["@user_id"].Value = "";
cm2.Parameters.Add(new SqlParameter("@user_id", SqlDbType.Int));
cm2.Parameters["@user_id"].Value = "";
cm.ExecuteNonQuery();
cm2.ExecuteNonQuery();
cn.Close;
}