Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005
    Posts
    1

    Question Unanswered: VB6 and .dbf file , ADODB

    Using VB6 as interface , .ddf file (Database)

    i've manage to create connection

    Private Sub Form_Load()
    Dim cnDBF As New ADODB.Connection
    cnDBF.Open "Provider=MSDASQL.1;Persist Security Info=False;DSN=Visual FoxPro Database;UID=;SourceDB=c:& #092;EAS;SourceType=DBF;Exclusive=No;Background;Fe tch=Yes;Collate=Machine;Null=Y
    es;Deleted=Yes;"
    Dim rs As New ADODB.Recordset
    rs.Open "Select * From PDATA", cnDBF, adOpenKeyset, adLockPessimistic
    End Sub

    my problem right now is ...
    how to retrieve my current data in the database INTO datagrid?
    how to?any posibble?or any alternative waY?

  2. #2
    Join Date
    Dec 2004
    Location
    Laguna, Philippines
    Posts
    147
    Dim rs As New ADODB.Recordset
    rs.Open "Select * From PDATA", cnDBF, adOpenKeyset, adLockPessimistic

    Set DataGrid1.DataSource = rs '<-- This One
    Give me a place to code and i shall move the earth!

Posting Permissions

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