VB & Database, Using existing ADO connection with Datagrid

Using existing ADO connection with Datagrid

Author	Message
Lee Gilli #1 / 4	Using existing ADO connection with Datagrid I'm using the datagrid. It has a design time DSN defined. This is a pain to manage as software moves around the network, also it costs us an extra SQL Server connection. My program creates an ADO connection at the start up, and virtually all db activity is performed on that connection, except for the VB6 datagrid, with its design-time DSN. What I'd REALLY like to do, is to somehow have the Datagrid use the existing ADO connection (at runtime obviously). I don't care about design time. Any ideas? Thanks! Best regards, Lee Gillie -- ______________________________________________________________________ Lee Gille, CCP Remove NOSPAM to E-Mail Online Data Processing, Inc. - 3501 N. Haven - Spokane, WA 99207-8500
Sat, 02 Jun 2001 03:00:00 GMT

Ladislav Sediv #2 / 4	Using existing ADO connection with Datagrid Quote: > I'm using the datagrid. It has a design time DSN defined. This is > a pain to manage as software moves around the network, also it costs > us an extra SQL Server connection. > My program creates an ADO connection at the start up, and virtually > all db activity is performed on that connection, except for the VB6 > datagrid, with its design-time DSN. What I'd REALLY like to do, is > to somehow have the Datagrid use the existing ADO connection (at > runtime obviously). I don't care about design time. > Any ideas? > Thanks! Best regards, Lee Gillie > -- > ______________________________________________________________________ > Lee Gille, CCP Remove NOSPAM to E-Mail > Online Data Processing, Inc. - 3501 N. Haven - Spokane, WA 99207-8500 DataGrid can't do anything with a Connection. To assign an ADO recordset to the grid use the DataSource property: Set DataGrid.DataSource = rs where rs is an ADODB.Recordset -- Lac
Sun, 03 Jun 2001 03:00:00 GMT

Page 1 of 1

[ 4 post ]