共用方式為


OleDbDataAdapter.InsertCommand 屬性

定義

取得或設定 SQL 陳述式或預存程序,用來插入新記錄到資料來源。

public:
 property System::Data::OleDb::OleDbCommand ^ InsertCommand { System::Data::OleDb::OleDbCommand ^ get(); void set(System::Data::OleDb::OleDbCommand ^ value); };
public System.Data.OleDb.OleDbCommand? InsertCommand { get; set; }
[System.Data.DataSysDescription("DbDataAdapter_InsertCommand")]
public System.Data.OleDb.OleDbCommand InsertCommand { get; set; }
public System.Data.OleDb.OleDbCommand InsertCommand { get; set; }
member this.InsertCommand : System.Data.OleDb.OleDbCommand with get, set
[<System.Data.DataSysDescription("DbDataAdapter_InsertCommand")>]
member this.InsertCommand : System.Data.OleDb.OleDbCommand with get, set
Public Property InsertCommand As OleDbCommand

屬性值

OleDbCommand,用來在 Update(DataSet) 期間插入資料來源中的資料錄,這些資料錄對應至 DataSet 中的新資料列。

屬性

範例

下列範例會 OleDbDataAdapter 建立 並設定 SelectCommandInsertCommand 屬性。 假設您已經建立 OleDbConnection 物件。

public static OleDbDataAdapter CreateCustomerAdapter(
    OleDbConnection connection)
{
    OleDbDataAdapter adapter = new OleDbDataAdapter();
    OleDbCommand command;

    // Create the SelectCommand.
    command = new OleDbCommand("SELECT CustomerID FROM Customers " +
        "WHERE Country = ? AND City = ?", connection);

    command.Parameters.Add("Country", OleDbType.VarChar, 15);
    command.Parameters.Add("City", OleDbType.VarChar, 15);

    adapter.SelectCommand = command;

    // Create the InsertCommand.
    command = new OleDbCommand(
        "INSERT INTO Customers (CustomerID, CompanyName) " +
        "VALUES (?, ?)", connection);

    command.Parameters.Add(
        "CustomerID", OleDbType.Char, 5, "CustomerID");
    command.Parameters.Add(
        "CompanyName", OleDbType.VarChar, 40, "CompanyName");

    adapter.InsertCommand = command;
    return adapter;
}
Public Shared Function CreateCustomerAdapter( _
    connection As OleDbConnection) As OleDbDataAdapter 
  
    Dim adapter As New OleDbDataAdapter()
    Dim command As OleDbCommand

    ' Create the SelectCommand.
    command = New OleDbCommand("SELECT CustomerID FROM Customers " & _
        "WHERE Country = ? AND City = ?", connection)

    command.Parameters.Add("Country", OleDbType.VarChar, 15)
    command.Parameters.Add("City", OleDbType.VarChar, 15)

    adapter.SelectCommand = command

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

    command.Parameters.Add( _
        "CustomerID", OleDbType.Char, 5, "CustomerID")
    command.Parameters.Add( _
        "CompanyName", OleDbType.VarChar, 40, "CompanyName")

    adapter.InsertCommand = command
    Return adapter
End Function

備註

在 期間Update,如果未設定這個屬性,而且主鍵資訊存在於 DataSet中,則如果您設定 SelectCommand 屬性並使用 OleDbCommandBuilderInsertCommand則可以自動產生 。 然後,您未設定的任何其他命令都會由 OleDbCommandBuilder產生。 此產生邏輯需要在 中 DataSet提供索引鍵數據行資訊。 如需詳細資訊,請參閱使用 CommandBuilder 產生命令

當 指定先前建立OleDbCommand的時InsertCommandOleDbCommand不會複製 。 會 InsertCommand 維護先前建立 OleDbCommand 對象的參考。

注意

如果執行此指令會傳回資料列,可能會根據您設定 UpdatedRowSource 物件的屬性OleDbCommand,將這些資料列新增至 DataSet

適用於

另請參閱