>I created a form with the oleDB Grid, FlexGrid, and HFlexGrid, trying to make any data show up. My ADO rs did end up with records. but as I mentioned when I set the DataSource property = to my ADO object no data showed up in the form at run time, I then set the DataSource property = the Character name of my ADO object and I kept getting data type mismatch.
For the MS Datagrid, you need to include the ADO data control. The grid binds to the ADO control and you set the record source for the data control to your ADO recordset. I have it working with VB, have had problems getting the ADO control to work in VFP with several activex controls.
There are other options not as straightforward as having the option to bind the recordset directly, one being converting the RS to VFP cursor with VFPCOM utility.