cant understand this error

[smitasunny]

hi,
i am getting the following error when i try to insert values into a table.Though it is working from the query analyser.
please help
thank you
smita

error:

System.Data.SqlClient.SqlException: String or binary data would be truncated. The statement has been terminated. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at XmlParseToDataset.WebForm1.Button1_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\xmlparsetodataset\webform1.aspx.cs:line 138

 

[mjb3030]

This happens when you try to insert a value into a column that cannot except it due to length restrictions. For example, you try to insert the value "visual basic" into a varchar(5) column.

 

[smitasunny]

hi,
thank you so much for ur help.it is working now.
smita