数据库导出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();

        }