amir-aa
پنج شنبه 06 بهمن 1390, 11:16 صبح
string connectionstring = "Data Source=.;Initial Catalog=anbardar;User Id=sa;Password=1";
SqlConnection conn = new SqlConnection(connectionstring);
string query = "insert into checks(name,idc,mablagh,mablaghh,date,daryafti) values('" + txtProNet1.Text + "','" + txtProNet2.Text + "','" + txtProNet6.Text + "','" + textBox9.Text + "','"+maskedTextBox1.Text.ToString()+"','" + checkBox2.Checked + "')";
SqlCommand cm = new SqlCommand(query, conn);
conn.Open();
cm.ExecuteNonQuery();
conn.Close();
textBox9.Text = "";
txtProNet1.Text = "";
txtProNet2.Text = "";
txtProNet6.Text = "";
اشکال این کد کجاست؟
توی اون maskedTextBox ایراد داره.....توی دیتابیسم فیلدش از نوع varchar هستش.
اینم ارور
String or binary data would be truncated.
The statement has been terminated.
SqlConnection conn = new SqlConnection(connectionstring);
string query = "insert into checks(name,idc,mablagh,mablaghh,date,daryafti) values('" + txtProNet1.Text + "','" + txtProNet2.Text + "','" + txtProNet6.Text + "','" + textBox9.Text + "','"+maskedTextBox1.Text.ToString()+"','" + checkBox2.Checked + "')";
SqlCommand cm = new SqlCommand(query, conn);
conn.Open();
cm.ExecuteNonQuery();
conn.Close();
textBox9.Text = "";
txtProNet1.Text = "";
txtProNet2.Text = "";
txtProNet6.Text = "";
اشکال این کد کجاست؟
توی اون maskedTextBox ایراد داره.....توی دیتابیسم فیلدش از نوع varchar هستش.
اینم ارور
String or binary data would be truncated.
The statement has been terminated.