C#从数据库读取数据到DataSet并保存到xml文件的方法

using System;using System.Data;using System.Xml;using System.Data.SqlClient;using System.IO;public class TestWriteXML{  public static void Main()  {    String strFileName = c:/temp/out.xml;    SqlConnection conn = new SqlConnection(server=localhost;uid=sa;pwd=;database=db);    String strSql = SELECT name,age FROM people;    SqlDataAdapter adapter = new SqlDataAdapter();    adapter.SelectCommand = new SqlCommand(strSql, conn);    // Build the DataSet    DataSet ds = new DataSet();    adapter.Fill(ds, employees);    // Get a FileStream object    FileStream fs = new FileStream(strFileName, FileMode.OpenOrCreate, FileAccess.Write);    // Apply the WriteXml method to write an XML document    ds.WriteXml(fs);    fs.Close();  }}