XML DataSets files

[ofsouto]

Hi, dear

I need to save the result of some queries as XML files.
I know that I can use datasets.
I would like to know if it's possible to save these queries in only one XML file.
Is it possible to read and convert this XML file in datasets?

Thank you very much.

Obede
Brazil

 

[ca8msm]

Yes it is. Have a look at the ReadXML and WriteXML methods of the dataset.

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[ofsouto]

I intend to write more than one query in only one XML file.
WriteXML permits write/save only one query.
After write/save XML file I need to read/convert to dataset.

Thank you.

 

[ca8msm]

WriteXML permits write/save only one query.

It depends what is in your dataset. You could put two queries in different tables and write them both out.

After write/save XML file I need to read/convert to dataset.

That's what the ReadXML method is for.


----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[ofsouto]

Thank you ca8msm.
I have solved the problem.