DataTable.Load() fills in schema!!

B

Benton

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DataTable Load Issue 6
SELECTing only the first n records from a database 6
How is System.Data.DataTable.Load() determining whether a column is a primary key? 1
System.OutOfMemoryException in DataAdapter 4
Using DataAdapter.Fill to return a DataTable complete with schema information 2
How to specify a schema when filling a DataTable from a .csv file 3
Batch Update Problem 4
Internal .Net Framework Data Provider error 12 0

Top