textbox not saving full text...saving only first 128 characters?

[crao_a]

Hi all,
I am having issue with an input field called "Comments", which is a textbox. It saves only first 128 characters. The database is SQL Server 2005 and the column is nText. I tried it with nVarchar,... no use.
But, I could able to directly enter hundreds of characters using SQL Server itself.
Please help. Please find the code snippet below.
Thanks,
chandra

<tr><td class="tc" style="width: 140px" align="left">
      <asp:label id="Label9" runat="server" Width="88px">Comments:</asp:label>
      </td>						
      <td class="tc" colspan="3" align="left">
      <asp:textbox id="txtComments" runat="server" Width="512px" Height="62px" Rows="4" TextMode="MultiLine" CssClass="input"></asp:textbox></td>
</tr>

 

[giadich]

i don't see anything that would limit the size of the input text on the frontend code. what's the backend code like?

 

[crao_a]

Hi all,
The issue was fixed. The problem lies in the backend, where the tables were inserted/updated using stored procedures. The stored procedure for this table limiting the field lengh to ntext(128) instead of saying ntext.
Thanks,
Chandra