The statement has been terminated. String or binary data would be truncated
这个错误是啥意思呀?
折磨我一下午了。
一段SQL语句 由很多LABEL控件的值组合起来的
提交后就提示标题里的错误
晕死了
把组合起来的字符串输出 COPY到SQLSERVER执行没问题
将其付给另个STRING变量 再执行也没错
就是直接在程序里执行就出错
救救我吧~~~
代码:(少写几个,其实是很长的字符串)
string Sql="insert into tbl_enroll(Enroll_name,Enroll_sex," +
"Enroll_nation,Enroll_party,Enroll_birth,Enroll_special_id) " +
"values('"+lblName.Text.ToString().Trim()+
"','"+lblSexId.Text.ToString().Trim()+
"','"+lblNationId.Text.ToString().Trim()+
"','"+lblPartyId.Text.ToString().Trim()+
"',convert(datetime,'"+lblBirth.Text.ToString().Trim()+"')," +
"'" + lblSpecialId.Text.ToString().Trim()+ "')";