title: Getting SQLite data in gridview (C#) is not working
body: <p>I have a SQLite database with data in it. I want to show this data in a GridView list on my asp.NET webpage. 
  I found a way <a href="https://stackoverflow.com/questions/29107096/fill-datagridview-from-sqlite-db-c?answertab=active#tab-top">here</a> but that did not work for me. What I want is to display the first three columns of my table in the gridview list.<br> <a href="https://i.stack.imgur.com/KwFmM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KwFmM.png" alt="my table"></a><br>So I want to show the data in the columns "woord", "vertaling" and "gebruiker". </p>
  
  <p>This is my code:</p>
  
  <pre><code>using System;
  using System.Collections.Generic;
  using System.Linq;
  using System.Web;
  using System.Web.UI;
  using System.Web.UI.WebControls;
  
  public partial class Scripts_Default : System.Web.UI.Page
  {
      protected void Page_Load(object sender, EventArgs e)
      {
  
      }
      protected void btnTest_Click(object sender, EventArgs e)
      {
  
          string connectionString =
           @"Data Source=C:/Users/elias/Documents/Visual Studio 2017/WebSites/WebSite7/App_Data/overhoren.db";
  
          using (var conn = new System.Data.SQLite.SQLiteConnection(connectionString))
          {
              conn.Open();
  
              using (var command = new System.Data.SQLite.SQLiteCommand(conn))
              {
                  command.Connection = conn;
  
                  command.CommandText =
                     @"SELECT[vertaling], [woord] FROM[tbWoorden] WHERE[woord] = 'ans'";
  
  
  
                  using (var reader = command.ExecuteReader())
                  {
                      string test = "";
  
                      if (reader.Read())
                          dataGridView1.Rows.Add(new object[] {
                              read.GetValue(read.GetOrdinal("woord")),  // Or column name like this
                              read.GetValue(read.GetOrdinal("vertaling")),
                              read.GetValue(read.GetOrdinal("gebruiker"))
                          });
  
                  }
              }
  
          }
      }
  
  
  
      protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
      {
  
      }
  
      protected void grdMijnLijsten_SelectedIndexChanged(object sender, EventArgs e)
      {
  
      }
  }
  </code></pre>
  
  <p>This is not working for me. I think I am doing something completely wrong, but I searched on the web a lot and could not find a fix to solve the problem.</p>
  
  <p>What should I do?</p>
  
  <p>Thanks,</p>
  
  <p>Elias</p>