DbDataAdapter.InsertCommand Proprietà

Definizione

Ottiene o imposta un comando utilizzato per inserire nuovi record nell'origine dati.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); };
public System.Data.Common.DbCommand? InsertCommand { get; set; }
[System.ComponentModel.Browsable(false)]
public System.Data.Common.DbCommand InsertCommand { get; set; }
member this.InsertCommand : System.Data.Common.DbCommand with get, set
[<System.ComponentModel.Browsable(false)>]
member this.InsertCommand : System.Data.Common.DbCommand with get, set
Public Property InsertCommand As DbCommand

Valore della proprietà

DbCommand

Interfaccia IDbCommand utilizzata durante l'applicazione del metodo Update(DataSet), per l'inserimento nell'origine dati dei record relativi alle nuove righe nel set di dati.A IDbCommand used during Update(DataSet) to insert records in the data source for new rows in the data set.

Attributi

Esempio

Nell'esempio seguente viene creata la classe derivata OleDbDataAdapter e vengono impostate alcune delle relative proprietà.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 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

Commenti

Durante Update , se questa proprietà non è impostata e le informazioni sulla chiave primaria sono presenti in DataSet , InsertCommand verrà generato automaticamente.During Update, if this property is not set and primary key information is present in the DataSet, the InsertCommand will be automatically generated.

Si applica a

Vedi anche