I have a FormView in asp.net 2.0 written in VS2005 b2, and I am getting this error concerning a textbox. The error terminates the SQL stating that the string would be truncated. It inidcates that the reason is displayed below in the trace but there is nothing there that gives me any reason for the error.
I was able to narrow down the error to a single textbox that I have that is setup as follows:
<asp:TextBox ID="ReasonTextBox" TextMode="MultiLine" Rows="4" runat="server" Text='<%# Bind("Reason") %>' BorderStyle="Solid" BorderWidth="1px" Width="621px" Font-Names="Verdana" Font-Size="Small"></asp:TextBox>
In SQL I have the column setup as varchar (250).
I am only entering 3 lines of data within this field. I would think that I had more than enough room designated for this field.
Anyone know what this is about and how I can fix it? I even expanded the column parameters in SQL to 500 and that wouldn't go through.
Thanks for your thoughts.
Regards,
MustangThis has been fixed. I realized that I was editing the non-production SQL server.
Once I expanded the field length on the production server, all was well.
Thanks.
I was able to narrow down the error to a single textbox that I have that is setup as follows:
<asp:TextBox ID="ReasonTextBox" TextMode="MultiLine" Rows="4" runat="server" Text='<%# Bind("Reason") %>' BorderStyle="Solid" BorderWidth="1px" Width="621px" Font-Names="Verdana" Font-Size="Small"></asp:TextBox>
In SQL I have the column setup as varchar (250).
I am only entering 3 lines of data within this field. I would think that I had more than enough room designated for this field.
Anyone know what this is about and how I can fix it? I even expanded the column parameters in SQL to 500 and that wouldn't go through.
Thanks for your thoughts.
Regards,
MustangThis has been fixed. I realized that I was editing the non-production SQL server.
Once I expanded the field length on the production server, all was well.
Thanks.