i am having error ....details are
ASP.Net application...i n which I have a textbox
<asp:TextBox ID="Other" TextMode=Single Line CssClass="servi ceBox" Width="250" Height="45" Runat="server" MaxLength="1000 " /></asp:TextBox>
and this textbox is in a <asp:Repeater > which has the count of 35.
The textbox value is stored in the SQL DB
And the field data-type in the SQL DB is VARCHAR(1000)
Now the problem comes when I enter the text in the textbox with length more than 100(hundred) characters . The error that shows up is
----------------------
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.Sql Client.SqlExcep tion: String or binary data would be truncated. The statement has been terminated.
Stack Trace:
[SqlException: String or binary data would be truncated.
The statement has been terminated.]
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery() +195
XXXXXX.SqlHelpe r.ExecuteNonQue ry(SqlConnectio n connection, CommandType commandType, String commandText, SqlParameter[] commandParamete rs)
XXXXXX.SqlHelpe r.ExecuteNonQue ry(String connectionStrin g, CommandType commandType, String commandText, SqlParameter[] commandParamete rs)
XXXXXXL.SqlHelp er.ExecuteNonQu ery(String connectionStrin g, String spName, Object[] parameterValues )
XXXXXX.Utilitie s.InsertCustome rService(Int32 MemberID, String OfferID, String CantAccess, String WontFunction, String Other)
----------------------
Now what i couldnt get is....the field length gives error when i give text more than 100 characters..... ..whats the deal with it..plz help asap!