OleDbDataAdapter 建構函式

定義

命名空間:: System.Data.OleDb

組件:: System.Data.OleDb.dll

組件:: System.Data.dll

套件:: System.Data.OleDb v11.0.0-preview.2.26159.112

重要

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

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

多載

名稱	Description
OleDbDataAdapter()	初始化 OleDbDataAdapter 類別的新執行個體。
OleDbDataAdapter(OleDbCommand)	初始化一個以指定OleDbCommand SelectCommand屬性為屬性的新類別實例OleDbDataAdapter。
OleDbDataAdapter(String, OleDbConnection)	初始化一個新的類別實例OleDbDataAdapter。SelectCommand
OleDbDataAdapter(String, String)	初始化一個新的類別實例OleDbDataAdapter。SelectCommand

OleDbDataAdapter()

來源:: OleDbDataAdapter.cs

來源:: OleDbDataAdapter.cs

來源:: OleDbDataAdapter.cs

來源:: OleDbDataAdapter.cs

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

public:
 OleDbDataAdapter();

public OleDbDataAdapter();

Public Sub New ()

範例

以下範例建立並 OleDbDataAdapter 設定其部分性質。

public static OleDbDataAdapter CreateDataAdapter(
    OleDbConnection connection)
{
    string selectCommand =
        "SELECT CustomerID, CompanyName FROM Customers";
    OleDbDataAdapter adapter =
        new OleDbDataAdapter(selectCommand, connection);

    adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;

    // Create the Insert, Update and Delete commands.
    adapter.InsertCommand = new OleDbCommand(
        "INSERT INTO Customers (CustomerID, CompanyName) " +
        "VALUES (?, ?)");

    adapter.UpdateCommand = new OleDbCommand(
        "UPDATE Customers SET CustomerID = ?, CompanyName = ? " +
        "WHERE CustomerID = ?");

    adapter.DeleteCommand = new OleDbCommand(
        "DELETE FROM Customers WHERE CustomerID = ?");

    // Create the parameters.
    adapter.InsertCommand.Parameters.Add("@CustomerID",
        OleDbType.Char, 5, "CustomerID");
    adapter.InsertCommand.Parameters.Add("@CompanyName",
        OleDbType.VarChar, 40, "CompanyName");

    adapter.UpdateCommand.Parameters.Add("@CustomerID",
        OleDbType.Char, 5, "CustomerID");
    adapter.UpdateCommand.Parameters.Add("@CompanyName",
        OleDbType.VarChar, 40, "CompanyName");
    adapter.UpdateCommand.Parameters.Add("@oldCustomerID",
        OleDbType.Char, 5, "CustomerID").SourceVersion =
        DataRowVersion.Original;

    adapter.DeleteCommand.Parameters.Add("@CustomerID",
        OleDbType.Char, 5, "CustomerID").SourceVersion =
        DataRowVersion.Original;

    return adapter;
}

Public Function CreateDataAdapter( _
    ByVal connection As OleDbConnection) As OleDbDataAdapter

    Dim selectCommand As String = _
        "SELECT CustomerID, CompanyName FROM Customers"
    Dim adapter As OleDbDataAdapter = _
        New OleDbDataAdapter(selectCommand, connection)

    adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey

    ' Create the commands.
    adapter.InsertCommand = New OleDbCommand( _
        "INSERT INTO Customers (CustomerID, CompanyName) " & _
         "VALUES (?, ?)")

    adapter.UpdateCommand = New OleDbCommand( _
        "UPDATE Customers SET CustomerID = ?, CompanyName = ? " & _
        "WHERE CustomerID = ?")

    adapter.DeleteCommand = New OleDbCommand( _
        "DELETE FROM Customers WHERE CustomerID = ?")

    ' Create the parameters.
    adapter.InsertCommand.Parameters.Add( _
        "@CustomerID", OleDbType.Char, 5, "CustomerID")
    adapter.InsertCommand.Parameters.Add( _
        "@CompanyName", OleDbType.VarChar, 40, "CompanyName")

    adapter.UpdateCommand.Parameters.Add( _
        "@CustomerID", OleDbType.Char, 5, "CustomerID")
    adapter.UpdateCommand.Parameters.Add( _
        "@CompanyName", OleDbType.VarChar, 40, "CompanyName")
    adapter.UpdateCommand.Parameters.Add( _
        "@oldCustomerID", OleDbType.Char, 5, "CustomerID").SourceVersion = _
        DataRowVersion.Original

    adapter.DeleteCommand.Parameters.Add( _
        "@CustomerID", OleDbType.Char, 5, "CustomerID").SourceVersion = _
        DataRowVersion.Original

    Return adapter
