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?
Printable View
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?
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.
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
Now i tried this.
Set dg1.DataSource = rs
I got an error that my recordset is not bookmarkable.
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
i could do the same thing with a flexgrid
but there i can't use the record selectors