use ADO recordset as datasource for Datagrid

[FaisalHenry]

I want to use ADO recordset as a datasource for datagrid

sample code:
set datagrid.Datasource = rs

but i got an error messaged that says "Result set is not bookmarkable"

any suggestion on solving this?

 

[stoolpigeon]

What options are you setting on your recordset?

Is it readonly, dynamic, keyset?

Just a thought.

 

[dannyh]

Hi,

If the above did not fix it then try changing the cursorLocation property to Client, and i think the cursor type will still need to be dynamic.

Dan.