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

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.sharejs.com/codes/csharp/7773

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

标签：

查看更多关于C#从数据库读取数据到DataSet并保存到xml文件的详细内容...