从DataSet 返回XML 数据

最新推荐文章于 2019-07-24 11:28:03 发布

rockywu

最新推荐文章于 2019-07-24 11:28:03 发布

阅读量429

点赞数

分类专栏： XPath/CSS/XML/XSLT 文章标签： dataset xml object string null class

本文链接：https://blog.csdn.net/rockywu/article/details/7002152

版权

XPath/CSS/XML/XSLT 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

DataSet 常用操作Xml方法有DataSet.WriteXml()、DataSet.ReadXml()、DataSet.GetXml()

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Xml;
using System.Xml.XPath;
namespace UsingDataSet
{
    public partial class Form1 : Form
    {
        string strSQL = null;
        DataSet ds = null;
        public Form1()
        {
            InitializeComponent();
        }

        private void loadFromToolStripMenuItem_Click(object sender, EventArgs e)
        {
            strSQL = @"SELECT  [ProductID]
                              ,[ProductName]
                              ,[SupplierID]
                              ,[CategoryID]
                              ,[QuantityPerUnit]
                              ,[UnitPrice]
                              ,[UnitsInStock]
                              ,[UnitsOnOrder]
                              ,[ReorderLevel]
                              ,[Discontinued]
                          FROM [Products]";
           ds =SqlHelper.ExecuteDataSet(CommandType.Text, strSQL);
           dataGridView1.DataSource = ds.Tables[0];

        }    
       

        //WriteXml
        private void saveToFileToolStripMenuItem_Click(object sender, EventArgs e)
        {
            SaveFileDialog sfd = new SaveFileDialog();
            if (DialogResult.OK == sfd.ShowDialog())
            {
                string fileName = sfd.FileName;
                //this.ds.WriteXml(fileName, XmlWriteMode.WriteSchema);
                this.ds.WriteXml(fileName, XmlWriteMode.DiffGram);
            }
        }
        //ReadXml
        private void loadFromFileStripMenuItem_Click(object sender, EventArgs e)
        {
            OpenFileDialog ofd = new OpenFileDialog();
            if (DialogResult.OK == ofd.ShowDialog())
            {
                string fileName = ofd.FileName;
                this.ds.ReadXml(fileName, XmlReadMode.ReadSchema);
                dataGridView1.DataSource = this.ds.Tables[0];
            }
        }

        //GetXml
        private void getXmlToolStripMenuItem_Click(object sender, EventArgs e)
        {
            MessageBox.Show(this.ds.GetXml());
        }       
       
    }
}