I am trying to convert a survey that I had on an old survey page (aspx) to a DNN module.
The survey asks 10 questions, one at a time, then emails a report to the user.
We ask one question at a time because it is important not to see patterns in the questions.
So the process currently is:
1. Load question and 5 answers (multiple choice) as datagrid from sql database
2. Users answers question clicks NEXT button
3. update database with users answer
4. Go to next question. Repeat 1 to 4 until 10 questions
5. Send report.
I am having troubles with how to update SQL because page load happens before update.
I have tried to trap it but the page load appears to happen twice. The datagrid therefore loses the users selection.
How can I collect the users selection in the datagrid before the page load?
Why does page_load happen twice?
Your help would be greatly appreciated.
Cheers