oledb DataAdapter and DataTables

[Chris Mayers]

Hi,

Anyone know if it is possible to change the RowState of a DataRow in a
DataTable. I have a DataTable that has been built up from a combination of
reading from a database and some user input. What I want to do is to 'trick'
it into writing new rows into a different (but with the same fieldnames)
table in the database. I thought if I could change the RowState of all the
rows to 'DataRowState.Added' then I could use a DataAdapter.Update to
automagically create all the new rows.

Anyone got any thought on this, or suggestions of how best to make it work?

Thanks

Chris.

 

[Cor Ligthert]

Chris,

Probably you only need this,

http://msdn.microsoft.com/library/d...aadapterclassacceptchangesduringfilltopic.asp

However know what kind of primary key you are using. Otherwise it will give
you probably only concurrency errors.

Cor