DataAdapter.Update Problem

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
Wed Feb 04 10:21:28 CST 2004

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

=?Utf-8?B?SEtN?= <anonymous@discussions.microsoft.com> wrote in
news:1FB48F98-C6FA-4027-AA2B-6407E6BE726A@microsoft.com:

>
> 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
>