DeleteCommand Property

Gets or sets an Oracle statement to delete records from the data set.

[Visual Basic]
Public Property DeleteCommand As OracleCommand

[C#]
public OracleCommand DeleteCommand {get; set;}

Return Type

A OracleCommand used during an update operation to delete records in the database that correspond to deleted rows in the DataSet.

Remarks

During an update operation, if DeleteCommand is not set and primary key information is present in the DataSet, you can use the OracleCommandBuilder class to automatically generate the DeleteCommand, and additional commands needed to reconcile the DataSet to the database. To do this, set the OracleDataAdapter.SelectCommand property of the OracleDataAdapter. For more information see "Automatically Generated Commands" in the Microsoft .NET Framework SDK documentation.

Example

The following example demonstrates how to retrieve and manipulate data using OracleDataAdapter.

[C#]

public void UseDataAdapter(OracleConnection myConnection) 
{ 
  OracleDataAdapter myAdapter = new OracleDataAdapter("SELECT DeptNo, DName FROM Test.Dept", myConnection); 
  myAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey; 
  DataSet myDataSet = new DataSet(); 
  myAdapter.Fill(myDataSet,"Departments"); 
  myDataSet.Tables["Departments"].Rows[3].Delete(); 
  myAdapter.DeleteCommand = new OracleCommand("DELETE FROM Test.Dept WHERE DeptNo = :DeptNo", myConnection); 
  myAdapter.DeleteCommand.Parameters.Add("DeptNo", OracleDbType.Integer, 0, "DeptNo").SourceVersion = DataRowVersion.Original; 
  myAdapter.Update(myDataSet,"Departments");  
   
  //Get all data from all tables within the dataset 
  foreach(DataTable myTable in myDataSet.Tables) 
  { 
    foreach(DataRow myRow in myTable.Rows) 
    { 
      foreach (DataColumn myColumn in myTable.Columns) 
      { 
        Console.Write(myRow[myColumn]+"\t"); 
      } 
      Console.WriteLine(); 
    } 
    Console.WriteLine(); 
  } 
}

[Visual Basic]

Public Sub UseDataAdapter(ByVal myConnection As OracleConnection)
   Dim myAdapter As OracleDataAdapter = New OracleDataAdapter("SELECT DeptNo, DName FROM Test.Dept", myConnection)
   myAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey
   Dim myDataSet As DataSet = New DataSet
   myAdapter.Fill(myDataSet, "Departments")
   myDataSet.Tables("Departments").Rows(3).Delete()
   myAdapter.DeleteCommand = New OracleCommand("DELETE FROM Test.Dept WHERE DeptNo = :DeptNo", myConnection)
   myAdapter.DeleteCommand.Parameters.Add("DeptNo", OracleDbType.Integer, 0, "DeptNo").SourceVersion = DataRowVersion.Original
   myAdapter.Update(myDataSet, "Departments")
   Dim myTable As DataTable
   Dim myRow As DataRow
   Dim myColumn As DataColumn
   ' Get all data from all tables within the dataset
   For Each myTable In myDataSet.Tables
     For Each myRow In myTable.Rows
       For Each myColumn In myTable.Columns
         Console.Write(myRow(myColumn) & Chr(9))
       Next myColumn
       Console.WriteLine()
     Next myRow
     Console.WriteLine()
   Next myTable
 End Sub

See Also

Language

DeleteCommand Property

Return Type

Remarks

Example

See Also