0
Private Sub Form_Load()
Dim sqlstr As String
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
Dim rs As New ADODB.Recordset
Set conn = New ADODB.Connection
conn.ConnectionString = "DRIVER=SQLite3 ODBC Driver;Database=" & App.Path & "/database.db;"
conn.Open
rs.Open "SELECT * FROM tblGiat", conn, adOpenKeyset
MsgBox "Total Number of records = " & rs.RecordCount
End Sub
I have successfully connected the database to VB6. Now I need help, how to display that database into DataGrid.
I think you will need to ask a much more specific question... – UuDdLrLrSs – 2019-03-27T14:19:45.367
I have SQLite database.db, I want to display all fields into DataGrid. But I've found out how. – AR_Madhan – 2019-03-27T14:32:00.043