dbgrid

i have some problem loading record to the dbgrid. below is the part of the code

dim adocon as new adodb.connection
dim adors as new adodb.recordset

adocon.open ........ bla bla bla
adors.open "select * from something",adocon,, adOpenDynamic, adLockOptimistic, -1

set dbgrid1.recordsource = adors


but this code give me error that i don't understand...
please advice and some solution

Hi jimmykwh,

What type of the dbGrid are you using. Is it the type that will use OLEBD. I am using the True DB Grids, and when I use ADO, the grid must be the OLEDB type instead of the regular one. Not to sure if this will help, but good luck.

thanks jim but can you tell me how to find or load the oledb dbgrid up so i can used it....

It's in the component list as 'Microsoft DataGrid Control 6.0' It may have an (SP5) after that and then it'll have (OLEDB) at the end.