OracleDataAdapter Constructor (String^, String^)
.NET Framework (current version)
Initializes a new instance of the OracleDataAdapter class with an SQL SELECT statement and a connection string.
Assembly: System.Data.OracleClient (in System.Data.OracleClient.dll)
Parameters
- selectCommandText
-
Type:
System::String^
A string that is an SQL SELECT statement or stored procedure to be used by the SelectCommand property of the OracleDataAdapter.
- selectConnectionString
-
Type:
System::String^
The connection string.
The following example creates an OracleDataAdapter and sets some of its properties.
[Visual Basic]
Public Sub CreateOracleDataAdapter()
Dim myConnectionText As String = "Data Source=Oracle8i;Integrated Security=yes"
Dim mySelectText As String = "SELECT DeptNo, DName FROM Dept"
Dim custDA As OracleDataAdapter = New OracleDataAdapter(mySelectText, myConnectionText )
Dim myOracleConnection As OracleConnection = custDA.SelectCommand.Connection
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()
{
string myConnectionText = "Data Source=Oracle8i;Integrated Security=yes";
string mySelectText = "SELECT DeptNo, DName FROM Dept";
OracleDataAdapter custDA = new OracleDataAdapter(mySelectText, myConnectionText );
OracleConnection myOracleConnection = custDA.SelectCommand.Connection;
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;
}
.NET Framework
Available since 1.1
Available since 1.1
Show: