NSurvey - Survey Overview

Posted Monday, February 21, 2005 10:48 PM by CumpsD
The first thing I noticed is the small dropdown in the admin section listing all available surveys. This would become my starting point for users, a perfect place to choose the survey they want to take.

I tracked this down to the SurveyListControl user control which I inherited to create SurveyListControlOverview. This user control removes to automatic postback when it’s in overview mode and also provides an OverviewSurveyId property to indicate the selected survey. It also displays all surveys, because it had to run in anonymous mode, without users having to log on before being able to answer. A shared password would be provided on the event, giving access to the survey.

After this, the user could select a survey from the dropdown list. The only problem was that the choices were ordered by creation date, which would become a problem in the long run when a lot of surveys would be available. To change this I added a simple ORDER BY Title in the vts_spSurveyGetList stored procedure.

At this point, I had a dropdown list with all surveys listed alphabetically to add to any aspx page I wanted.

Filed under:

Comments

# Introducing and extending Nsurvey

Tuesday, February 22, 2005 1:10 AM by TrackBack

# re: NSurvey - Survey Overview

Tuesday, March 15, 2005 7:26 AM by Patrick

Thats a good idea but after adding the ORDER BY TITLE to the SProcedure how did u print out the date?
Can you please explain more?
Thanks

# re: NSurvey - Survey Overview

Tuesday, March 15, 2005 9:45 AM by David Cumps

The title of the survey includes the date :)

It sorts them alphabetically, but in the system I only added 2 surveys called '03/........' and '11/........', so the dates were part of the title.

So instead of having it ordered by creation date, I changed it to be alphabeticall, that's the only change.