Loading

Programmatically creating Xml from DataBase Table

Sanjeev Shrestha

Hi,

First, I havee a table and I have to create xml programmatically using C#. And secondly,

Please let me know, How can I create xml file of other tables, if the tablename is passed as a parameter in the method using loops.
For example:
public void Parse( string Product)
{
XmlNode xmlnode = null;

XmlDocument doc = new XmlDocument();
???????????
}

How do I do that?

Thank you

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

PHANI NADIGADDA20y ago
You can also write a SQL Statement using FOR XML EXPLICIT. It helps you to tranform the results from query execution into XML document. Then you can save the result into XML format as you want.

ALL THE BEST
0
Mike Hildner20y ago
Hi,

There's lots of ways to do this...

One way would be to load your data from the database into a DataSet/DataTable and then use one of the .WriteXml() methods.

What database are you running against?

It'd be real easy to have a method that took a table name as a parameter and then do a SELECT * FROM MyTableName to return a DataTable.

What kind of code do you have so far?

Regards,
Mike
0