C#中ADO.NET的DataSet读写XML文档

最新推荐文章于 2024-03-04 09:38:46 发布

转载最新推荐文章于 2024-03-04 09:38:46 发布 · 1.1k 阅读

文章标签：

#dataset #xml #c# #string #文档 #schema

C# 专栏收录该内容

52 篇文章

订阅专栏

本文介绍如何使用C#将数据库中的数据加载到DataSet，并将其写入XML文件。此外，还展示了如何从XML文件读取数据到DataSet中，包括仅输出数据和同时输出数据与模式的方法。

1.加载XML文档中的数据到DataSet中：
使用ReadXML()方法，根据XML文档中的数据构建DataSet；
2.将DataSet中的数据写入XML文档：
使用WriteXML()方法，可以选择只输出数据，也可以输出数据和模式。

TestDataSetXML.cs:

using System;
using System.Data.SqlClient;
using System.Data;
namespace Magci.Test.DataAccess.TestDataSetXML
{
    class Program
    {
        static void Main(string[] args)
        {
            string source = @"server=./sqlexpress; integrated security=SSPI; database=MGC";
            string select = "Select id, username, password FROM TestUser";
            using (SqlConnection conn = new SqlConnection(source))
            {
                conn.Open();
                DataSet ds = new DataSet();
                CreateTable(ds);
                SqlDataAdapter da = new SqlDataAdapter(select, conn);
                
                da.Fill(ds, "TestUser");
                DumpDataSet(ds, "Data From database:");
                //将DataSet中的数据写入XML文档
                ds.WriteXml("WithoutSchema.xml");
                ds.WriteXml("WithSchema.xml", XmlWriteMode.WriteSchema);
                //加载XML文档中的数据到DataSet中
                DataSet dsFromXML = new DataSet();
                dsFromXML.ReadXml("WithoutSchema.xml");
                DumpDataSet(dsFromXML, "Data From XML:");
                conn.Close();
            }
            Console.ReadLine();
        }
        public static void CreateTable(DataSet ds)
        {
            DataTable dt = new DataTable("TestUser");
            DataColumn id = new DataColumn("id", typeof(int));
            id.AllowDBNull = false;
            id.AutoIncrement = true;
            id.AutoIncrementSeed = 1;
            DataColumn username = new DataColumn("username", typeof(string));
            username.AllowDBNull = false;
            DataColumn password = new DataColumn("password", typeof(string));
            password.AllowDBNull = false;
            dt.Columns.Add(id);
            dt.Columns.Add(username);
            dt.Columns.Add(password);
            ds.Tables.Add(dt);
        }
        public static void DumpDataSet(DataSet ds, string message)
        {
            Console.WriteLine(message);
            foreach (DataRow row in ds.Tables["TestUser"].Rows)
            {
                Console.WriteLine("id: {0}, username: {1}, password: {2}, RowState: {3}", row[0], row[1], row[2], row.RowState);
            }
        }
    }
}

WithoutSchema.xml:

<?xml version="1.0" standalone="yes"?>
<NewDataSet>
  <TestUser>
    <id>1</id>
    <username>magci</username>
    <password>123</password>
  </TestUser>
  <TestUser>
    <id>2</id>
    <username>mgc0</username>
    <password>111</password>
  </TestUser>
  <TestUser>
    <id>3</id>
    <username>mgc1</username>
    <password>123456</password>
  </TestUser>
  <TestUser>
    <id>4</id>
    <username>mgc2</username>
    <password>123456</password>
  </TestUser>
  <TestUser>
    <id>5</id>
    <username>mgc3</username>
    <password>123456</password>
  </TestUser>
  <TestUser>
    <id>6</id>
    <username>mgc4</username>
    <password>123456</password>
  </TestUser>
  <TestUser>
    <id>8</id>
    <username>mgc111</username>
    <password>000</password>
  </TestUser>
  <TestUser>
    <id>9</id>
    <username>mgc112</username>
    <password>000</password>
  </TestUser>
  <TestUser>
    <id>10</id>
    <username>mgc113</username>
    <password>000</password>
  </TestUser>
  <TestUser>
    <id>7</id>
    <username>mgc5</username>
    <password>000000</password>
  </TestUser>
  <TestUser>
    <id>11</id>
    <username>mgc114</username>
    <password>000</password>
  </TestUser>
  <TestUser>
    <id>12</id>
    <username>mgc115</username>
    <password>000</password>
  </TestUser>
  <TestUser>
    <id>13</id>
    <username>mgc116</username>
    <password>000</password>
  </TestUser>
  <TestUser>
    <id>14</id>
    <username>mgc117</username>
    <password>000</password>
  </TestUser>
  <TestUser>
    <id>15</id>
    <username>mgc118</username>
    <password>mmm</password>
  </TestUser>
</NewDataSet>

WithSchema.xml:

<?xml version="1.0" standalone="yes"?>
<NewDataSet>
  <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
      <xs:complexType>
        <xs:choice minOccurs="0" maxOccurs="unbounded">
          <xs:element name="TestUser">
            <xs:complexType>
              <xs:sequence>
                <xs:element name="id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" type="xs:int" />
                <xs:element name="username" type="xs:string" />
                <xs:element name="password" type="xs:string" />
              </xs:sequence>
            </xs:complexType>
          </xs:element>
        </xs:choice>
      </xs:complexType>
    </xs:element>
  </xs:schema>
  <TestUser>
    <id>1</id>
    <username>magci</username>
    <password>123</password>
  </TestUser>
  <TestUser>
    <id>2</id>
    <username>mgc0</username>
    <password>111</password>
  </TestUser>
  <TestUser>
    <id>3</id>
    <username>mgc1</username>
    <password>123456</password>
  </TestUser>
  <TestUser>
    <id>4</id>
    <username>mgc2</username>
    <password>123456</password>
  </TestUser>
  <TestUser>
    <id>5</id>
    <username>mgc3</username>
    <password>123456</password>
  </TestUser>
  <TestUser>
    <id>6</id>
    <username>mgc4</username>
    <password>123456</password>
  </TestUser>
  <TestUser>
    <id>8</id>
    <username>mgc111</username>
    <password>000</password>
  </TestUser>
  <TestUser>
    <id>9</id>
    <username>mgc112</username>
    <password>000</password>
  </TestUser>
  <TestUser>
    <id>10</id>
    <username>mgc113</username>
    <password>000</password>
  </TestUser>
  <TestUser>
    <id>7</id>
    <username>mgc5</username>
    <password>000000</password>
  </TestUser>
  <TestUser>
    <id>11</id>
    <username>mgc114</username>
    <password>000</password>
  </TestUser>
  <TestUser>
    <id>12</id>
    <username>mgc115</username>
    <password>000</password>
  </TestUser>
  <TestUser>
    <id>13</id>
    <username>mgc116</username>
    <password>000</password>
  </TestUser>
  <TestUser>
    <id>14</id>
    <username>mgc117</username>
    <password>000</password>
  </TestUser>
  <TestUser>
    <id>15</id>
    <username>mgc118</username>
    <password>mmm</password>
  </TestUser>
</NewDataSet>

转自：http://mgc.name/article.asp?id=648