DbGrid + DataSource

[fchevitarese]

Hello!
I have to maintain in an old code here, and I have to migrate the database "Access" to "MSSQL".
So far so good ... The consultations, inclusions and exclusions are all done.
The problem is that there is a "DBGrid" here, that takes a "data" object as "DataSource".
This object in turn, opened a database "access", carrying a table and populate the "DbGrid.
I would like this populate this "DBGrid" using a "Recordset". It´s possible?

For thus, I would do the query and populate a "grid" with the result.

Thanks.

[Hack]

I wouldn't use a grid as a replacement, I'd use a ListView which is easily populated using a recordset.

[gibra]

DBGrid is obsolete.
Use DataGrid, instead.

Using ADO become simple to populate DataGrid with a ADO recordset (without a DAO Data control or ADO Data control).

Create your ADO Recordset then assign them to DataGrid:

Dim cn as ADODB.Connection
Dim rs as ADODB.Recordset
Set cn = new ADODB.Connection
Set rs = new ADODB.Recordset

cn.ConnectionString = <your_string_database_connection>
cn.CursorLocation = adUseClient
cn.open

rs.Open "SELECT * FROM table_name", cn, adForwardOnly, adReadOnly, adCmdText

Set DataGrid1.DataSource = rs

[fchevitarese]

Thanks
I´ll do this now !