Class : CNXDataAdapter

Class : CNXDataAdapter

Namespace:

System.Data.CONNX

Description:

The CNXDataAdapter class handles much of the work related to presenting the native resultset in a .NET-friendly format.

Constructors:

CNXDataAdapter

Description:

A default constructor that simply creates a new CNXDataAdapter.

Parameters:

None

CNXDataAdapter

Description:

This constructor creates a new CNXDataAdapter with the provided CNXCommand object set to the SelectCommand property.

Parameters:

selectCommand

Type:

CNXCommand

Description:

CNXCommand object which is set to the SelectCommand property.

CNXDataAdapter

Description:

This constructor creates a new CNXDataAdapter with a new CNXCommand object and an existing CNXConnection object.

Parameters:

selectCommandText

Type:

String

Description:

SQL statement to be used in the creation of a new CNXCommand object which will be used for the SelectCommand property.

selectConnectionString

Type:

String

Description:

Connection string to be used in the creaton of a new CNXConnection object.

CNXDataAdapter

Description:

 

This constructor creates a new CNXData Adapter with a new CNXCommand object and an existing CNXconnection object.

Parameters:

selectCommandText

Type:

String

Description:

SQL statement to be used in the creation of a new CNXCommand object which will be used for the SelectCommand property.

selectConnection

Type:

CNXConnection

Description:

An existing CNXConnection object.

Properties:

DeleteCommand

Return Type:

CNXCommand

Description:

The DeleteCommand property gets/sets the CNXCommand object used for Delete statements.

SelectCommand

Return Type:

CNXCommand

Description:

The SelectCommand property gets/sets the CNXCommand object used for Select statements.

InsertCommand

Return Type:

CNXCommand

Description:

The InsertCommand property gets/sets the CNXCommand object used for Insert statements.

UpdateCommand

Return Type:

CNXCommand

Description:

 

The UpdateCommand property gets/sets the CNXCommand object used for Update statements.

Methods

Fill

Description:

Adds or refreshes rows in the DataSet to match those in the data source.

Parameters:

DataSet

Type:

DataSet

Description:

DataSet to fill with data (and schema) from data source.

Fill

Description:

Adds or refreshes rows in the DataSet to match those in the data source.

Parameters:

DataTable

Type:

DataTable

Description:

DataTable to fill with data (and schema) from data source.

Fill

Description:

Adds or refreshes rows in the DataSet to match those in the data source.

Parameters:

DataSet

Type:

DataSet

Description:

DataSet to fill with data (and schema) from data source.

srcTable

Type:

String

Description:

Table name for newly created table.

Fill

Description:

Adds or refreshes rows in the DataSet to match those in the data source.

Parameters:

DataSet

Type:

DataSet

Description:

DataSet to fill with data (and schema) from data source.

StartRecord

Type:

Int

Description:

0-based record from which to start retrieval.

MaxRecords

Type:

Int

Description:

Maximum number of records to retrieve.

SrcTable

Type:

String

Description:

Table name for newly created data table.