using (SqlConnection con = new SqlConnection(dt.SqlCon)) {
using (SqlCommand cmd = new SqlCommand("sp_master_applicant")) {
cmd.CommandType = CommandType.StoredProcedure;
cmd.parameters.addwithvalue("@company_name",drdwncompany.selectedvalue.tostring());
cmd.parameters.addwithvalue("@email_address", txtemail_id.text);
cmd.parameters.addwithvalue("@first_name", txtfirstname.text);
cmd.parameters.addwithvalue("@last_name", txtlast_name.text);
cmd.parameters.addwithvalue("@password", txtpassword.text);
cmd.parameters.addwithvalue("@confirm_password", txtre_password.text);
cmd.parameters.addwithvalue("@phone_no", txt_phnno.text);
cmd.parameters.addwithvalue("@mobile_no", txtmobile.text);
cmd.parameters.addwithvalue("@roles", drdwrole.selectedvalue.tostring());
cmd.parameters.addwithvalue("@li_admin", ckadmin.checked ? "1" : "0");
cmd.parameters.addwithvalue("@li_application_form", ckemployee_registration.checked ? "1" : "0");
con.Open();
cmd.ExecuteNonQuery();
}
}