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 Reset to default