DataAdapter.Update Problem

[Guest]

hi all,

I'm building a typed dataset from a sql table. Later programmatically inserting rows upon user data. When I execute DataAdapter.Update(ds). I get a constraint violation on one of the columns which is non-null column. Looking at the XML data in the dataset, I get an exception on a row that is not there in the table rather a row that should be next in the sequence.

For example If I insert 3 rows in the table in the dataset. Then i get error xyz column does not allow NULL data, insert fails. Can anybody guide me thru this problem.

Thanks in advance.
-HKM

 

[Aaron]

Check the SQL table for allow nulls. If Allow Nulls is not checked in the
design mode for your SQL table, SQL will reject the insert/update.

Aaron