資料庫匯出xml檔案

 public static void GetXML()
        {

       //串連資料庫，得到資料
           DataSet ds = new DataSet();
           DataTable dt = new DataTable("test");
            try
            {
                OleDbCommand comm = new OleDbCommand("select * from test", Conn);
                OleDbDataAdapter da = new OleDbDataAdapter(comm);
                da.Fill(dt);
                ds.Tables.Add(dt);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                conn.Close();
            }

            //轉換成xml
            string sXml = ds.GetXml();

          //建立檔案名稱
            string sFileName = @"F:/a.xml"; //假設你儲存成f盤目錄下a.xml

           //建立檔案
            StreamWriter sr = File.CreateText(sFileName );
            sr.WriteLine(sXml);
            sr.Close();

        }