sir when i use following code in c# .Net connected architecture for insert data in database
note: database is service based database and data provider is sqlclient.
the main point is that when i am insert the data in database using this code one error occur at run time
private void insertin_Click(object sender, EventArgs e)
{
try
{
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Afzal Mozan\Desktop\ADO.Net connectivity\ADO.Net connectivity\Database1.mdf;Integrated Security=True;User Instance=True");
string str;
if (malein.Checked == true)
{
str = malein.Text;
}
else { str = femalein.Text; }
con.Open();
SqlCommand cmd = new SqlCommand("insert into student(fname,lname,gender,age,address)values('"+fnamein+"','"+lnamein+"','"+str+"','"+agein+"','"+addin+"')", con);
if (cmd.ExecuteNonQuery() > 0)
{
MessageBox.Show("Data Inserted successfully");
}
else
{
MessageBox.Show("Data not Inserted ");
}
}
catch (Exception e)
{
MessageBox.Show("Inner Error");
}
}
The error is:{"String or binary data would be truncated.\r\nThe statement has been terminated."}