Results 1 to 2 of 2

Thread: populate a DBGrid using a rcordset

  1. Mar 21st, 2000, 10:16 PM #1
    shovels
    shovels is offline

    Thread Starter
    New Member
    Join Date
    Mar 2000
    Posts
    10
    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!
    Reply With Quote Reply With Quote
  2. Mar 21st, 2000, 10:29 PM #2
    voynovam
    voynovam is offline
    New Member
    Join Date
    Mar 2000
    Location
    Brooklyn NY
    Posts
    3
    You must set DataSource property of your grid:

    DBGrid1.DataSource=rs
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width