DbDataAdapter.UpdateCommand Properti

Definisi

Ruang nama:

System.Data.Common

Rakitan:

System.Data.Common.dll

Sumber:

DbDataAdapter.cs

Mendapatkan atau mengatur perintah yang digunakan untuk memperbarui rekaman di sumber data.

public:
 property System::Data::Common::DbCommand ^ UpdateCommand { System::Data::Common::DbCommand ^ get(); void set(System::Data::Common::DbCommand ^ value); };

[System.ComponentModel.Browsable(false)]
public System.Data.Common.DbCommand? UpdateCommand { get; set; }

[<System.ComponentModel.Browsable(false)>]
member this.UpdateCommand : System.Data.Common.DbCommand with get, set

Public Property UpdateCommand As DbCommand

Nilai Properti

DbCommand

yang IDbCommand digunakan selama Update(DataSet) memperbarui rekaman di sumber data untuk baris yang dimodifikasi dalam himpunan data.

Atribut

BrowsableAttribute

Contoh

Contoh berikut membuat kelas OleDbDataAdapter turunan dan mengatur beberapa propertinya.

public static OleDbDataAdapter CreateCustomerAdapter(OleDbConnection conn)
{
  OleDbDataAdapter da = new OleDbDataAdapter();
  OleDbCommand cmd;
  OleDbParameter parm;

  // Create the SelectCommand.

  cmd = new OleDbCommand("SELECT * FROM Customers " +
                       "WHERE Country = @Country AND City = @City", conn);

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

  da.SelectCommand = cmd;

  // Create the UpdateCommand.

  cmd = new OleDbCommand("UPDATE Customers SET CustomerID = @CustomerID, CompanyName = @CompanyName " +
                       "WHERE CustomerID = @oldCustomerID", conn);

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

  parm = cmd.Parameters.Add("@oldCustomerID", OleDbType.Char, 5, "CustomerID");
  parm.SourceVersion = DataRowVersion.Original;

  da.UpdateCommand = cmd;

  return da;
}

Public Shared Function CreateCustomerAdapter(conn As OleDbConnection) As OleDbDataAdapter 
  
  Dim da As New OleDbDataAdapter()
  Dim cmd As OleDbCommand
  Dim parm As OleDbParameter

  ' Create the SelectCommand.

  cmd = New OleDbCommand("SELECT * FROM Customers " & _
                       "WHERE Country = @Country AND City = @City", conn)

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

  da.SelectCommand = cmd

  ' Create the UpdateCommand.

  cmd = New OleDbCommand("UPDATE Customers SET CustomerID = @CustomerID, CompanyName = @CompanyName " & _
                       "WHERE CustomerID = @oldCustomerID", conn)

  cmd.Parameters.Add("@CustomerID", OleDbType.Char, 5, "CustomerID")
  cmd.Parameters.Add("@CompanyName", OleDbType.VarChar, 40, "CompanyName")

  parm = cmd.Parameters.Add("@oldCustomerID", OleDbType.Char, 5, "CustomerID")
  parm.SourceVersion = DataRowVersion.Original

  da.UpdateCommand = cmd

  Return da
End Function

Keterangan

Selama Update, jika properti ini tidak diatur dan informasi kunci primer ada di DataSet, UpdateCommand akan dibuat secara otomatis.

Lihat juga

• Memanipulasi Data (ADO.NET)
• DbProviderFactories (ADO.NET)
• Ringkasan ADO.NET