DbDataAdapter.InsertCommand DbDataAdapter.InsertCommand DbDataAdapter.InsertCommand DbDataAdapter.InsertCommand Property

定義

データ ソースに新しいレコードを挿入するコマンドを取得または設定します。Gets or sets a command used to insert new records into the data source.

public:
 property System::Data::Common::DbCommand ^ InsertCommand { System::Data::Common::DbCommand ^ get(); void set(System::Data::Common::DbCommand ^ value); };
[System.ComponentModel.Browsable(false)]
public System.Data.Common.DbCommand InsertCommand { get; set; }
member this.InsertCommand : System.Data.Common.DbCommand with get, set
Public Property InsertCommand As DbCommand

プロパティ値

データ セット内の新しい行に対応するデータ ソース内のレコードを挿入するために、IDbCommand 中に使用する Update(DataSet)A IDbCommand used during Update(DataSet) to insert records in the data source for new rows in the data set.

次の例では、派生OleDbDataAdapterクラスを作成し、そのプロパティの一部を設定します。The following example creates the derived class OleDbDataAdapter and sets some of its properties.

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 OleDbDataAdapter = 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に主キー情報がInsertCommand含まれている場合は、が自動的に生成されます。During Update, if this property is not set and primary key information is present in the DataSet, the InsertCommand will be automatically generated.

適用対象

こちらもご覧ください