If it shows no data, that's because your JOIN is failing to produce any rows.
This code works for me:
string strConnect = SMDBSupport.SMInstanceStorage.GetInstanceConnectionString("MyDBName");
using (SQLiteConnection con = new SQLiteConnection(strConnect))
{
try
{
con.Open();
using (SQLiteDataAdapter da = new SQLiteDataAdapter(getCount, con))
{
using (DataTable dt = new DataTable())
{
da.Fill(dt);
myDataGridView.DataSource = dt;
}
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
}
}
It's literally my boilerplate code for a DataAdapter to a DataGridView for SQLite (it's drag'n'dropped from the VS Toolbox into my code ready to fill in!)
So ... use the debugger to find out exactly what is happening - and that any exception isn't being swallowed - then use SSMS or similar to open the SQLite DB and check exactly what in in your DB and what results your SELECT returns.
Sorry, but we can't do that for you!