Insert whole dataset in to a db table - VB.Net 2005

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a very simple question. I have a typed dataset, dsOrders, bound to
tbOrders Access table. Now I must write a function to copy all the records
from the dsOrders to the Access table tbOrdersDone. How can it be done?
 
Federico,

It is a simple question which is asked almost twice a day. This is in the
current versions not standard as the database does not have the right
schema. It is on the list for one of the next versions.

As your schema is equeal to the database schema and all your rows have the
rowstate "added"

Than you can try to create an oledbdataadapter let say "da"
Than you can try to use an da.fillschema(dummydataset, the right second
property)

http://msdn2.microsoft.com/en-us/library/152bda9x.aspx

than use an oledbcommandbuilder
and than with yourdataset
da.update(yourdataset)

I hope this helps,

Cor
 
Back
Top