I am using ADO to connect to an sql server 7 database.

The connection seems to be fine, in that I can view the data in textboxes on a form and navigate through them. My problem is how do I get the data into the MS Datagrid control. It does not seem to have a data source property in the properties window. But I can put this code in the init event of the grid:

this.datasource = oRec

I also set the columns in the grid to oRec.fields(0), oRec.fields(1) and so on. However the grid shows no data. It does show blank records

What am I missing ? And, is there a better way?

Thanks in advance


Alhad