ASPForums.Net RSS Feedhttp://www.aspforums.net/Handlers/RSS.ashxLatest additions to the content that appears on ASPForums.Net(c) 2019 www.aspforums.com. All rights reserved.ExecuteNonQuery Error: String or binary data would be truncated. The statement has been terminated<p>Hi <a class="username" rel="micah">micah</a>,</p> <p>Its the error because of datatype size you are passing for inserting data to that field.</p> <p>Suppose i you have declared a field named name varchar[20] and trying to insert more than 20 characters then you will get an error like "String or binary data would be truncated".</p> <p>So please check all the field.</p>https://www.aspforums.net:443/Threads/225597/ExecuteNonQuery-Error-String-or-binary-data-would-be-truncated-The-statement-has-been-terminated/https://www.aspforums.net:443/Threads/225597/ExecuteNonQuery-Error-String-or-binary-data-would-be-truncated-The-statement-has-been-terminated/Wed, 14 Nov 2018 03:09:33 GMTExecuteNonQuery Error: String or binary data would be truncated. The statement has been terminated<p>hi micah...</p> <p>check the size of the datatype in database table.</p> <p>suppose name varchar(20),and if you are inserting more than 20 characters,the error comes saying that "string or binary data would be truncated".</p>https://www.aspforums.net:443/Threads/225597/ExecuteNonQuery-Error-String-or-binary-data-would-be-truncated-The-statement-has-been-terminated/https://www.aspforums.net:443/Threads/225597/ExecuteNonQuery-Error-String-or-binary-data-would-be-truncated-The-statement-has-been-terminated/Wed, 14 Nov 2018 03:10:02 GMT