分类广告


推荐文章

  • 没有找到任何内容!
您当前的位置:中国站长下载网络编程ASP专区 → 文章内容

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

  • 作者:佚名    来源:不详    发布时间:2005-12-31 11:32:17
  • 字体大小:
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();