{"字符串或二进制数据将被截断。\\\\ n语句已被终止。“} [英] {"String or binary data would be truncated.\r\nThe statement has been terminated."}

问题描述

我尝试只填写一个字符串，但错误是相同的我所有的文本框都是varchar（50）

i have tryed to fill in only one string but the error is the same all my textboxes are varchar(50)

foreach (GridViewRow gvRowAssigment in GridViewAllAssigments.Rows)
            {
                var emp_assig_ref = new EMPLOYEES_ASSIGMENT_REFERENCE();
                emp_assig_ref.reference_name = gvRowAssigment.Cells[8].ToString();
                emp_assig_ref.reference_id = new Random().Next();

                var emp_assig_teh = new EMPLOYEES_ASSIGMENT_TECHNOLOGY();
                emp_assig_teh.technology_name = gvRowAssigment.Cells[7].ToString();
                emp_assig_teh.assigment_technology_id = new Random().Next();

                var emp_assig_tools = new EMPLOYEES_ASSIGMENT_TOOLS();
                emp_assig_tools.tools_name = gvRowAssigment.Cells[6].ToString();
                emp_assig_tools.assigment_tools_id = new Random().Next();

                var emp_assigment = new EMPLOYEES_ASSIGNMENT();
                emp_assigment.from_date = gvRowAssigment.Cells[0].ToString();
                emp_assigment.to_date = gvRowAssigment.Cells[1].ToString();
                emp_assigment.area = gvRowAssigment.Cells[2].ToString();
                emp_assigment.sector = gvRowAssigment.Cells[3].ToString();
                emp_assigment.company_name = gvRowAssigment.Cells[4].ToString();
                emp_assigment.description = gvRowAssigment.Cells[5].ToString();



                emp_assigment.employee_id = emp.employee_id;
                emp_assigment.assigment_id = new Random().Next();
                emp_assigment.assigment_tools_id = emp_assig_tools.assigment_tools_id;
                emp_assigment.assigment_technology_id = emp_assig_teh.assigment_technology_id;
                emp_assigment.reference_id = emp_assig_ref.reference_id;



            }

            db.AddToEMPLOYEES(emp);
            db.SaveChanges();

推荐答案

当您尝试存储的数据超过列大小时，通常会出现此错误在数据库中指定。请确认相同。

This error usually comes when you are trying to store data more then the column size specified in the database. Please confirm the same.

company_name 或 description 中的数据（可能其中一个字符串列大于表中定义的列，请尝试增加该表的列大小。

The data in company_name or description (probably one of the string columns) is bigger than the column defined in your table, try increasing the column size for that table.

这篇关于{"字符串或二进制数据将被截断。\\\\ n语句已被终止。“}的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！