- 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();
- }
- }
- //该片段来自于http://www.codesnippet.cn/detail/040920135636.html
来源: http://www.codesnippet.cn/detail/040920135636.html