[ASP.net]从数据库中读取数据自动生成XML

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(); 

原文地址:https://www.cnblogs.com/xiaofengfeng/p/1813180.html