|
從SQL內(nèi)讀數(shù)據(jù)到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/output.xml"; SqlConnection conn = new SqlConnection("server=localhost;uid=sa;pwd=;database=db"); String strSql = "SELECT FirstName, LastName FROM employees"; 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(); } } |
|
|
