DataTable.ReadXmlSchema 方法

定義

命名空間:: System.Data

組件:: System.Data.dll

組件:: netstandard.dll

重要

部分資訊涉及發行前產品，在發行之前可能會有大幅修改。 Microsoft 對此處提供的資訊，不做任何明確或隱含的瑕疵擔保。

將 XML 架構讀取到 DataTable.

多載

名稱	Description
ReadXmlSchema(XmlReader)	利用指定的 XmlReader. 將 XML 結構讀入 DataTable 。
ReadXmlSchema(String)	從指定檔案讀取 XML 架構 DataTable 。
ReadXmlSchema(TextReader)	利用指定的 TextReader. 將 XML 結構讀入 DataTable 。
ReadXmlSchema(Stream)	利用指定的串流讀取 XML 架構。DataTable

備註

使用該ReadXmlSchema方法來建立 .DataTable 該結構包含表格、關聯與約束定義。

要為 XML 文件撰寫結構，請使用該 WriteXmlSchema 方法。

XML 架構依據 XSD 標準解讀。

ReadXmlSchema通常在呼叫ReadXml用來填入的方法DataTable之前，會先呼叫該方法。

ReadXmlSchema(XmlReader)

利用指定的 XmlReader. 將 XML 結構讀入 DataTable 。

public:
 void ReadXmlSchema(System::Xml::XmlReader ^ reader);

public void ReadXmlSchema(System.Xml.XmlReader reader);

member this.ReadXmlSchema : System.Xml.XmlReader -> unit

Public Sub ReadXmlSchema (reader As XmlReader)

參數

reader: XmlReader

它們 XmlReader 用來讀取結構資訊。

範例

接下來的主控台應用程式會建立一個新的 DataTable，並將該資料表的結構寫入 MemoryStream。接著，範例會建立一個新 DataTable 結構，並從儲存的 XML 架構讀取其結構，來源為 a XmlTextReader （繼承自 XmlReader）。

private static void DemonstrateReadWriteXMLSchemaWithReader()
{
    DataTable table = CreateTestTable("XmlDemo");
    PrintSchema(table, "Original table");

    // Write the schema to XML in a memory stream.
    System.IO.MemoryStream xmlStream =
        new System.IO.MemoryStream();
    table.WriteXmlSchema(xmlStream);

    // Rewind the memory stream.
    xmlStream.Position = 0;

    DataTable newTable = new DataTable();
    System.Xml.XmlTextReader reader =
        new System.Xml.XmlTextReader(xmlStream);
    newTable.ReadXmlSchema(reader);

    // Print out values in the table.
    PrintSchema(newTable, "New table");
}

private static DataTable CreateTestTable(string tableName)
{
    // Create a test DataTable with two columns and a few rows.
    DataTable table = new DataTable(tableName);
    DataColumn column = new DataColumn("id", typeof(System.Int32));
    column.AutoIncrement = true;
    table.Columns.Add(column);

    column = new DataColumn("item", typeof(System.String));
    table.Columns.Add(column);

    // Add ten rows.
    DataRow row;
    for (int i = 0; i <= 9; i++)
    {
        row = table.NewRow();
        row["item"] = "item " + i;
        table.Rows.Add(row);
    }

    table.AcceptChanges();
    return table;
}

private static void PrintSchema(DataTable table, string label)
{
    // Display the schema of the supplied DataTable:
    Console.WriteLine(label);
    foreach (DataColumn column in table.Columns)
    {
        Console.WriteLine("\t{0}: {1}", column.ColumnName,
            column.DataType.Name);
    }
    Console.WriteLine();
}

Private Sub DemonstrateReadWriteXMLSchemaWithReader()
  Dim table As DataTable = CreateTestTable("XmlDemo")
  PrintSchema(table, "Original table")

  ' Write the schema to XML in a memory stream.
  Dim xmlStream As New System.IO.MemoryStream()
  table.WriteXmlSchema(xmlStream)

  ' Rewind the memory stream.
  xmlStream.Position = 0

  Dim newTable As New DataTable
  Dim reader As New System.Xml.XmlTextReader(xmlStream)
  newTable.ReadXmlSchema(reader)

  ' Print out values in the table.
  PrintSchema(newTable, "New Table")
End Sub

Private Function CreateTestTable(ByVal tableName As String) _
      As DataTable
  ' Create a test DataTable with two columns and a few rows.
  Dim table As New DataTable(tableName)
  Dim column As New DataColumn("id", GetType(System.Int32))
  column.AutoIncrement = True
  table.Columns.Add(column)

  column = New DataColumn("item", GetType(System.String))
  table.Columns.Add(column)

  ' Add ten rows.
  Dim row As DataRow
  For i As Integer = 0 To 9
    row = table.NewRow()
    row("item") = "item " & i
    table.Rows.Add(row)
  Next i

  table.AcceptChanges()
  Return table
