Database

Select Id, CONVERT(VARCHAR,EntryDate,111) AS EntryDate, GrossHours, GrossMinutes, DATEDIFF(minute, StartJob, EndJob) / 60 * 60 + GrossMinutes AS Total FROM [Timesheet] GROUP BY Id, EntryDate, GrossHours, GrossMinutes, StartJob, EndJob

OdbcConnection DbConnection;
OdbcDataReader DbReader;

DbConnection = new OdbcConnection("DSN=" + odbcConnName);

DbConnection.Open();

OdbcCommand DbCommand = DbConnection.CreateCommand();
    //check to make sure column names are present
                DbCommand.CommandText = ("PRAGMA table_info(bandwidth_records)");
                DbReader = DbCommand.ExecuteReader();

                while (DbReader.Read())
                {
                    Trace.WriteLine(DbReader["type"].ToString());
                }

DbReader.Close();
DbConnection.Close();