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. | ||