I have a gridview where I'm getting a number of rows returned...
SELECT SessionName, Capacity from Sessions
However, this makes my GridView look something like this
Session 1 | 20
Session 2 | 25
However, I'd like to do another lookup on the registrants table to see how many are registered for each session, so that my GridView would look something like this...
Session 1 | 14/20
Session 2 | 11/25
Is there a way that I could do a database lookup from the registrants table for each row?? Kind of hard to explain...
But basically it will add a database lookup for every session in the sessions table. That might be 30-40 lookups. Is that a problem?
Can I do this in a GridView? Or do I need to use a C# loop?