End Function

備註

當你建立的 OleDbDataAdapter實例時，以下的讀寫屬性會被設定為以下初始值。

屬性	初始值
MissingMappingAction	`MissingMappingAction.Passthrough`
MissingSchemaAction	`MissingSchemaAction.Add`

你可以透過單獨呼叫這些屬性來更改這些屬性的價值。

另請參閱

DataAdapter 和 DataReader

適用於

OleDbDataAdapter(OleDbCommand)

來源:: OleDbDataAdapter.cs

來源:: OleDbDataAdapter.cs

來源:: OleDbDataAdapter.cs

來源:: OleDbDataAdapter.cs

初始化一個以指定OleDbCommand SelectCommand屬性為屬性的新類別實例OleDbDataAdapter。

public:
 OleDbDataAdapter(System::Data::OleDb::OleDbCommand ^ selectCommand);

public OleDbDataAdapter(System.Data.OleDb.OleDbCommand? selectCommand);

public OleDbDataAdapter(System.Data.OleDb.OleDbCommand selectCommand);

new System.Data.OleDb.OleDbDataAdapter : System.Data.OleDb.OleDbCommand -> System.Data.OleDb.OleDbDataAdapter

Public Sub New (selectCommand As OleDbCommand)

參數

selectCommand: OleDbCommand

一個 OleDbCommand 是 SELECT 語句或儲存程序，且被設定為 SelectCommand 的屬性 OleDbDataAdapter。

範例

以下範例建立並 OleDbDataAdapter 設定其部分性質。

public static OleDbDataAdapter CreateDataAdapter(string selectCommand,
    OleDbConnection connection)
{
    OleDbDataAdapter adapter = new OleDbDataAdapter(selectCommand, connection);

    adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;

    // Create the Insert, Update and Delete commands.
    adapter.InsertCommand = new OleDbCommand(
        "INSERT INTO Customers (CustomerID, CompanyName) " +
        "VALUES (?, ?)");

    adapter.UpdateCommand = new OleDbCommand(
        "UPDATE Customers SET CustomerID = ?, CompanyName = ? " +
        "WHERE CustomerID = ?");

    adapter.DeleteCommand = new OleDbCommand(
        "DELETE FROM Customers WHERE CustomerID = ?");

    // Create the parameters.
    adapter.InsertCommand.Parameters.Add("@CustomerID",
        OleDbType.Char, 5, "CustomerID");
    adapter.InsertCommand.Parameters.Add("@CompanyName",
        OleDbType.VarChar, 40, "CompanyName");

    adapter.UpdateCommand.Parameters.Add("@CustomerID",
        OleDbType.Char, 5, "CustomerID");
    adapter.UpdateCommand.Parameters.Add("@CompanyName",
        OleDbType.VarChar, 40, "CompanyName");
    adapter.UpdateCommand.Parameters.Add("@oldCustomerID",
        OleDbType.Char, 5, "CustomerID").SourceVersion =
        DataRowVersion.Original;

    adapter.DeleteCommand.Parameters.Add("@CustomerID",
        OleDbType.Char, 5, "CustomerID").SourceVersion =
        DataRowVersion.Original;

    return adapter;
}

