cmd.ExecuteNonQuery();
String or binary data would be truncated. The statement has been terminated.
public partial class Registration : System.Web.UI.Page
{
String image_path;
SqlConnection con;
int i;
protected void Button1_Click(object sender, EventArgs e)
{
op_conn();
StringBuilder qry = new StringBuilder("insert into Registration");
qry.Append("(id,Email_Add,Pass_Word,Re_Pass_word,Full_Name,Photo_Path,Mobile_No,GPF_CPF_No,PF_Type,");
qry.Append("Add_1,Add_2,City_Village,taluka,Dist,Pincode,");
qry.Append("Unit_Name,Unit_Add,Unit_No,gender,dob,doj,dor,E_class,Designation,Emp_No)");
qry.Append("values");
qry.Append("(@id,@Email_Address,@Pass_Word,@Re_Pass_word,@Full_Name,@Photo_Path,@Mobile_No,@GPF_CPF_No,@PF_type,");
qry.Append("@Address_1,@Address_2,@City_Village,@taluka,@Dist,@Pin_code,");
qry.Append("@Unit_Name,@Unit_Address,@Unit_No,@gender,@dob,@doj,@dor,@E_class,@Designation,@Emp_No)");
using (SqlCommand cmd = new SqlCommand(qry.ToString(), con))
{
Guid id = Guid.NewGuid();
String x = id.ToString();
cmd.Parameters.AddWithValue("@id", x);
cmd.Parameters.AddWithValue("@Email_Address", txtEmail.Text.Trim());
cmd.Parameters.AddWithValue("@Pass_Word", txtPassword.Text.Trim());
cmd.Parameters.AddWithValue("@Re_Pass_word", txtConfirm_Password.Text.Trim());
cmd.Parameters.AddWithValue("Full_name", txtFname.Value.Trim());
up_load_img();
cmd.Parameters.AddWithValue("@Photo_Path", image_path);
cmd.Parameters.AddWithValue("@Mobile_No", txtMobileNo.Value.Trim());
cmd.Parameters.AddWithValue("@GPF_CPF_No", txtGPFCPFNo.Value.Trim());
cmd.Parameters.AddWithValue("@PF_type", dd_PF.Text.Trim());
cmd.Parameters.AddWithValue("@Address_1", txtAdd1.Value.Trim());
cmd.Parameters.AddWithValue("@Address_2", txtAdd2.Value.Trim());
cmd.Parameters.AddWithValue("@City_Village", txtCityVillage.Value.Trim());
cmd.Parameters.AddWithValue("@taluka", txtTaluka.Value.Trim());
cmd.Parameters.AddWithValue("@Dist", txtDist.Value.Trim());
cmd.Parameters.AddWithValue("@Pin_Code", txtPincode.Value.Trim());
cmd.Parameters.AddWithValue("@unit_Name", txtUnitName.Value.Trim());
cmd.Parameters.AddWithValue("@Unit_Address", txtUnitaddress.Value.Trim());
cmd.Parameters.AddWithValue("@Unit_No", txtUnitNo.Value.Trim());
cmd.Parameters.AddWithValue("@gender", dd_Gender.Text.Trim());
cmd.Parameters.AddWithValue("@dob", txtDOB.Text.Trim());
cmd.Parameters.AddWithValue("@doj", txtDOJ.Value.Trim());
cmd.Parameters.AddWithValue("@dor", txtDOR.Value.Trim());
cmd.Parameters.AddWithValue("@E_Class", dd_class.Text.Trim());
cmd.Parameters.AddWithValue("@Designation", txtDesig.Value.Trim());
cmd.Parameters.AddWithValue("@Emp_No", txtAAUEmpNo.Value.Trim());
cmd.ExecuteNonQuery();
con.Close();
Mail2.CommonFunction.MailSend(txtEmail.Text, "", "", "GPF/CPF Information", txtEmail.Text + " " + txtPassword.Text, true);
Response.Redirect("Login.aspx");
}
}
}