I'm using an ado to connect to a flexgrid but the when I click the DataSource property on the flexgrid it says "No compatible data source found". ANy ideas?
Thanks
Printable View
I'm using an ado to connect to a flexgrid but the when I click the DataSource property on the flexgrid it says "No compatible data source found". ANy ideas?
Thanks
From what I understand, if you are using an ADO connection, have you opened a recordset? If you want to do it that way, you would have to set the datasource equal to the recordset after you have opened it. Here's an example:
sSQLSelect could be a string SQL command, table, or stored procedure. gobjConnect is the name of the connection.Code:rs.Open sSQLSelect, gobjConnect, adOpenStatic, adLockBatchOptimistic, adCmdText
If Not rs.EOF And Not rs.BOF Then
rs.MoveFirst
End If
rs.ActiveConnection = Nothing
Set FlexGrid1.DataSource = rs
You can read more about this here:
R U a Datagrid(ADO) Pro?
Going Crazy!!!
I hope this helps and Good Luck!