Vb6: How to Show Sqlite in Datagrid

Vb6: How to Show Sqlite in Datagrid
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.

2
Chloe Bennett
Author

Chloe Bennett

Chloe Bennett explores the intersection of pop culture, streaming entertainment, digital trends, and contemporary lifestyle. Her weekly commentary reaches thousands of culture enthusiasts.