Recordset to Dataset question (with XML)

[Worrow]

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:

[PlausiblyDamp]

The OleDbDataAdapter class will allow you to fill a dataset from an ADODB.Recordset, that might be the easiest way to approach this problem.

[Worrow]

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...