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?

[Peter Bromberg [C# MVP]]

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

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"bm****@mnepilepsy.net" wrote:

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?

[bmayer]

Ah thank you!

The stored procedure was using chars instead of nvarchars.

Peter wrote:

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

Any ideas?