Hi, Thank you for this great book especially in handling Stored Procedures and BLL & DAL.
Ref to ch 4, Survey engine.
Is there any ideas on how you can handle adding different kind of question than "text" and the answer will not be in A,B,C,D; the answer could be option box or check box or a Date.
Also if the question require drill down (branched question) meaning based on the answer you can show/hide the following question.
Your help will be greatly appreciated

I think the structure of the Question table will be changed.
Can you give us just some ideas.
Thanks,

Hi there,

I didn't write this chapter, so I don't know the design of the application too well.

Anyway, what you can do is store the questions and answers in XML. You could create a Question class and an Answer class that both inherit XmlDocument. You can then add methods like AddQuestion or GetAnswer to these classes that add (or select) the right XML nodes from the internal XmlDocument. This gives you a flexible way to add and retrieve questions. Since it's easy to serialize such a class to a string (or to the new Xml data type in SQL Server), it's easy to save and retrieve your question data in a database.

Hope this gives you some ideas. Working with dynamic questionnaires is not an easy thing to do... Good luck ;-)

Cheers,

IMar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!