title: How to read a SQLite database into a DataGridView object
body: <p>I am writing a VB program using VS 2013. I am using the methods in System.Data.SqLite.dll from SQLite.org. I can read my database fine into a ListBox object. I am posting my code that I am using for this. What I would like to do is send this data to a DataGridView object. I am having no luck doing it correctly.</p>
  
  <pre><code>Private Sub Button4_Click(sender As Object, e As EventArgs) Handles Button4.Click
      Dim f As New OpenFileDialog
      f.Filter = "SQLite 3 (*.db)|*.db|All Files|*.*"
      If f.ShowDialog() = DialogResult.OK Then
          Dim SQLconnect As New SQLite.SQLiteConnection()
          Dim SQLcommand As SQLiteCommand
          SQLconnect.ConnectionString = "Data Source=" &amp; f.FileName &amp; ";"
          SQLconnect.Open()
          SQLcommand = SQLconnect.CreateCommand
          SQLcommand.CommandText = "SELECT address, date, body FROM sms ORDER BY date DESC"
          Dim SQLreader As SQLiteDataReader = SQLcommand.ExecuteReader()
  
          lst_records.Items.Clear()
  
          While SQLreader.Read()
              lst_records.Items.Add(String.Format("address = {0}, date = {1}, body = {2}",      SQLreader(0), SQLreader(1), SQLreader(2)))
           End While
  
          SQLcommand.Dispose()
          SQLconnect.Close()
      End If
  End Sub
  </code></pre>