根据数据库生成xml二法- ASP.NET - 软晨网（RuanChen.com）

技术文章搜索

关键字

出处:互联网 整理: 软晨网（RuanChen.com） 发布: 2009-11-03 浏览: 34 ::

收藏到网摘: n/a

SqlConnection conn = new SqlConnection();

conn.ConnectionString = "Server=127.0.0.1;User ID=sa;Password=fdahgdrethj31313210212121;Database=northwind;Persist Security Info=True";

conn.Open();

SqlDataAdapter da = new SqlDataAdapter("select * from 表", conn);

SqlCommandBuilder thisBulder = new SqlCommandBuilder(da);

DataSet ds = new DataSet();

da.Fill(ds);

ds.WriteXml(@"C:\temp.xml");

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

private void WriteXmlToFile(DataSet thisDataSet)