Public Function CreateDataAdapter(ByVal selectCommand As String, _
    ByVal connection As OleDbConnection) As OleDbDataAdapter

    Dim adapter As OleDbDataAdapter = _
        New OleDbDataAdapter(selectCommand, connection)

    adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey

    ' Create the commands.
    adapter.InsertCommand = New OleDbCommand( _
        "INSERT INTO Customers (CustomerID, CompanyName) " & _
         "VALUES (?, ?)")

    adapter.UpdateCommand = New OleDbCommand( _
        "UPDATE Customers SET CustomerID = ?, CompanyName = ? " & _
        "WHERE CustomerID = ?")

    adapter.DeleteCommand = New OleDbCommand( _
        "DELETE FROM Customers WHERE CustomerID = ?")

    ' Create the parameters.
    adapter.InsertCommand.Parameters.Add( _
        "@CustomerID", OleDbType.Char, 5, "CustomerID")
    adapter.InsertCommand.Parameters.Add( _
        "@CompanyName", OleDbType.VarChar, 40, "CompanyName")

    adapter.UpdateCommand.Parameters.Add( _
        "@CustomerID", OleDbType.Char, 5, "CustomerID")
    adapter.UpdateCommand.Parameters.Add( _
        "@CompanyName", OleDbType.VarChar, 40, "CompanyName")
    adapter.UpdateCommand.Parameters.Add( _
        "@oldCustomerID", OleDbType.Char, 5, "CustomerID").SourceVersion = _
        DataRowVersion.Original

    adapter.DeleteCommand.Parameters.Add( _
        "@CustomerID", OleDbType.Char, 5, "CustomerID").SourceVersion = _
        DataRowVersion.Original

    Return adapter
End Function

備註

此建構子實作 OleDbDataAdapter 將屬性設定 SelectCommand 為參數中 selectCommand 指定的值。

當你建立的 OleDbDataAdapter實例時，以下的讀寫屬性會被設定為以下初始值。

屬性	初始值
MissingMappingAction	`MissingMappingAction.Passthrough`
MissingSchemaAction	`MissingSchemaAction.Add`

你可以透過單獨呼叫這些屬性來更改這些屬性的價值。

另請參閱

DataAdapter 和 DataReader

適用於

OleDbDataAdapter(String, OleDbConnection)

來源:: OleDbDataAdapter.cs

來源:: OleDbDataAdapter.cs

來源:: OleDbDataAdapter.cs

來源:: OleDbDataAdapter.cs

初始化一個新的類別實例OleDbDataAdapter。SelectCommand

public:
 OleDbDataAdapter(System::String ^ selectCommandText, System::Data::OleDb::OleDbConnection ^ selectConnection);

public OleDbDataAdapter(string? selectCommandText, System.Data.OleDb.OleDbConnection? selectConnection);

public OleDbDataAdapter(string selectCommandText, System.Data.OleDb.OleDbConnection selectConnection);

new System.Data.OleDb.OleDbDataAdapter : string * System.Data.OleDb.OleDbConnection -> System.Data.OleDb.OleDbDataAdapter

Public Sub New (selectCommandText As String, selectConnection As OleDbConnection)

參數

selectCommandText: String

一個字串，是 SQL 的 SELECT 陳述式或儲存程序，供屬性使用SelectCommand OleDbDataAdapter。

selectConnection: OleDbConnection

那 OleDbConnection 代表連結。

範例

以下範例建立並 OleDbDataAdapter 設定其部分性質。

public static OleDbDataAdapter CreateDataAdapter(
    OleDbConnection connection)
{
    string selectCommand =
        "SELECT CustomerID, CompanyName FROM Customers";
    OleDbDataAdapter adapter =
        new OleDbDataAdapter(selectCommand, connection);

    adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;

    // Create the Insert, Update and Delete commands.
    adapter.InsertCommand = new OleDbCommand(
        "INSERT INTO Customers (CustomerID, CompanyName) " +
        "VALUES (?, ?)");

    adapter.UpdateCommand = new OleDbCommand(
        "UPDATE Customers SET CustomerID = ?, CompanyName = ? " +
        "WHERE CustomerID = ?");

    adapter.DeleteCommand = new OleDbCommand(
        "DELETE FROM Customers WHERE CustomerID = ?");

    // Create the parameters.
    adapter.InsertCommand.Parameters.Add("@CustomerID",
        OleDbType.Char, 5, "CustomerID");
    adapter.InsertCommand.Parameters.Add("@CompanyName",
        OleDbType.VarChar, 40, "CompanyName");

    adapter.UpdateCommand.Parameters.Add("@CustomerID",
        OleDbType.Char, 5, "CustomerID");
    adapter.UpdateCommand.Parameters.Add("@CompanyName",
        OleDbType.VarChar, 40, "CompanyName");
    adapter.UpdateCommand.Parameters.Add("@oldCustomerID",
        OleDbType.Char, 5, "CustomerID").SourceVersion =
        DataRowVersion.Original;

    adapter.DeleteCommand.Parameters.Add("@CustomerID",
        OleDbType.Char, 5, "CustomerID").SourceVersion =
        DataRowVersion.Original;

    return adapter;
}

