|
|
[ASP.net]从数据库中读取数据自动生成XML |
|
|
作者:未知 来源:月光软件站 加入时间:2005-2-28 月光软件站 |
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();

|
|
相关文章:相关软件: |
|