string sql = "SELECT id,name FROM content FOR XML AUTO,XMLDATA"; SqlConnection conn =new SqlConnection( System.Configuration.ConfigurationSettings.AppSettings["testDataBase"] ); SqlCommand cmd=new SqlCommand(sql,conn); conn.Open(); XmlTextReader objXmlReader = (XmlTextReader)cmd.ExecuteXmlReader(); DataSet ds = new DataSet(); ds.DataSetName = "XML"; ds.ReadXml(objXmlReader,XmlReadMode.Fragment); ds.WriteXml(Server.MapPath("XML.xml")); conn.Close();