How to import XML into SQL Server

Copy SQL datas to XML. That means import all datas from SQL to XML.

Import Xml from SQL using C# :


ad = new SqlDataAdapter("select * from TABLENAME", sqlcon); dt = new DataTable(); DataSet ds1 = new DataSet(); ad.Fill(ds1); ds1.WriteXml(Server.MapPath("XML1.xml"));

Import Xml from SQL using VB :

ad = new SqlDataAdapter("select * from TABLENAME", sqlcon) dt = new DataTable() DataSet ds1 = new DataSet() ad.Fill(ds1) ds1.WriteXml(Server.MapPath("XML1.xml"))