You'd need to convert the recordset into a VFP cursor. I do it using CursorAdapter, like this:

  oCA= CreateObject("CursorAdapter")
  oCA.DataSourceType=[ADO]
  oCA.Alias=[myCursor]
  oCA.CursorFill(,,,myADORecordSet)

   *--- Then
    Grid.RecordSource = "myCursor" &&&& Instead of Grid.ControlSource = "O_recordset"

HTH,

Enmanuel

>I can connect to SQL Server by ADO Connection
>When I have a recordset, and I want to show it on a grid.What can I do?
>I have tried these code:
>
> Grid.ControlSource = "O_recordset"
> Grid.Refresh
>
>But nothing happens