Public Function CreateDataAdapter( _
    ByVal connection As OleDbConnection) As OleDbDataAdapter

    Dim selectCommand As String = _
        "SELECT CustomerID, CompanyName FROM Customers"
    Dim adapter As OleDbDataAdapter = _
        New OleDbDataAdapter(selectCommand, connection)

    adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey

    ' Create the commands.
    adapter.InsertCommand = New OleDbCommand( _
        "INSERT INTO Customers (CustomerID, CompanyName) " & _
         "VALUES (?, ?)")

    adapter.UpdateCommand = New OleDbCommand( _
        "UPDATE Customers SET CustomerID = ?, CompanyName = ? " & _
        "WHERE CustomerID = ?")

    adapter.DeleteCommand = New OleDbCommand( _
        "DELETE FROM Customers WHERE CustomerID = ?")

    ' Create the parameters.
    adapter.InsertCommand.Parameters.Add( _
        "@CustomerID", OleDbType.Char, 5, "CustomerID")
    adapter.InsertCommand.Parameters.Add( _
        "@CompanyName", OleDbType.VarChar, 40, "CompanyName")

    adapter.UpdateCommand.Parameters.Add( _
        "@CustomerID", OleDbType.Char, 5, "CustomerID")
    adapter.UpdateCommand.Parameters.Add( _
        "@CompanyName", OleDbType.VarChar, 40, "CompanyName")
    adapter.UpdateCommand.Parameters.Add( _
        "@oldCustomerID", OleDbType.Char, 5, "CustomerID").SourceVersion = _
        DataRowVersion.Original

    adapter.DeleteCommand.Parameters.Add( _
        "@CustomerID", OleDbType.Char, 5, "CustomerID").SourceVersion = _
        DataRowVersion.Original

    Return adapter
End Function

備註

此實作 OleDbDataAdapter 開啟與關閉 OleDbConnection ，若尚未開啟。這在需要呼叫兩個或以上OleDbDataAdapter物件的Fill應用程式中非常有用。如果已經開了OleDbConnection，你必須明確打電話Close或處理它來關閉。

當你建立的 OleDbDataAdapter實例時，以下的讀寫屬性會被設定為以下初始值。

屬性	初始值
MissingMappingAction	`MissingMappingAction.Passthrough`
MissingSchemaAction	`MissingSchemaAction.Add`

你可以透過單獨呼叫這些屬性來更改這些屬性的價值。

另請參閱

DataAdapter 和 DataReader

適用於

OleDbDataAdapter(String, String)

來源:: OleDbDataAdapter.cs

來源:: OleDbDataAdapter.cs

來源:: OleDbDataAdapter.cs

來源:: OleDbDataAdapter.cs

初始化一個新的類別實例OleDbDataAdapter。SelectCommand

public:
 OleDbDataAdapter(System::String ^ selectCommandText, System::String ^ selectConnectionString);

public OleDbDataAdapter(string? selectCommandText, string? selectConnectionString);

public OleDbDataAdapter(string selectCommandText, string selectConnectionString);

new System.Data.OleDb.OleDbDataAdapter : string * string -> System.Data.OleDb.OleDbDataAdapter

Public Sub New (selectCommandText As String, selectConnectionString As String)

參數

selectCommandText: String

一個字串，是 SQL 的 SELECT 陳述式或儲存程序，供屬性使用SelectCommand OleDbDataAdapter。

selectConnectionString: String

連接字串。

範例

以下範例建立並 OleDbDataAdapter 設定其部分性質。

