OracleDataAdapter Class

Represents a set of data commands and a database connection that are used to fill the DataSet and update an Oracle database.

For a list of all members of this type, see OracleDataAdapter members.

Inheritance Hierarchy

System.Object
   System.MarshalByRefObject
      System.ComponentModel.Component
         System.Data.Common.DataAdapter
            System.Data.Common.DbDataAdapter
               Devart.Common.DbDataAdapter
                  Devart.Data.Oracle.OracleDataAdapter

Syntax

[Visual Basic]
Public Class OracleDataAdapter 
   Inherits DbDataAdapter
   Implements IComponent, IDataAdapter, IDbDataAdapter, ICloneable, IDisposable

[C#]
public class OracleDataAdapter : DbDataAdapter, IComponent, IDataAdapter, IDbDataAdapter, ICloneable, IDisposable

Remarks

The OracleDataAdapter serves as a bridge between a DataSet and database for retrieving and saving data. The OracleDataAdapter provides this bridge by using Fill to load data from the database into the DataSet, and using Update to send changes made in the DataSet back to the database.

OracleDataAdapter is used in conjunction with OracleConnection and OracleCommand to increase performance when connecting to an Oracle database.

The OracleDataAdapter also includes the OracleDataAdapter.SelectCommand, OracleDataAdapter.InsertCommand, OracleDataAdapter.DeleteCommand, OracleDataAdapter.UpdateCommand, and TableMappings properties to facilitate loading and updating of data.

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"); 
  object[] rowVals = new object[2]; 
  rowVals[0] = 40; 
  rowVals[1] = "Operations"; 
  myDataSet.Tables["Departments"].Rows.Add(rowVals); 
  myAdapter.InsertCommand = new OracleCommand("INSERT INTO Test.Dept (DeptNo, DName) " + 
    "VALUES (:DeptNo, :DName)", myConnection); 
  myAdapter.InsertCommand.Parameters.Add("DeptNo", OracleDbType.Integer, 0, "DeptNo"); 
  myAdapter.InsertCommand.Parameters.Add("DName", OracleDbType.VarChar, 15, "DName"); 
  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")
   Dim rowVals(1) As Object
   rowVals(0) = "40"
   rowVals(1) = "Operations"
   myDataSet.Tables("Departments").Rows.Add(rowVals)
   myAdapter.InsertCommand = New OracleCommand("INSERT INTO Test.Dept (DeptNo, DName) " & _
       "VALUES (:DeptNo, :DName)", myConnection)
   myAdapter.InsertCommand.Parameters.Add("DeptNo", OracleDbType.Integer, 0, "DeptNo")
   myAdapter.InsertCommand.Parameters.Add("DName", OracleDbType.VarChar, 15, "DName")
   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