OracleDataAdapter Constructor (String, OracleConnection)

Initializes a new instance of the OracleDataAdapter class with an SQL SELECT statement and an OracleConnection.

[Visual Basic]
Public Sub New( _
   ByVal selectCommandText As String, _
   ByVal selectConnection As OracleConnection _
)
[C#]
public OracleDataAdapter(
   string selectCommandText,
 OracleConnection selectConnection
);
[C++]
public: OracleDataAdapter(
   String* selectCommandText,
 OracleConnection* selectConnection
);
[JScript]
public function OracleDataAdapter(
   selectCommandText : String,
 selectConnection : OracleConnection
);

Parameters

selectCommandText

A string that is an SQL SELECT statement or stored procedure to be used by the SelectCommand property of the OracleDataAdapter.

selectConnection

An OracleConnection that represents the connection.

Remarks

This implementation of the OracleDataAdapter can be useful in an application that must call the Fill method for two or more OracleDataAdapter objects.

Example

[Visual Basic, C#, C++] The following example creates an OracleDataAdapter and sets some of its properties.

[Visual Basic] 
Public Sub CreateOracleDataAdapter()
    Dim myOracleConnection As OracleConnection = New OracleConnection("Data Source=Oracle8i;Integrated Security=yes")
    Dim mySelectText As String = "SELECT DeptNo, DName FROM Dept"
    Dim custDA As OracleDataAdapter = New OracleDataAdapter(mySelectText, myOracleConnection) 
    custDA.MissingSchemaAction = MissingSchemaAction.AddWithKey    
   
    custDA.InsertCommand = New OracleCommand("INSERT INTO Dept (DeptNo, DName) " & _
                                            "VALUES (:pDeptNo, :pDName)", myOracleConnection)
    custDA.UpdateCommand = New OracleCommand("UPDATE Dept SET DeptNo = :pDeptNo, DName = :pDName " & _
                                            "WHERE DeptNo = :pDeptNo", myOracleConnection)
    custDA.DeleteCommand = New OracleCommand("DELETE FROM Dept WHERE DeptNo = :pDeptNo", myOracleConnection)

    custDA.InsertCommand.Parameters.Add("pDeptNo", OracleType.Number, 2, "DeptNo")
    custDA.InsertCommand.Parameters.Add("pDName", OracleType.VarChar, 14, "DName")
 
    custDA.UpdateCommand.Parameters.Add("pDeptNo", OracleType.Number, 2, "DeptNo")
    custDA.UpdateCommand.Parameters.Add("pDName", OracleType.VarChar, 14, "DName")
    custDA.UpdateCommand.Parameters.Add("poldDeptNo", OracleType.Number, 2, "DeptNo").SourceVersion = DataRowVersion.Original

    custDA.DeleteCommand.Parameters.Add("pDeptNo", OracleType.Number, 2, "DeptNo").SourceVersion = DataRowVersion.Original
End Sub

[C#] 
public static void CreateOracleDataAdapter() 
{
    OracleConnection myOracleConnection = new OracleConnection("Data Source=Oracle8i;Integrated Security=yes");

    string mySelectText = "SELECT DeptNo, DName FROM Dept";

    OracleDataAdapter custDA = new OracleDataAdapter(mySelectText, myOracleConnection );
    custDA.MissingSchemaAction = MissingSchemaAction.AddWithKey;
   
    custDA.InsertCommand = new OracleCommand("INSERT INTO Dept (DeptNo, DName) " +
                                            "VALUES (:pDeptNo, :pDName)", myOracleConnection);
    custDA.UpdateCommand = new OracleCommand("UPDATE Dept SET DeptNo = :pDeptNo, DName = :pDName " +
                                            "WHERE DeptNo = :pDeptNo", myOracleConnection);
    custDA.DeleteCommand = new OracleCommand("DELETE FROM Dept WHERE DeptNo = :pDeptNo", myOracleConnection);

    custDA.InsertCommand.Parameters.Add("pDeptNo", OracleType.Number, 2, "DeptNo");
    custDA.InsertCommand.Parameters.Add("pDName", OracleType.VarChar, 14, "DName");
 
    custDA.UpdateCommand.Parameters.Add("pDeptNo", OracleType.Number, 2, "DeptNo");
    custDA.UpdateCommand.Parameters.Add("pDName", OracleType.VarChar, 14, "DName");
    custDA.UpdateCommand.Parameters.Add("poldDeptNo", OracleType.Number, 2, "DeptNo").SourceVersion = DataRowVersion.Original;

    custDA.DeleteCommand.Parameters.Add("pDeptNo", OracleType.Number, 2, "DeptNo").SourceVersion = DataRowVersion.Original;
}

[C++] 
public:
static void CreateOracleDataAdapter() 
{
    OracleConnection* myOracleConnection = new OracleConnection(S"Data Source=Oracle8i;Integrated Security=yes");

    String* mySelectText = S"SELECT DeptNo, DName FROM Dept";

    OracleDataAdapter* custDA = new OracleDataAdapter(mySelectText, myOracleConnection );
    custDA->MissingSchemaAction = MissingSchemaAction::AddWithKey;
   
    custDA->InsertCommand = new OracleCommand(S"INSERT INTO Dept (DeptNo, DName) " 
                                              S"VALUES (:pDeptNo, :pDName)", myOracleConnection);
    custDA->UpdateCommand = new OracleCommand(S"UPDATE Dept SET DeptNo = :pDeptNo, DName = :pDName " 
                                              S"WHERE DeptNo = :pDeptNo", myOracleConnection);
    custDA->DeleteCommand = new OracleCommand(S"DELETE FROM Dept WHERE DeptNo = :pDeptNo", myOracleConnection);

    custDA->InsertCommand->Parameters->Add(S"pDeptNo", OracleType::Number, 2, S"DeptNo");
    custDA->InsertCommand->Parameters->Add(S"pDName", OracleType::VarChar, 14, S"DName");
 
    custDA->UpdateCommand->Parameters->Add(S"pDeptNo", OracleType::Number, 2, S"DeptNo");
    custDA->UpdateCommand->Parameters->Add(S"pDName", OracleType::VarChar, 14, S"DName");
    custDA->UpdateCommand->Parameters->Add(S"poldDeptNo", OracleType::Number, 2, S"DeptNo")->SourceVersion = DataRowVersion::Original;

    custDA->DeleteCommand->Parameters->Add(S"pDeptNo", OracleType::Number, 2, S"DeptNo")->SourceVersion = DataRowVersion::Original;
}

[JScript] No example is available for JScript. To view a Visual Basic, C#, or C++ example, click the Language Filter button in the upper-left corner of the page.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

.NET Framework Security: 

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries From Partially Trusted Code

See Also

OracleDataAdapter Class | OracleDataAdapter Members | System.Data.OracleClient Namespace | OracleDataAdapter Constructor Overload List