I m not able to insert data into database.
The exception thrown is--- "String or binary data would be truncated.
The statement has been terminated."
there is no problem with connection.its connecting properly.
I m still getting the error.plz help me out
public SqlConnection connect()
{
SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=IMS;Integrated Security=True");
con.Open();
return con;
}
public void Closeconnect(SqlConnection con)
{
con.Close();
}
private void btnSave_Click(object sender, EventArgs e)
{
string Query = "Insert into tblEnquiry values (@mem_no,@date,@name,@add,@gen,@city,@pin,@home,@mobile,@email,@dob,@exec,@interest,@contact,@name1,@tel1,@name2,@tel2)";
SqlCommand cmdSave = new SqlCommand(Query, connect());
cmdSave.Parameters.Add(new SqlParameter("@mem_no", txtMemNo.Text));
cmdSave.Parameters.Add(new SqlParameter("@date", dtpEnquiryDate.Value));
cmdSave.Parameters.Add(new SqlParameter("@name", txtName.Text));
cmdSave.Parameters.Add(new SqlParameter("@add", txtAddress.Text));
cmdSave.Parameters.Add(new SqlParameter("@gen", cbGender.Text));
cmdSave.Parameters.Add(new SqlParameter("@city", txtCity.Text));
cmdSave.Parameters.Add(new SqlParameter("@pin", txtPin.Text));
cmdSave.Parameters.Add(new SqlParameter("@home", txtTelHome.Text));
cmdSave.Parameters.Add(new SqlParameter("@mobile", txtTelMobile.Text));
cmdSave.Parameters.Add(new SqlParameter("@email", txtEmailID.Text));
cmdSave.Parameters.Add(new SqlParameter("@dob", dtpDOB.Value));
cmdSave.Parameters.Add(new SqlParameter("@exec", cbExecutive.Text));
cmdSave.Parameters.Add(new SqlParameter("@interest", cblInterest.Text));
cmdSave.Parameters.Add(new SqlParameter("@contact", cblContact.Text));
cmdSave.Parameters.Add(new SqlParameter("@name1", txtName1.Text));
cmdSave.Parameters.Add(new SqlParameter("@tel1", txtTel1.Text));
cmdSave.Parameters.Add(new SqlParameter("@name2", txtName2.Text));
cmdSave.Parameters.Add(new SqlParameter("@tel2", txtTel2.Text));
cmdSave.ExecuteNonQuery();
MessageBox.Show("Record Saved Successfully");
Closeconnect(connect());
}
I also need code to insert image into database along with the above data.