Only first character of text inserting into DB

[bmayer]

I am using a SqlDataSource to put data into a database from three
TextBoxes.

The problem is that only the first character from the TextBoxes is
being inserted into the database.

The code:

<InsertParameters>
<asp:ControlParameter ControlID="TextBox2" Name="Text1"
Type="String" />
<asp:ControlParameter ControlID="TextBox3" Name="Text2"
Type="String" />
<asp:ControlParameter ControlID="TextBox4" Name="Text3"
Type="String" />
</InsertParameters>


The schema:

UID int
Text1 nvarchar(4000)
Text2 nvarchar(4000)
Text3 nvarchar(4000)

UID is a primary key, and auto-increments.

Any ideas?

 

[Guest]

Where is the SQL? It sounds like your SQLparameter doesn't have a length set.
Peter

 

[bmayer]

Ah thank you!

The stored procedure was using chars instead of nvarchars.