I am using Quartz.NET for my scheduling system, and I want administrators to be able to logon to a web based form to update and delete jobs and triggers.
I plan to use a gridview to achieve this, but I have a few issues I have run into. How do I select all data from 3 tables, but make sure each row in each table corresponds to the row in the other table, so they can be put on the gridview. If I'm confusing any of you - basically in the triggers table, the linking column to the main jobs table is JOB_NAME, which is the primary key of the jobs table. And I need to link the CRON_TRIGGERS table to triggers, which links to the primary key of the triggers table (TRIGGER_NAME)
Another issue I have is that a lot of the data is stored in a binary data table (I've seen it called an 'image' and 'datamap' in the code), so how would I put the relevant information from the binary data into the gridview?
tl;dr: I need to select 3 rows from 3 tables which link to each other and put them into a gridview