Loading an unfinished questionnaire from a database

  • Thread starter Thread starter Vili
  • Start date Start date
V

Vili

Hi all

I am having problems with creating an functional questionnaire with
asp.net 2.0 and MSSQL 2005 database.

I have a table with field id (key & auto int), clientId (int),
QuestionId (int), And answer (nvarchar(255)) and a set of questions on
an another table.

Questions can have 0 or more answers

so a client 10 can have the table looking like this
Id|ClientId|QuestionId|Answer|
1 |10 |1 |Yes |
1 |10 |2 |Red |
1 |10 |2 |Blue |
1 |10 |2 |White |
1 |10 |3 |None |
1 |10 |10 |1000€ |
....

The questionnaire is on a wizard-control and is composed of textboxes,
checkboxlist, radiobuttonlists and other

I have created a small class to handle the saving of data. When loading
wizard page I tell the handler class (handlerObj) the webcontrols and
the question id the control answers to.

ie. handlerObj.add(FirstQuestion, 1)

Saving the data is not a problem. I just loop the controls marked in
handlerObj and save them to the database. Problem is how to load an
unfinished questionnaire to the user to edit?

If my handlerobj has a checkboxlist with questionId 5 and it has 10
listitems to choose from.. When loading, how I set the previously
selected items checked?

All suggestions and ideas to solve this problem are appreciated.

Tuomo
 
Problem is how to load an
unfinished questionnaire to the user to edit?
Click to expand...

I think you can either enumerate the controls in the handlerObj and
find one with the questionId 5, or you can call FindControl(<name>)...
 
I have decided to add control id with the answer to the table

So when reading the questions from the database I just compare the
control id to the value from table.
 
Back
Top