|
|
|
|
|
PROPERTY: |
|
|
|
connected |
|
|
|
|
|
|
|
DESCRIPTION: |
|
|
|
Indicates whether the object is connected with database. |
||
|
|
|
|
|
PROPERTY OF: |
|
|
|
|
||
|
|
||
|
|
||
|
|
||
|
|
||
|
DEFAULT VALUE: |
|
|
|
false |
|
|
|
|
|
|
|
DESCRIPTION: |
|
|
|
|
||
|
|
||
|
|
||
|
|
||
|
|
||
|
|
||
|
|
||
|
One of the most powerful features found in ADO is the capability to open a client-side rowset from a data source and then disconnect the data object from the data source. |
||
|
When the data object has been disconnected, the connection to the data source can be closed, thereby releasing the resources on the server used to maintain it. |
||
|
You can continue to view and edit the data in the rowset while it is disconnected and later reconnect to the data source and send your updates in batch mode. |
||
|
|
||
|
When using the connectionString property to set up connection to the server, it is often advisable to use this property to set connected to true. |
||
|
For example. When setting up an ADOStoredProc, if the procedure needs a parameter and you are using a connectionString instead of the databaseName .. it is necessary to use the
|
||
|
this.ADOSTOREDPROC1 = new ADOSTOREDPROC(this) with (this.ADOSTOREDPROC1) left = 4.0 top = 1.0 connectionString = "Provider=SQLOLEDB.1;Password=Testing123;Persist Security Info=True;Initial Catalog=Test;User ID=sa;Data Source=xxx.xxx.xxx.xxx" connected = true procedureName = "SP_STATE_GROUP" with (parameters["@StateID"]) // Errors here type = "Char" value = "CA" endwith active = true endwith |
||
|
|
||
|
|
||
|
|
||
|
|
|
|