博客

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

  • Post author:
  • Post category:其他
Program Ex:

=================

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

版权声明：本文为bgu原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。