OracleDataAdapter Constructors
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Initializes a new instance of the OracleDataAdapter class.
| OracleDataAdapter() |
Initializes a new instance of the OracleDataAdapter class. |
| OracleDataAdapter(OracleCommand) |
Initializes a new instance of the OracleDataAdapter class with the specified SQL SELECT statement. |
| OracleDataAdapter(String, OracleConnection) |
Initializes a new instance of the OracleDataAdapter class with an SQL SELECT statement and an OracleConnection. |
| OracleDataAdapter(String, String) |
Initializes a new instance of the OracleDataAdapter class with an SQL SELECT statement and a connection string. |
Initializes a new instance of the OracleDataAdapter class.
public:
OracleDataAdapter();C#
public OracleDataAdapter();Public Sub New ()Examples
The following example creates an OracleDataAdapter and sets some of its properties.
Public Sub CreateOracleDataAdapter()
Dim myOracleConnection As OracleConnection = New OracleConnection("Data Source=Oracle8i;Integrated Security=yes")
Dim custDA As OracleDataAdapter = New OracleDataAdapter
custDA.MissingSchemaAction = MissingSchemaAction.AddWithKey
custDA.SelectCommand = New OracleCommand("SELECT DeptNo, DName FROM Dept", myOracleConnection)
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");
OracleDataAdapter custDA = new OracleDataAdapter();
custDA.MissingSchemaAction = MissingSchemaAction.AddWithKey;
custDA.SelectCommand = new OracleCommand("SELECT DeptNo, CompanyName FROM Dept", myOracleConnection);
custDA.InsertCommand = new OracleCommand("INSERT INTO Dept (DeptNo, CompanyName) " +
"VALUES (:pDeptNo, :pCompanyName)", myOracleConnection);
custDA.UpdateCommand = new OracleCommand("UPDATE Dept SET DeptNo = :pDeptNo, CompanyName = :pCompanyName " +
"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("pCompanyName", OracleType.VarChar, 14, "CompanyName");
custDA.UpdateCommand.Parameters.Add("pDeptNo", OracleType.Number, 2, "DeptNo");
custDA.UpdateCommand.Parameters.Add("pCompanyName", OracleType.VarChar, 14, "CompanyName");
custDA.UpdateCommand.Parameters.Add("poldDeptNo", OracleType.Number, 2, "DeptNo").SourceVersion = DataRowVersion.Original;
custDA.DeleteCommand.Parameters.Add("pDeptNo", OracleType.Number, 2, "DeptNo").SourceVersion = DataRowVersion.Original;
}
Remarks
When you create an instance of OracleDataAdapter, the following read/write properties are set to their default values, as shown in the table.
| Properties | Default value |
|---|---|
| MissingMappingAction | MissingMappingAction.Passthrough |
| MissingSchemaAction | MissingSchemaAction.Add |
You can change the value of any of these properties through a separate call to the property.
See also
Applies to
.NET Framework 4.8.1 and other versions
| Product | Versions |
|---|---|
| .NET Framework | 1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1 |
Initializes a new instance of the OracleDataAdapter class with the specified SQL SELECT statement.
public:
OracleDataAdapter(System::Data::OracleClient::OracleCommand ^ selectCommand);C#
public OracleDataAdapter(System.Data.OracleClient.OracleCommand selectCommand);new System.Data.OracleClient.OracleDataAdapter : System.Data.OracleClient.OracleCommand -> System.Data.OracleClient.OracleDataAdapterPublic Sub New (selectCommand As OracleCommand)Parameters
- selectCommand
- OracleCommand
An OracleCommand that is an SQL SELECT statement or stored procedure, and is set as the SelectCommand property of the OracleDataAdapter.
Examples
The following example creates an OracleDataAdapter and sets some of its properties.
Public Sub CreateOracleDataAdapter()
Dim myOracleConnection As OracleConnection = New OracleConnection("Data Source=Oracle8i;Integrated Security=yes")
Dim myOracleCommand As OracleCommand = New OracleCommand("SELECT DeptNo, DName FROM Dept", myOracleConnection)
Dim custDA As OracleDataAdapter = New OracleDataAdapter(myOracleCommand)
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");
OracleCommand myOracleCommand = new OracleCommand("SELECT DeptNo, DName FROM Dept", myOracleConnection);
OracleDataAdapter custDA = new OracleDataAdapter(myOracleCommand);
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;
}
Remarks
This implementation of the OracleDataAdapter constructor sets the SelectCommand property to the value specified in the selectCommand parameter.
When you create an instance of OracleDataAdapter, the following read/write properties are set to their default values, as shown in the table.
| Properties | Initial value |
|---|---|
| MissingMappingAction | MissingMappingAction.Passthrough |
| MissingSchemaAction | MissingSchemaAction.Add |
You can change the value of any of these properties through a separate call to the property.
See also
Applies to
.NET Framework 4.8.1 and other versions
| Product | Versions |
|---|---|
| .NET Framework | 1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1 |
Initializes a new instance of the OracleDataAdapter class with an SQL SELECT statement and an OracleConnection.
public:
OracleDataAdapter(System::String ^ selectCommandText, System::Data::OracleClient::OracleConnection ^ selectConnection);C#
public OracleDataAdapter(string selectCommandText, System.Data.OracleClient.OracleConnection selectConnection);new System.Data.OracleClient.OracleDataAdapter : string * System.Data.OracleClient.OracleConnection -> System.Data.OracleClient.OracleDataAdapterPublic Sub New (selectCommandText As String, selectConnection As OracleConnection)Parameters
- selectCommandText
- String
A string that is an SQL SELECT statement or stored procedure to be used by the SelectCommand property of the OracleDataAdapter.
- selectConnection
- OracleConnection
An OracleConnection that represents the connection.
Examples
The following example creates an OracleDataAdapter and sets some of its properties.
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;
}
Remarks
This implementation of the OracleDataAdapter can be useful in an application that must call the Fill method for two or more OracleDataAdapter objects.
See also
Applies to
.NET Framework 4.8.1 and other versions
| Product | Versions |
|---|---|
| .NET Framework | 1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1 |
Initializes a new instance of the OracleDataAdapter class with an SQL SELECT statement and a connection string.
public:
OracleDataAdapter(System::String ^ selectCommandText, System::String ^ selectConnectionString);C#
public OracleDataAdapter(string selectCommandText, string selectConnectionString);new System.Data.OracleClient.OracleDataAdapter : string * string -> System.Data.OracleClient.OracleDataAdapterPublic Sub New (selectCommandText As String, selectConnectionString As String)Parameters
- selectCommandText
- String
A string that is an SQL SELECT statement or stored procedure to be used by the SelectCommand property of the OracleDataAdapter.
- selectConnectionString
- String
The connection string.
Examples
The following example creates an OracleDataAdapter and sets some of its properties.
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;
}
See also
Applies to
.NET Framework 4.8.1 and other versions
| Product | Versions |
|---|---|
| .NET Framework | 1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1 |
Collaborate with us on GitHub
The source for this content can be found on GitHub, where you can also create and review issues and pull requests. For more information, see our contributor guide.
.NET feedback
.NET is an open source project. Select a link to provide feedback: