XmlDataDocument 建構函式

定義

命名空間:

System.Xml

組件:

System.Data.Common.dll

組件:

System.Data.dll

初始化 XmlDataDocument 類別的新執行個體。

多載

XmlDataDocument()	初始化 XmlDataDocument 類別的新執行個體。
XmlDataDocument(DataSet)	使用指定的 XmlDataDocument 初始化 DataSet 類別的新執行個體。

XmlDataDocument()

初始化 XmlDataDocument 類別的新執行個體。

public:
 XmlDataDocument();

public XmlDataDocument ();

Public Sub New ()

備註

會建立空 DataSet 的 ，並與 相關聯 XmlDataDocument 。

XmlDataDocument(DataSet)

使用指定的 XmlDataDocument 初始化 DataSet 類別的新執行個體。

public:
 XmlDataDocument(System::Data::DataSet ^ dataset);

public XmlDataDocument (System.Data.DataSet dataset);

new System.Xml.XmlDataDocument : System.Data.DataSet -> System.Xml.XmlDataDocument

Public Sub New (dataset As DataSet)

參數

dataset

DataSet

要載入 DataSet 中的 XmlDataDocument。

範例

下列範例會將客戶資料表 XmlDataDocument 載入 。

此範例使用 SQL Server 2000 Northwind 資料庫。

#using <System.Xml.dll>
#using <System.Transactions.dll>
#using <System.EnterpriseServices.dll>
#using <System.dll>
#using <System.Data.dll>

using namespace System;
using namespace System::Data;
using namespace System::Xml;
using namespace System::Data::SqlClient;
int main()
{
   DataSet^ dsNorthwind = gcnew DataSet;
   
   //Create the connection string.           
   String^ sConnect;
   sConnect = "Data Source=localhost;Integrated Security=SSPI;Initial Catalog=Northwind";
   
   //Create a connection object to connect to the northwind db.
   SqlConnection^ nwconnect = gcnew SqlConnection( sConnect );
   
   //Create a command string to select all the customers in the WA region.
   String^ sCommand = "Select * from Customers where Region='WA'";
   
   //Create an adapter to load the DataSet.
   SqlDataAdapter^ myDataAdapter = gcnew SqlDataAdapter( sCommand,nwconnect );
   
   //Fill the DataSet with the selected records.
   myDataAdapter->Fill( dsNorthwind, "Customers" );
   
   //Load the document with the DataSet.
   XmlDataDocument^ doc = gcnew XmlDataDocument( dsNorthwind );
   
   //Display the XmlDataDocument.
   doc->Save( Console::Out );
}

using System;
using System.Data;
using System.Xml;
using System.Data.SqlClient;

public class Sample
{
  public static void Main()
  {
     DataSet dsNorthwind = new DataSet();

     //Create the connection string.
     String sConnect;
     sConnect="Data Source=localhost;Integrated Security=SSPI;Initial Catalog=Northwind";

     //Create a connection object to connect to the northwind db.
     SqlConnection nwconnect = new SqlConnection(sConnect);

     //Create a command string to select all the customers in the WA region.
     String sCommand = "Select * from Customers where Region='WA'";

     //Create an adapter to load the DataSet.
     SqlDataAdapter myDataAdapter = new SqlDataAdapter(sCommand, nwconnect);

     //Fill the DataSet with the selected records.
     myDataAdapter.Fill(dsNorthwind,"Customers");

     //Load the document with the DataSet.
     XmlDataDocument doc = new XmlDataDocument(dsNorthwind);

     //Display the XmlDataDocument.
     doc.Save(Console.Out);
  }
}

Imports System.Xml
Imports System.Data
Imports System.Data.SqlClient

public class Sample
 
  public shared sub Main()
   
    Dim dsNorthwind as DataSet = new DataSet()
 
    'Create the connection string.
    Dim sConnect as String           
    sConnect="Data Source=localhost;Integrated Security=SSPI;Initial Catalog=Northwind"     
          
    'Create a connection object to connect to the northwind db.
    Dim nwconnect as SqlConnection
    nwconnect = new SqlConnection(sConnect)
 
    'Create a command string to select all the customers in the WA region.
    Dim sCommand as String = "Select * from Customers where Region='WA'"
 
    'Create an Adapter to load the DataSet.
    Dim myDataAdapter as SqlDataAdapter
    myDataAdapter = new SqlDataAdapter(sCommand, nwconnect)
 
    'Fill the DataSet with the selected records.
    myDataAdapter.Fill(dsNorthwind, "Customers")
 
    'Load the document with the DataSet.
    Dim doc as XmlDataDocument = new XmlDataDocument(dsNorthwind)  
 
    'Display the XmlDataDocument.
    doc.Save(Console.Out)
 
  end sub
end class

備註

會 XmlDataDocument 與指定的 DataSet 同步處理。 中的任何 DataSet 資料都可透過 XmlDataDocument 立即取得。 中的任何 DataSet 變更會在 中 XmlDataDocument 傳播。 在 中 XmlDataDocument 所做的任何變更，只要它們符合 DataSet 架構，就會在 中 DataSet 傳播。

另請參閱

• SqlConnection
• SqlDataAdapter