can anybody have string builder example for insert query??
i want to insert form data to the databse. So please me to solve this...
protected void btnSubmit_Click(object sender, EventArgs e)
{
SqlConnection com = new SqlConnection(@"Data Source = DESKTOP - 88KLQC8\SQLEXPRESS; Initial Catalog = GPF_CPF; Integrated Security = True; Connect Timeout = 15; Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
com.Open();
SqlCommand con = new SqlCommand(mySql, com);
//Replaced Parameters with Value
StringBuilder mySql = new StringBuilder("insert into GPF_CPF ");
mySql.Append(" @GPF_CPF,@Pass_Word,@Re_Pass_word,@F_Name,@M_Name,@L_Name,@Photo_Path,@Mobile_No");
mySql.Append("@Mobile_no,@Address_1,@Address_2,@City_Village,@taluka,@Dist,@Pin_code,@Designation");
mySql.Append("@Unit_Name,@Unit_Address,@Unit_No,@E_mail_Address,@gender,@dob,@doj,@dor,@E_class");
mySql.Append("values");
mySql.Append(con.Parameters.AddWithValue("@GPF_CPF", txt_GPF_CPF.Text.Trim()));
mySql.Append(con.Parameters.AddWithValue("@Pass_Word", txt_password.Text.Trim()));
mySql.Append(con.Parameters.AddWithValue("@Re_Pass_word", txt_re_password.Text.Trim()));
mySql.Append(con.Parameters.AddWithValue("@F_Name", txt_F_name.Text.Trim()));
mySql.Append(con.Parameters.AddWithValue("@M_Name", txt_M_name.Text.Trim()));
mySql.Append(con.Parameters.AddWithValue("@L_Name", txt_L_Name.Text.Trim()));
mySql.Append(con.Parameters.AddWithValue("@Photo_Path", FileUpload1.FileName));
mySql.Append(con.Parameters.AddWithValue("@Mobile_No", txt_mobile.Text.Trim()));
mySql.Append(con.Parameters.AddWithValue("@Address_1", txt_address_1.Text.Trim()));
mySql.Append(con.Parameters.AddWithValue("@Address_2", txt_address_2.Text.Trim()));
mySql.Append(con.Parameters.AddWithValue("@City_Village", txt_city_Village.Text.Trim()));
mySql.Append(con.Parameters.AddWithValue("@Taluka", txt_taluka.Text.Trim()));
mySql.Append(con.Parameters.AddWithValue("@Dist", txt_dist.Text.Trim()));
mySql.Append(con.Parameters.AddWithValue("@Pin_Code", txt_pincode.Text.Trim()));
mySql.Append(con.Parameters.AddWithValue("@Designation", txt_desig.Text.Trim()));
mySql.Append(con.Parameters.AddWithValue("@Unit_Name", txt_unit_name.Text.Trim()));
mySql.Append(con.Parameters.AddWithValue("@Unit_Address", txt_unit_address.Text.Trim()));
mySql.Append(con.Parameters.AddWithValue("@Unit_No", txt_unit_no.Text.Trim()));
mySql.Append(con.Parameters.AddWithValue("@E_Mail_Address", txt_Email_Address.Text.Trim()));
mySql.Append(con.Parameters.AddWithValue("@gender", dd_gender.SelectedValue.Trim()));
mySql.Append(con.Parameters.AddWithValue("@dob", txt_dob.Text.Trim()));
mySql.Append(con.Parameters.AddWithValue("@doj", txt_doj.Text.Trim()));
mySql.Append(con.Parameters.AddWithValue("@dor", txt_dor.Text.Trim()));
mySql.Append(con.Parameters.AddWithValue("@e_Class", dd_desig.SelectedValue.Trim()));
SqlCommand con = new SqlCommand(mySql, com);
}