Hi there,

I was loading a datatable with Dataadapter's Fill() method. Then, I could
add a new record to the datatable and it won't complain about not null
columns until I called the Dataadapter's Update() method. That's OK for me.

Now I am experimenting with the Load() method of a datatable (.NET 2.0) to
fill it from a datareader, but as soon as I add a new row, I get an
exception from the datatable complaining about the not null columns. Is
there a way to avoid that?

Best Regards,

-Benton

Use ISNULL in your SQL Queries

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.ma.../13/63199.aspx
----------------------------------------------------------------------------

"Benton" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi there,
>
> I was loading a datatable with Dataadapter's Fill() method. Then, I could
> add a new record to the datatable and it won't complain about not null
> columns until I called the Dataadapter's Update() method. That's OK for
> me.
>
> Now I am experimenting with the Load() method of a datatable (.NET 2.0) to
> fill it from a datareader, but as soon as I add a new row, I get an
> exception from the datatable complaining about the not null columns. Is
> there a way to avoid that?
>
> Best Regards,
>
> -Benton
>
>