最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
[ASP.net]从数据库中读取数据自动生成XML
时间:2008-01-19 编辑:简简单单 来源:一聚教程网
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();
=================
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();
相关文章
- VBS 批量Ping的项目讲解 09-19
- 如何封装一个Ajax函数介绍 09-16
- ASP实现加法验证码方法 09-16
- ASP错误捕获的几种常规处理方法介绍 09-16
- ajax实现城市三级联动的代码介绍 09-16
- asp中获取日期为星期几的技巧 09-14