title: SQLite - storing the column names of a table in a list of strings
body: <p>I don't know how to store the column names from a SQLite table into a list of strings.
  The following code fills a dataGridView with the column names (amongst other things):</p>
  
  <pre><code>string sDatabasePath = DBPath();
  SQLiteConnectionStringBuilder datasource = new SQLiteConnectionStringBuilder();
  datasource.Add("Data Source", sDatabasePath);
  datasource.Add("Version", "3");
  datasource.Add("New", "False");
  datasource.Add("Compress", "True");             
  using (SQLiteConnection connection = new SQLiteConnection(datasource.ConnectionString))
  {
      connection.Open(); //opens connection
      SQLiteCommand getColumnNames = new SQLiteCommand("PRAGMA table_info('myTable');", connection);
      SQLiteDataAdapter myAdapter = new SQLiteDataAdapter(getColumnNames);
      DataSet myDataSet = new DataSet();
      //myAdapter.Fill(myDataSet, "name");
      this.dataGridView1.DataSource = myDataSet;
      this.dataGridView1.DataMember = "name";
      connection.Close();
  }
  </code></pre>