Datagrid

[matjev]

How to link a recordset to a data grid?

I made an sql and want to link it to a datagrid, how to fix it?

[Beacon]

Use ADO Or dao.

You've got an sql database???
If so make a connection etc. then set dbgrids datasource to that connection or control!

For info about connecting to a db etc. see the db tutorials on this site.

[matjev]

Yes i have an sql database

does it has to be something like this?
Set dg1.DataSource = sql

when i try this I have object required

[matjev]

Now i tried this.

Set dg1.DataSource = rs

I got an error that my recordset is not bookmarkable.

[Beacon]

Nope you'll need to create a connection to the database first!
Then a recordset pointing to the db's table/recordset!

Read the tutorials they'll get you moving!

Basically the best and easiest way is to use the ADO Data control!
Work with that!
Found in Project/Components/Microsoft Active Data Object 2.5 blah blah

[matjev]

i could do the same thing with a flexgrid
but there i can't use the record selectors