ADO.NET Native storage format is XML (Extensible Markup Language)
ADO Native storage format is ADTD (Advanced Data Table Gram)
important difference between ado.net and ado was disconnected and
connection oriented architecture all are know this one very well. In
this following example how to easily convert dataset into xml file with
in two line of code it very simple also.
According to me
whenever you handle small amount of data go to following idea its
working very good effect. If it's your database is huge do not apply
these logic it acquire more memory.
sqlcon = new SqlConnection("server=localhost;database=veera;integrated
SqlDataAdapter sqladap = new SqlDataAdapter("select * from Designation",
DataSet ds = new DataSet("Veera");
//load data from dataset to xmldatadocument
XmlDataDocument xmldoc = new XmlDataDocument(ds);
xmldoc.Save(Application.StartupPath + "\\mydsXml.xml");