mhdashtii
شنبه 28 اردیبهشت 1392, 10:05 صبح
وقتی تکه برنام زیر را اجرا می کنم این ارور را میده
String or binary data would be truncated.
The statement has been terminated.
SqlConnection con1 = new SqlConnection(Conn);
con1.Open();
SqlCommand cmd1 = new SqlCommand();
cmd1.Connection = con1;
cmd1.CommandText = "insert into personel (cod,name,family,father,tt,ms,she,meli,tel,mobile, ezdevaj,takalof,farzand,madrak,reshtah,bima,shbima ,adress) values ('" + codp.Text + "','" + name.Text + "','" + family.Text + "','" + father.Text + "','" + tavalod + "','" + sodor.Text + "','" + shenasnamah.Text + "','" + meli.Text + "','" + tel.Text + "','" + mob.Text + "','" + comboBox1.Text + "','" + textBox2.Text + "','" + textBox7.Text + "','" + comboBox6.Text + "','" + comboBox7.Text + "','" + textBox4.Text + "','" + textBox3.Text + "', '"+adres.Text+"') ";
cmd1.ExecuteNonQuery();
con1.Close();
String or binary data would be truncated.
The statement has been terminated.
SqlConnection con1 = new SqlConnection(Conn);
con1.Open();
SqlCommand cmd1 = new SqlCommand();
cmd1.Connection = con1;
cmd1.CommandText = "insert into personel (cod,name,family,father,tt,ms,she,meli,tel,mobile, ezdevaj,takalof,farzand,madrak,reshtah,bima,shbima ,adress) values ('" + codp.Text + "','" + name.Text + "','" + family.Text + "','" + father.Text + "','" + tavalod + "','" + sodor.Text + "','" + shenasnamah.Text + "','" + meli.Text + "','" + tel.Text + "','" + mob.Text + "','" + comboBox1.Text + "','" + textBox2.Text + "','" + textBox7.Text + "','" + comboBox6.Text + "','" + comboBox7.Text + "','" + textBox4.Text + "','" + textBox3.Text + "', '"+adres.Text+"') ";
cmd1.ExecuteNonQuery();
con1.Close();