End Function

Private Sub PrintSchema(ByVal table As DataTable, _
      ByVal label As String)
  ' Display the schema of the supplied DataTable:
  Console.WriteLine(label)
  For Each column As DataColumn In table.Columns
    Console.WriteLine("{0}{1}: {2}", ControlChars.Tab, _
      column.ColumnName, column.DataType.Name)
  Next column
End Sub

備註

使用該ReadXmlSchema方法來建立 .DataTable 該結構包含表格、關聯與約束定義。

要為 XML 文件撰寫結構，請使用該 WriteXmlSchema 方法。

XML 架構依據 XSD 標準解讀。

如果 msdata：DataType 與 xs：type 類型不匹配，可能會發生資料損毀。絕不例外。

ReadXmlSchema通常在呼叫ReadXml用來填入的方法DataTable之前，會先呼叫該方法。

Note

使用 XML 架構建立巢狀關係的方法是包含隱含巢狀元素。此外，巢狀關係也可以重新布線，使用明確的欄位名稱。元素必須隱含巢狀，對應的資料表才能參與巢狀關係。

另請參閱

適用於

ReadXmlSchema(String)

從指定檔案讀取 XML 架構 DataTable 。

public:
 void ReadXmlSchema(System::String ^ fileName);

public void ReadXmlSchema(string fileName);

member this.ReadXmlSchema : string -> unit

Public Sub ReadXmlSchema (fileName As String)

參數

fileName: String

讀取結構資訊的檔案名稱。

範例

接下來的主控台應用程式會建立一個新的 DataTable，並將該資料表的結構寫入檔案。接著，範例會建立一個新的 DataTable 結構，並從儲存的 XML 架構讀取其結構，並以該檔案作為來源。

private static void DemonstrateReadWriteXMLSchemaWithFile()
{
    DataTable table = CreateTestTable("XmlDemo");
    PrintSchema(table, "Original table");

    // Write the schema to XML in a file.
    string xmlFile = "C:\\SchemaDemo.xml";
    table.WriteXmlSchema(xmlFile);

    DataTable newTable = new DataTable();
    newTable.ReadXmlSchema(xmlFile);

    // Print out values in the table.
    PrintSchema(newTable, "New table");
}

private static DataTable CreateTestTable(string tableName)
{
    // Create a test DataTable with two columns and a few rows.
    DataTable table = new DataTable(tableName);
    DataColumn column = new DataColumn("id", typeof(System.Int32));
    column.AutoIncrement = true;
    table.Columns.Add(column);

    column = new DataColumn("item", typeof(System.String));
    table.Columns.Add(column);

    // Add ten rows.
    DataRow row;
    for (int i = 0; i <= 9; i++)
    {
        row = table.NewRow();
        row["item"] = "item " + i;
        table.Rows.Add(row);
    }

    table.AcceptChanges();
    return table;
}

private static void PrintSchema(DataTable table, string label)
{
    // Display the schema of the supplied DataTable:
    Console.WriteLine(label);
    foreach (DataColumn column in table.Columns)
    {
        Console.WriteLine("\t{0}: {1}", column.ColumnName,
            column.DataType.Name);
    }
    Console.WriteLine();
}

Private Sub DemonstrateReadWriteXMLSchemaWithFile()
  Dim table As DataTable = CreateTestTable("XmlDemo")
  PrintSchema(table, "Original table")

  Dim xmlFile As String = "SchemaDemo.xml"

  ' Write the schema to XML.
  table.WriteXmlSchema(xmlFile)

  Dim newTable As New DataTable
  newTable.ReadXmlSchema(xmlFile)

  ' Print out values in the table.
  PrintSchema(newTable, "New Table")
End Sub

Private Function CreateTestTable(ByVal tableName As String) _
      As DataTable
  ' Create a test DataTable with two columns and a few rows.
  Dim table As New DataTable(tableName)
  Dim column As New DataColumn("id", GetType(System.Int32))
  column.AutoIncrement = True
  table.Columns.Add(column)

  column = New DataColumn("item", GetType(System.String))
  table.Columns.Add(column)

  ' Add ten rows.
  Dim row As DataRow
  For i As Integer = 0 To 9
    row = table.NewRow()
    row("item") = "item " & i
    table.Rows.Add(row)
  Next i

  table.AcceptChanges()
  Return table
End Function

Private Sub PrintSchema(ByVal table As DataTable, _
      ByVal label As String)
  ' Display the schema of the supplied DataTable:
  Console.WriteLine(label)
  For Each column As DataColumn In table.Columns
    Console.WriteLine("{0}{1}: {2}", ControlChars.Tab, _
      column.ColumnName, column.DataType.Name)
  Next column
End Sub

備註

使用該ReadXmlSchema方法來建立 .DataTable 該結構包含表格、關聯與約束定義。

