How to convert database table to xml file

Question

hi! Can any plz guide us how should we convert database table to .xml document. Thanks in advance.

naura pax · Answer

Hi Sheetal You can use XQuery/XPath tools in your stored procedure to directly convert your table data to xml document. Also you can retrieve data in your c# data and populate a dataset and use WriteXml method of database to create xml content and later save it as a file. Please mark as answered if useful.

Roei Bar · Answer

here is the class in order to build all database table return value from select into NestedXml with attributes private static XmlNode xmlBuilder(IDataReader reader) { XmlDocument xmlDoc = new XmlDocument(); XmlElement node = xmlDoc.CreateElement(Result); xmlDoc.AppendChild(node); ArrayList arr = new ArrayList(); for (int i = 0; i { arr.Add(reader.GetName(i)); } while (reader.Read()) { XmlElement row = xmlDoc.CreateElement(Row); for (int i = 0; i { XmlAttribute att = xmlDoc.CreateAttribute((String)arr[i]); att.Value = reader.GetValue(i).ToString(); row.Attributes.Append(att); } node.AppendChild(row); } return xmlDoc; }

naura pax · Answer

here is one good resource for xml handling techniques. http://msdn.microsoft.com/en-us/library/ms345117(SQL.90).aspx