populate a DBGrid using a rcordset

[shovels]

Hi,
Can anyone please tell me how to populate a DBgrid using a recordset. I have created my recordset set using the following code:

Set rs = New adodb.Recordset
rs.Open lpzSQL, conn, adOpenKeyset, adLockOptimistic

and I know that it succeeds in getting the info from the DB.
Any suggestions would be greatly appreciated.
Cheers!

[voynovam]

You must set DataSource property of your grid:

DBGrid1.DataSource=rs