Edit

Share via


OracleDataAdapter Constructors

Definition

Initializes a new instance of the OracleDataAdapter class.

Overloads

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.

OracleDataAdapter()

Initializes a new instance of the OracleDataAdapter class.

public:
 OracleDataAdapter();
public OracleDataAdapter();
Public Sub New ()

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

OracleDataAdapter(OracleCommand)

Initializes a new instance of the OracleDataAdapter class with the specified SQL SELECT statement.

public:
 OracleDataAdapter(System::Data::OracleClient::OracleCommand ^ selectCommand);
public OracleDataAdapter(System.Data.OracleClient.OracleCommand selectCommand);
new System.Data.OracleClient.OracleDataAdapter : System.Data.OracleClient.OracleCommand -> System.Data.OracleClient.OracleDataAdapter
Public 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.

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

OracleDataAdapter(String, OracleConnection)

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);
public OracleDataAdapter(string selectCommandText, System.Data.OracleClient.OracleConnection selectConnection);
new System.Data.OracleClient.OracleDataAdapter : string * System.Data.OracleClient.OracleConnection -> System.Data.OracleClient.OracleDataAdapter
Public 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.

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

OracleDataAdapter(String, String)

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);
public OracleDataAdapter(string selectCommandText, string selectConnectionString);
new System.Data.OracleClient.OracleDataAdapter : string * string -> System.Data.OracleClient.OracleDataAdapter
Public 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.

See also

Applies to