要為 XML 文件撰寫結構，請使用該 WriteXmlSchema 方法。

XML 架構依據 XSD 標準解讀。

如果 msdata：DataType 與 xs：type 類型不匹配，可能會發生資料損毀。絕不例外。

ReadXmlSchema通常在呼叫ReadXml用來填入的方法DataTable之前，會先呼叫該方法。

要使用 XML 架構建立巢狀關係，請使用隱含巢狀元素。你也可以重新設定巢狀關係，使用明確的欄位名稱。元素必須隱含巢狀，對應的資料表才能參與巢狀關係。

另請參閱

適用於

ReadXmlSchema(TextReader)

利用指定的 TextReader. 將 XML 結構讀入 DataTable 。

public:
 void ReadXmlSchema(System::IO::TextReader ^ reader);

public void ReadXmlSchema(System.IO.TextReader reader);

member this.ReadXmlSchema : System.IO.TextReader -> unit

Public Sub ReadXmlSchema (reader As TextReader)

參數

reader: TextReader

它們 TextReader 用來讀取結構資訊。

範例

接下來的主控台應用程式會建立一個新的 DataTable，並將該資料表的結構寫入 MemoryStream。接著，範例會建立一個新 DataTable 結構，並從儲存的 XML 架構讀取其結構，來源為 a StreamReader （繼承自 TextReader）。

private static void DemonstrateReadWriteXMLSchemaWithReader()
{
    DataTable table = CreateTestTable("XmlDemo");
    PrintSchema(table, "Original table");

    // Write the schema to XML in a memory stream.
    System.IO.MemoryStream xmlStream = new System.IO.MemoryStream();
    table.WriteXmlSchema(xmlStream);

    // Rewind the memory stream.
    xmlStream.Position = 0;

    DataTable newTable = new DataTable();
    System.IO.StreamReader reader =
        new System.IO.StreamReader(xmlStream);
    newTable.ReadXmlSchema(reader);

    // Print out values in the table.
    PrintSchema(newTable, "New table");
}

private static DataTable CreateTestTable(string tableName)
{
    // Create a test DataTable with two columns and a few rows.
    DataTable table = new DataTable(tableName);
    DataColumn column = new DataColumn("id", typeof(System.Int32));
    column.AutoIncrement = true;
    table.Columns.Add(column);

    column = new DataColumn("item", typeof(System.String));
    table.Columns.Add(column);

    // Add ten rows.
    DataRow row;
    for (int i = 0; i <= 9; i++)
    {
        row = table.NewRow();
        row["item"] = "item " + i;
        table.Rows.Add(row);
    }

    table.AcceptChanges();
    return table;
}

private static void PrintSchema(DataTable table, string label)
{
    // Display the schema of the supplied DataTable:
    Console.WriteLine(label);
    foreach (DataColumn column in table.Columns)
    {
        Console.WriteLine("\t{0}: {1}",
            column.ColumnName, column.DataType.Name);
    }
    Console.WriteLine();
}

Private Sub DemonstrateReadWriteXMLSchemaWithReader()
  Dim table As DataTable = CreateTestTable("XmlDemo")
  PrintSchema(table, "Original table")

  ' Write the schema to XML in a memory stream.
  Dim xmlStream As New System.IO.MemoryStream()
  table.WriteXmlSchema(xmlStream)

  ' Rewind the memory stream.
  xmlStream.Position = 0

  Dim newTable As New DataTable
  Dim reader As New System.IO.StreamReader(xmlStream)
  newTable.ReadXmlSchema(reader)

  ' Print out values in the table.
  PrintSchema(newTable, "New Table")
End Sub

Private Function CreateTestTable(ByVal tableName As String) _
  As DataTable

  ' Create a test DataTable with two columns and a few rows.
  Dim table As New DataTable(tableName)
  Dim column As New DataColumn("id", GetType(System.Int32))
  column.AutoIncrement = True
  table.Columns.Add(column)

  column = New DataColumn("item", GetType(System.String))
  table.Columns.Add(column)

  ' Add ten rows.
  Dim row As DataRow
  For i As Integer = 0 To 9
    row = table.NewRow()
    row("item") = "item " & i
    table.Rows.Add(row)
  Next i

  table.AcceptChanges()
  Return table
End Function

Private Sub PrintSchema(ByVal table As DataTable, _
  ByVal label As String)

  ' Display the schema of the supplied DataTable:
  Console.WriteLine(label)
  For Each column As DataColumn In table.Columns
    Console.WriteLine("{0}{1}: {2}", ControlChars.Tab, _
      column.ColumnName, column.DataType.Name)
  Next column
End Sub

備註

使用該ReadXmlSchema方法來建立 .DataTable 該結構包含表格、關聯與約束定義。

要為 XML 文件撰寫結構，請使用該 WriteXmlSchema 方法。

