Filling data in FormView from different tables
- by wacky_coder
Hi,
I am using a FormView in an online quiz page for displaying the questions and RadioButtons (for answers)
http://stackoverflow.com/questions/2438219/online-quiz-using-asp-dot-net
Now, I need to pick the questions according to a TestID and a particular Set of that Test. The testid and the set_number would be passed using Session variables.
I'm having 3 testIDs and 3 Sets per TestID and, thus, am using 9 tables to store the Questions, the Options and the correct answer.
I need help on how to set the FormView so that it extracts the questions from a particular table only. Do I need to use a StoredProcedure ? If yes, how?
PS: If I use only one table to store all the questions from each Set and for each TestID, I can do that, but I'd prefer using separate tables.