What type of recordset are you using? Grid controls usually require a recordset which support bookmarks. In most cases this means that you have to use static client-side cursor (or keyset server-side cursor if it supported by provider).

>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?