DataSet序列化输出到XML(并指定输出XML标准)

 public partial class Form1 : Form
    {
        DataSet ds = new DataSet();

        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {        
            string str = ds.GetXml();
            SaveToXml(str);
        }

        /// <summary>
        /// 输出指定文件到指定文件
        /// </summary>
        /// <param name="str"></param>
        private void SaveToXml(string str)
        { 
            string path = "d://Customers.xml";
            FileInfo fi = new FileInfo(path);

            if (!fi.Exists)
            {              
                using (StreamWriter sw = fi.CreateText())
                {
                    sw.WriteLine(@"<?xml version='1.0' encoding='UTF-8'?>");
                    sw.WriteLine("" + str.Trim() + "");
                    sw.Close();
                }               
            }
            else
            {               
                StreamWriter fw = new StreamWriter(path);
                fw.WriteLine(@"<?xml version='1.0' encoding='UTF-8'?>");
                fw.WriteLine("" + str.Trim() + "");
                fw.Close();               
            }
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            string MyConnectionString = "Server=127.0.0.1;Database=testdb;User ID=sa;Password=newman2007;Connect Timeout=20;Pooling=True;Min Pool Size=1;Max Pool Size=100;Persist Security Info=False;Asynchronous Processing=true;Integrated Security=false;";           

            SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM CashBillInfo", MyConnectionString);
           
            try
            {
                ds.DataSetName = "SCSAT-E1";
                da.Fill(ds, "record");
            }
            catch (Exception ex)
            {
                MessageBox.Show("Operation failed: " + ex.ToString(), Application.ProductName + " - Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }
            dataGridView1.DataSource = ds;
            dataGridView1.DataMember = "record";
        }       

    }

 

输出效果:

<?xml version='1.0' encoding='UTF-8'?>
<SCSAT-E1>
  <record>
    <xh>1</xh>
    <nsrsbh>12344777</nsrsbh>
    <skjbh>00001</skjbh>
    <sklsh>201092222</sklsh>
    <sksj>2233333</sksj>
    <hjje>23.00</hjje>
  </record>
  <record>
    <xh>2</xh>
    <nsrsbh>33334</nsrsbh>
    <skjbh>5555</skjbh>
    <sklsh>66666</sklsh>
    <sksj>6666</sksj>
    <hjje>33.00</hjje>
  </record>
  <record>
    <xh>3</xh>
    <nsrsbh>5555</nsrsbh>
    <skjbh>6677</skjbh>
    <sklsh>7788</sklsh>
    <sksj>555</sksj>
    <hjje>66.00</hjje>
  </record>
</SCSAT-E1>