coded a button to fill a datagrid to get the names of all the tables.

Code:
private void button1_Click(object sender, EventArgs e)
        {
            myconnection.Open(); //opens connection 

            SQLiteCommand getTables = new SQLiteCommand("Select name From sqlite_master where type='table' order by name;",myconnection);
            SQLiteDataAdapter myCountAdapter = new SQLiteDataAdapter(getTables);
            DataSet myCountDataSet = new DataSet();
            myCountAdapter.Fill(myCountDataSet, "name");

            this.dataGrid1.DataSource = myCountDataSet;
            this.dataGrid1.DataMember = "name";
            
            myconnection.Close(); // closes the connection
        }