public static OleDbDataAdapter CreateDataAdapter(
    OleDbConnection connection)
{
    string selectCommand =
        "SELECT CustomerID, CompanyName FROM Customers";
    OleDbDataAdapter adapter =
        new OleDbDataAdapter(selectCommand, connection);

    adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;

    // Create the Insert, Update and Delete commands.
    adapter.InsertCommand = new OleDbCommand(
        "INSERT INTO Customers (CustomerID, CompanyName) " +
        "VALUES (?, ?)");

    adapter.UpdateCommand = new OleDbCommand(
        "UPDATE Customers SET CustomerID = ?, CompanyName = ? " +
        "WHERE CustomerID = ?");

    adapter.DeleteCommand = new OleDbCommand(
        "DELETE FROM Customers WHERE CustomerID = ?");

    // Create the parameters.
    adapter.InsertCommand.Parameters.Add("@CustomerID",
        OleDbType.Char, 5, "CustomerID");
    adapter.InsertCommand.Parameters.Add("@CompanyName",
        OleDbType.VarChar, 40, "CompanyName");

    adapter.UpdateCommand.Parameters.Add("@CustomerID",
        OleDbType.Char, 5, "CustomerID");
    adapter.UpdateCommand.Parameters.Add("@CompanyName",
        OleDbType.VarChar, 40, "CompanyName");
    adapter.UpdateCommand.Parameters.Add("@oldCustomerID",
        OleDbType.Char, 5, "CustomerID").SourceVersion =
        DataRowVersion.Original;

    adapter.DeleteCommand.Parameters.Add("@CustomerID",
        OleDbType.Char, 5, "CustomerID").SourceVersion =
        DataRowVersion.Original;

    return adapter;
}

Public Function CreateDataAdapter( _
    ByVal connection As OleDbConnection) As OleDbDataAdapter

    Dim selectCommand As String = _
        "SELECT CustomerID, CompanyName FROM Customers"
    Dim adapter As OleDbDataAdapter = _
        New OleDbDataAdapter(selectCommand, connection)

    adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey

    ' Create the commands.
    adapter.InsertCommand = New OleDbCommand( _
        "INSERT INTO Customers (CustomerID, CompanyName) " & _
         "VALUES (?, ?)")

    adapter.UpdateCommand = New OleDbCommand( _
        "UPDATE Customers SET CustomerID = ?, CompanyName = ? " & _
        "WHERE CustomerID = ?")

    adapter.DeleteCommand = New OleDbCommand( _
        "DELETE FROM Customers WHERE CustomerID = ?")

    ' Create the parameters.
    adapter.InsertCommand.Parameters.Add( _
        "@CustomerID", OleDbType.Char, 5, "CustomerID")
    adapter.InsertCommand.Parameters.Add( _
        "@CompanyName", OleDbType.VarChar, 40, "CompanyName")

    adapter.UpdateCommand.Parameters.Add( _
        "@CustomerID", OleDbType.Char, 5, "CustomerID")
    adapter.UpdateCommand.Parameters.Add( _
        "@CompanyName", OleDbType.VarChar, 40, "CompanyName")
    adapter.UpdateCommand.Parameters.Add( _
        "@oldCustomerID", OleDbType.Char, 5, "CustomerID").SourceVersion = _
        DataRowVersion.Original

    adapter.DeleteCommand.Parameters.Add( _
        "@CustomerID", OleDbType.Char, 5, "CustomerID").SourceVersion = _
        DataRowVersion.Original

    Return adapter
End Function

備註

這種建構子的超載 OleDbDataAdapter 會利用參數 selectConnectionString 來設定屬性 SelectCommand 。然而，這並不會開啟連線。你仍然必須明確開啟連線。

當你建立的 OleDbDataAdapter實例時，以下的讀寫屬性會被設定為以下初始值。

屬性	初始值
MissingMappingAction	`MissingMappingAction.Passthrough`
MissingSchemaAction	`MissingSchemaAction.Add`

你可以透過單獨呼叫這些屬性來更改這些屬性的價值。

另請參閱

DataAdapter 和 DataReader

適用於

意見反應

此頁面對您有幫助嗎？

共用方式為

OleDbDataAdapter 建構函式

定義

多載

OleDbDataAdapter()

範例

備註

另請參閱

適用於

OleDbDataAdapter(OleDbCommand)

參數

範例

備註

另請參閱

適用於

OleDbDataAdapter(String, OleDbConnection)

參數

範例

備註

另請參閱

適用於

OleDbDataAdapter(String, String)

參數

範例

備註

另請參閱

適用於

意見反應