可以使用ReadXml()和WriteXml()方法分别读取数据集中的数据(和模式),写入XML文件。
实例:将数据从数据集写到XML文件中
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
![](https://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif)
using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Data.SqlClient;namespace WriteXML{ class Program { static void Main(string[] args) { string connString = @" server =.; integrated security =true; database =northwind"; string qry = @" select productname,unitprice from products"; SqlConnection conn = new SqlConnection(connString); try { SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(qry, conn); conn.Open(); DataSet ds = new DataSet(); da.Fill(ds, "products"); ds.WriteXml(@"c:\\myxml.xml"); Console.WriteLine("The file is Created"); } catch (Exception e) { Console.WriteLine("Error: " + e); } finally { conn.Close(); } } }}
给XML文件提供完整的路径,把它放在解决方案目录中,如果只提供文件名,它就会放在WriteXML项目目录的bin\Release子目录下。