Datagrid without ADODC

Can we use a DataGrid without the ADODC to bind the database ? I keep getting error if connect the Datasource to a recordset that I create in run time.

I use ADO method to create a recordset call RS and use the below statement to connect the datagrid to my recordset;

datagrid1.datasouce = RS

I keep getting the error that says "method or data member not found"

Please help.

if like this , what will happen ?

set datagrid1.datasouce = RS
datagrid1.refresh

set datagrid1.datasouce = RS
datagrid1.refresh

this also not working. It says rowset not updatable. please help.

No error found, but the datagrid did not updated with any data.

which code u use ?

Tried that, but the datagrid still not showing anything. Does the Datagrid must be use together with the ADODC ?
Thanks.