String or binary data would be truncated.

Posted by Parthibansk under ASP.NET on 11/14/2018 | Points: 10 | Views : 243 | Status : [Member] | Replies : 2
i get dis error on form registration..it works locally fine but on server upload
i encounter dis error

String or binary data would be truncated.
The statement has been terminated.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: String or binary data would be truncated.
The statement has been terminated.

Source Error:


Line 170: SqlCommand cmd = new SqlCommand(sqlstr, con);
Line 171: con.Open();
Line 172: cmd.ExecuteNonQuery();
Line 173: con.Close();
Line 174:




Responses

Posted by: Aolservicemail on: 12/5/2018 [Member] Starter | Points: 25

Up
0
Down
Are you unable to download or install latest version of AOL gold? Are you experience with AOL issues from long times, don’t worry , now available our techies 24/7 hour for all type issues help, there you can connect with expert technicians on call our toll free number 1-888-270-8375 for <a title="AOL Gold Download" href="https://www.bitcoincustomerservicenumber.com/aol-desktop-gold-customer-support.html">AOL Gold Download</a>
.

Parthibansk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vedikaledange on: 1/9/2019 [Member] Starter | Points: 25

Up
0
Down
This is a SqlException and occurs when one or more SQL constraints are not met. You are trying to insert larger data to a column with a specified length that it cannot accommodate.

Try looking at InnerException of the error message, or else try putting a breakpoint and manually check for each column value.

DOT NET

Parthibansk, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response