SQL Exception Unhandled Error

[sari saji]

Here iam trying to insert some values to SQLServer 2005 Database.The following error displaying.I changed the corresponding column size,still the error persists.how can i sove this error-:

'String or binary data would be truncated.
The statement has been terminated'

[PsychoCoder]

That error message says you're trying to insert a value that's larger than the specified length in SQL. So you got 2 choices; increase the columns max length or shorten what you're trying to insert.

[sari saji]

I changed the corresponding column size,still the error persists

[PsychoCoder]

OK show us what you're doing to generate this error (show the code), also show the code of your table and tell us which variable generates this error message.

[sari saji]

This is the insert function in vb.net

Me.Personal_detailsdbTableAdapter.Insert(Me.Firstn ameTextBox.Text, Me.LastnameTextBox.Text, _
Me.PassportnoTextBox.Text, Me.PlaceofbirthTextBox.Text, _
Me.SexTextBox.Text, Me.DobDateTimePicker.Value)



This is the SQL Database Table Design

firstname nvarchar(50) Checked
lastname varchar(20) Checked
passportno nvarchar(50) Unchecked(Primary Key)
placeofbirth varchar(25) Checked
sex varchar(20) Checked
dob datetime Checked