Recordset to Dataset question (with XML)

W

Worrow

Well-known member
Joined
Jul 10, 2003
Messages
67
Hi, I am trying to transfer a xml file generated by vb6 recordset from a server side application to a compact framework application(which is written in vb.net) and fill the dataset with this xml file. However, I got nothing in return. Is there anyway to change the recordset xml format to dataset xml format?

Any idea? :confused:
 
The OleDbDataAdapter class will allow you to fill a dataset from an ADODB.Recordset, that might be the easiest way to approach this problem.
 
Thanks for your reply.

I ended up using xmltextreader to read the data and insert it into the database. Surprisingly to me, this approach is faster than using dataset to fill in the tables. I wonder why...
 
Back
Top