Read SQLite table and store results inside DataTable C# UWP

ExecuteSQLiteReadQuery.txt

DataTable ExecuteReadQuery(string query)
{
    DataTable entries = new DataTable();

    using (SqliteConnection db = new SqliteConnection(ConnectionString))
    {
        SqliteCommand selectCommand = new SqliteCommand(query, db);
        try
        {
            db.Open();
            SqliteDataReader reader = selectCommand.ExecuteReader();

            if (reader.HasRows)
                for (int i = 0; i < reader.FieldCount; i++)
                    entries.Columns.Add(new DataColumn(reader.GetName(i)));

            int j = 0;
            while (reader.Read())
            {
                DataRow row = entries.NewRow();
                entries.Rows.Add(row);

                for (int i = 0; i < reader.FieldCount; i++)
                    entries.Rows[j][i] = (reader.GetValue(i));

                j++;
            }

            db.Close();
        }
        catch (SqliteException e)
        {
            OnSQLiteError(new SQLiteErrorEventArgs(e));
            db.Close();
        }
        return entries;
    }
}

Hi, your code helped me a lot, I didn't know SQLite had a DataAdapter similar to normal SQL server so used your code a bunch, I even did a version that gets a schema cause your code doesnt get a schema.
Here is an updated version of your code using a DataAdapter.

Thanks Again!

public DataTable SQLiteDataTableWithQuery(string sQuery)
{
DataTable dtReturnTable = new DataTable();
sqlitecon.Open();
SQLiteCommand SQLiteCommand = new SQLiteCommand();
SQLiteCommand = sqlitecon.CreateCommand();
SQLiteCommand.CommandText = string.Format(sQuery);
SQLiteDataAdapter SQLITEDataAdapter = new SQLiteDataAdapter(SQLiteCommand);
SQLITEDataAdapter.Fill(dtReturnTable);
sqlitecon.Close();
return dtReturnTable;
}

Thank you @stefanvesely !