Namespace | System.Data.CONNX | ||
Description | The CNXCommand class is used as the main interface for retrieving data from a CONNX data source. This class accepts an SQL statement to process zero or more CNXParameters objects, and optional CNXTransaction object, and a CNXConnection object, all of which are used to retrieve data and present it in various ways, depending upon the Execute method used. | ||
Constructors | CNXCommand | ||
Description: | Implement the default constructor here. The default constructor is used to create an empty CNXCommand object, which has an empty SQL statement, an empty CNXConnection object, and an empty CNXTransaction object. | ||
Parameters: | None | ||
CNXCommand | |||
Description: | This constructor creates a new CNXCommand object with the specified SQL statement. | ||
Parameters: | cmdText | ||
Type: | String | ||
Description: | SQL statement assigned to the CommandText property. | ||
CNXCommand | |||
Description: | This constructor creates a new CNXCommand object with the specified SQL statement and the specified connection object. | ||
Parameters: | cmdText | ||
Type: | String | ||
Description: | SQL statement assigned to the CommandText property. | ||
connection | |||
Type: | CNXConnection | ||
Description: | CNXConnection object assigned to the Connection property. | ||
CNXCommand | |||
Description: | This constructor creates a new CNXCommand object with the specified SQL statement, the specified CNXConnection object, and the specified CNXTransaction object. | ||
Parameters: | cmdText | ||
Type: | String | ||
Description: | SQL statement assigned to the CommandText property. | ||
connection | |||
Type: | CNXConnection | ||
Description: | CNXConnection object assigned to the Connection property. | ||
txn | |||
Type: | CNXTransaction | ||
Description: | CNXTransaction object assigned to the Transaction property. | ||
Properties | CommandText | ||
Return Type: | String | ||
Description: | The CommandText property gets/sets the SQL statement processed when an Execute method is called. | ||
CommandTimeout | |||
Return Type: | Int | ||
Description: | The CommandTimeout property is not supported at this time. Setting to non-zero value throws an exception. | ||
CommandType | |||
Return Type: | CommandType | ||
Description: | The CommandType property gets/sets the CommandType. | ||
Connection | |||
Return Type: | CNXConnection | ||
Description: | The Connection property gets/sets the CNXConnection object. | ||
Parameters | |||
Return Type: | CNXParameterCollection | ||
Description: | The Parameters property gets the CNXParameterCollection that contains the CNXParameter objects. | ||
Transaction | |||
Return Type: | IDbTransaction | ||
Description: | The Transaction property gets/sets the CNXTransaction object. | ||
UpdatedRowSource | |||
Return Type: | UpdateRowSource | ||
Description: | The UpdatedRowSource property specifies how results are applied to the row that is being updated. This property is not implemented and is provided for interface compatibility. | ||
Methods | Cancel | ||
Return Type: | Void | ||
Description: | The Cancel method is not supported at this time and throws an exception. New CNXParameter object | ||
Parameters: | None | ||
CreateParameter | |||
Return Type: | IDbDataParameter | ||
Description: | The CreateParameter method returns a newly created CNXParameter object. New CNXParameter object. | ||
Parameters: | None | ||
Dispose | |||
Return Type: | Void | ||
Description: | The Dispose method releases any resources used by the object. | ||
Parameters | disposing | ||
Type: | Bool | ||
Description: | Specified if managed resources should also be disposed (true). | ||
ExecuteNonQuery | |||
Return Type: | int | ||
Description: | The ExecuteReader method executes the Action query and returns the number of records affected. | ||
Parameters: | None | ||
ExecuteReader | |||
Return Type: | IDataReader | ||
Description: | The ExecuteReader method executes the SQL statement contained in the CommandText property and returns a CNXDataReader object that can be used to iterate through the results. | ||
Parameters: | None | ||
ExecuteReader | |||
Return Type: | IDataReader | ||
Description: | The ExecuteReader method executes the SQL statement contained in the CommandText property and returns a CNXDataReader object that can be used to iterate through the results. | ||
Parameters: | Behavior | ||
Type: | CommandBehavior | ||
Description: | The CommandBehavior specifies if the connection should be closed after the query is executed. | ||
ExecuteScalar | |||
Return Type: | Object | ||
Description: | The ExecuteScalar method executes the SQL statement contained in the CommandText property and returns the first column of the first row of the resulset. | ||
Parameters: | None | ||
Prepare | |||
Return Type: | Void | ||
Description: | The Prepare method is not implemented at this time and will not throw an exception. | ||
Parameters: | None | ||