| aspxtreme |
Home Getting Started Web Forms Web Applications ADO.NET ASP/ADO Back to Basics |
  |
IDbCommand.Connection Property
System.Data Namespace IDbCommand Class
Sets or retrieves the IDbConnection used by this instance of the IDbCommand.
Syntax
| Script | IDbCommand.Connection [ = objConnection ] |
|---|
Property Value
| objConnection | An object representing the connection to the data source. |
The property is read/write with no default value.
Exceptions
| Exception Type | Condition |
|---|---|
| InvalidOperationException | Occurs when the Connection property is changed while a transaction is in progress. |
Remarks
If you set Connection while a transaction is in progress and the Transaction property is not null, an InvalidOperationException is generated. If the Transaction property is not null and the transaction has already been committed or rolled back, Transaction is set to null.
Example
The following example illustrates how the Connection with which to execute the command can be set.
void setSqlCommand ( ) {
string query = "SELECT * FROM nw_Categories ORDER BY CategoryID";
string connString = "uid=sa; pwd=; database=northwind; server=myServer";
SqlCommand myCmd = new SqlCommand ( query );
myCmd.Connection = new SqlConnection ( connString );
}
| ||
| C# | VB | |
See Also
IDbCommand Members CommandText CommandTimeout CommandType