XML 架構依據 XSD 標準解讀。

如果 msdata：DataType 與 xs：type 類型不匹配，可能會發生資料損毀。絕不例外。

ReadXmlSchema通常在呼叫ReadXml用來填入的方法DataTable之前，會先呼叫該方法。

另請參閱

適用於

ReadXmlSchema(Stream)

利用指定的串流讀取 XML 架構。DataTable

public:
 void ReadXmlSchema(System::IO::Stream ^ stream);

public void ReadXmlSchema(System.IO.Stream stream);

member this.ReadXmlSchema : System.IO.Stream -> unit

Public Sub ReadXmlSchema (stream As Stream)

參數

stream: Stream

串流用來讀取結構。

範例

接下來的主控台應用程式會建立一個新的 DataTable，並將該資料表的結構寫入 MemoryStream。接著，範例會建立一個新的 DataTable 結構，並從儲存的 XML 架構讀取其結構。

private static void DemonstrateReadWriteXMLSchemaWithStream()
{
    DataTable table = CreateTestTable("XmlDemo");
    PrintSchema(table, "Original table");

    // Write the schema to XML in a memory stream.
    System.IO.MemoryStream xmlStream = new System.IO.MemoryStream();
    table.WriteXmlSchema(xmlStream);

    // Rewind the memory stream.
    xmlStream.Position = 0;

    DataTable newTable = new DataTable();
    newTable.ReadXmlSchema(xmlStream);

    // Print out values in the table.
    PrintSchema(newTable, "New table");
}

private static DataTable CreateTestTable(string tableName)
{
    // Create a test DataTable with two columns and a few rows.
    DataTable table = new DataTable(tableName);
    DataColumn column = new DataColumn("id", typeof(System.Int32));
    column.AutoIncrement = true;
    table.Columns.Add(column);

    column = new DataColumn("item", typeof(System.String));
    table.Columns.Add(column);

    // Add ten rows.
    DataRow row;
    for (int i = 0; i <= 9; i++)
    {
        row = table.NewRow();
        row["item"] = "item " + i;
        table.Rows.Add(row);
    }

    table.AcceptChanges();
    return table;
}

private static void PrintSchema(DataTable table, string label)
{
    // Display the schema of the supplied DataTable:
    Console.WriteLine(label);
    foreach (DataColumn column in table.Columns)
    {
        Console.WriteLine("\t{0}: {1}", column.ColumnName,
            column.DataType.Name);
    }
    Console.WriteLine();
}

Private Sub DemonstrateReadWriteXMLSchemaWithStream()
  Dim table As DataTable = CreateTestTable("XmlDemo")
  PrintSchema(table, "Original table")

  ' Write the schema to XML in a memory stream.
  Dim xmlStream As New System.IO.MemoryStream()
  table.WriteXmlSchema(xmlStream)

  ' Rewind the memory stream.
  xmlStream.Position = 0

  Dim newTable As New DataTable
  newTable.ReadXmlSchema(xmlStream)

  ' Print out values in the table.
  PrintSchema(newTable, "New Table")
End Sub

Private Function CreateTestTable(ByVal tableName As String) _
  As DataTable

  ' Create a test DataTable with two columns and a few rows.
  Dim table As New DataTable(tableName)
  Dim column As New DataColumn("id", GetType(System.Int32))
  column.AutoIncrement = True
  table.Columns.Add(column)

  column = New DataColumn("item", GetType(System.String))
  table.Columns.Add(column)

  ' Add ten rows.
  Dim row As DataRow
  For i As Integer = 0 To 9
    row = table.NewRow()
    row("item") = "item " & i
    table.Rows.Add(row)
  Next i

  table.AcceptChanges()
  Return table
End Function

Private Sub PrintSchema(ByVal table As DataTable, _
  ByVal label As String)

  ' Display the schema of the supplied DataTable:
  Console.WriteLine(label)
  For Each column As DataColumn In table.Columns
    Console.WriteLine("{0}{1}: {2}", ControlChars.Tab, _
      column.ColumnName, column.DataType.Name)
  Next column
End Sub

備註

使用該ReadXmlSchema方法來建立 .DataTable 該結構包含表格、關聯與約束定義。

要為 XML 文件撰寫結構，請使用該 WriteXmlSchema 方法。

XML 架構依據 XSD 標準解讀。

如果 msdata：DataType 與 xs：type 類型不匹配，可能會發生資料損毀。絕不例外。

ReadXmlSchema通常在呼叫ReadXml用來填入的方法DataTable之前，會先呼叫該方法。

要使用 XML 架構建立巢狀關係，請使用隱含巢狀元素。你也可以設定巢狀關係使用明確的欄位名稱。元素必須隱含巢狀，對應的資料表才能參與巢狀關係。

另請參閱

適用於

意見反應

此頁面對您有幫助嗎？