如何将DataTable中的数据生成XML文档？

Question

using System;
using System.Data;
using System.Xml;
using System.Data.SqlClient;public class Sample
{
  public static void Main()
  {
     DataSet dsNorthwind = new DataSet();     //Create the connection string.           
     String sConnect;
     sConnect="Data Source=localhost;Integrated Security=SSPI;Initial Catalog=Northwind";     
         
     //Create a connection object to connect to the northwind db.
     SqlConnection nwconnect = new SqlConnection(sConnect);     //Create a command string to select all the customers in the WA region.
     String sCommand = "Select * from Customers where Region='WA'";     //Create an adapter to load the DataSet.
     SqlDataAdapter myDataAdapter = new SqlDataAdapter(sCommand, nwconnect);     //Fill the DataSet with the selected records.
     myDataAdapter.Fill(dsNorthwind,"Customers");     //Load the document with the DataSet.
     XmlDataDocument doc = new XmlDataDocument(dsNorthwind);        //Display the XmlDataDocument.
     doc.Save(Console.Out);
    
  }
}

Answer 1

private string strconn="Provider=SQLOLEDB.1;User ID=sa;password=;Initial Catalog=通信录;Data Source=lhz";
public OleDbConnection cn = new OleDbConnection();      
public OleDbCommand cm = new OleDbCommand() ;
private OleDbDataAdapter da = new OleDbDataAdapter();
Xml  XMLFile1=new Xml();
cn.ConnectionString=strconn;
cm.Connection=cn;
cm.CommandText="select CustID,CustName,QQ,Email from tongxin";
da.SelectCommand=cm;
DataSet ds=new DataSet();
da.Fill(ds,"tongxin");
try
{
ds.WriteXml(Request.MapPath(XMLFile1.xml));
}
catch(Exception)
{
}
finally
{
DataGrid1.DataSource=ds;
DataGrid1.DataBind();
}