Survey results: How do I retrieve and view it ?

Hi all,

I have done a small prototype survey with just two questions.. using webforms and all..

The QUESTION is : How do I retrieve and view it after I gather many people have taken the survey ?

For eg user choose a radio button M for male ?

=> How do I see how many males are surveyed?

Kayln87

Do you have a database in which you save results of the survey?

Hi Kipo,

No i dun have a database from which my questions and answers can be pulled out from.

I realised its possible to view back retrieve and view past results for a quiz engine but mine's a survey. I do not want the people who are being surveyed to see the results.

How do I consolidate all the data for each question and display it to the adminstrator. A typical result, I as the adminstrator will want to know is stimulated as below

Out of 2000 surveyed, How many are Male or Female ? <= I wish to retrieve and view this result , given one of the question is

What is your gender?

radiobutton M

radiobutton F

So, basically, you have Radio Button controls and you want to know how many times users clicked on "male"? It's impossible to achieve your goal without some sort of database (it doesn't have to be SQL database, you can use Access database, XML file, or even ordinary txt file).

Hi Kipo and anyone who can help on this..

Yes. I think I understand that I'll need to implement a database, but how do I go about doing it?

Is it possible for you to list down the steps i need to take to implement?

1. implementation of survey question. <= ie to say I pull my questions from a database? => how to implement database management on survey questions... they are quite long i feel, not like account figures like customerID as such.

2. How to I retrieve the information, do I need to set up views as in admin login then I can see the data?

Kayln87

Best option is store the data in a database. If you dont have a database, you can store it even in a .txt file also..

Hi

Are your survey questions going to change over time? If yes, You have to store it in a database. Otherwise, if it is for a single time use, implement it in front end itself. For each answer, try to make a column in the database: Eg; for male/female Question you can create a boolean column or a varchar column. For a question of number of children, you can create a column of numeric type. It goes on like this,

The basic tables you need to use are

1. A user management table( user name, password etc) -- if you want to keep track of the names of the users of the survey and who has answered what.

2. A survey table (user id column, each answer columns)

Thats all I feel for a small scale application

Otherwise, if it is for a single time use, implement it in front end itself. For each answer, try to make a column in the database: Eg; for male/female Question you can create a boolean column or a varchar column. For a question of number of children, you can create a column of numeric type.

Hidineshspillai and anyone who can help on this,

My survey is for a single time use, I do not understand when you say implement it infront end itself? does it mean juz put some tables and radio buttons and label boxes?

How do you create a boolean column or varchar column?

My survey is pretty long which questions like age group

sex

profession

nationality

no of pple in household

ages of people in household ... and so on

as you can see I dun think I can implement a database as i might be fixing the no of columns for my questions's options... as the no of choices vary from different questions.

Thank You

Kayln87

Helpp ANYONE ???

Hi Kaylan87,

I have two questions to you about your application

1.Is the survey application is meant only for some specific users(whom you know) or any one(without revealing their identity) can fill it?

If your application falls in the first case(specific users) you have to store the user details in a database(it can be sql server,oracle or even MS access).Again you have to create a separate page for authentication of the user. The user can access the survey page only after a successful anuthentication

2. How many times can one attend the survey?

If you are not targetting a specic group of people, you need not give a authenication page and a user table(in the database)

>>>>" I do not understand when you say implement it infront end itself? does it mean juz put some tables and radio buttons and label boxes?
What I meant by implementing in front end is you create a web page for the survey, put each of your questions in each labels, create a set of input controls like

sex : Radio Button, (for male and female)

profession (If you have some Idea about the user's Profession, you can show a set of occupations in a drop down list, otherwise put a textbox)

nationality (drop down List, load all countries in it)

no of pple in household (again dropdown List)

ages of people in household ()----> I think this is the area which disturbs you, since the number of answers will vary case to case. This can be tackled by creating a separate table in the database- in which the userid/SurveyID , questionID(those questions which may have multiple number of answers have to be stored in the database with an ID through which you can uniquely identify the question) and answer.

>>>>>>>>>> How do you create a boolean column or varchar column

I was referring to database column, not in asp.net

Hope this information didnt confuse you,

Thanks,

Dinesh

Hi there,

by far I think you got what I mean to set out and do. However my problem here is that i do not understand how I can save all these users' inputs and view it when I am done with the collection of survey results. iesaving the user inputs into a database i think

Is the survey application is meant only for some specific users(whom you know) or any one(without revealing their identity) can fill it?

Ans:It is for any one(without revealing their identity) to fill it.

THANKS!!

Kayln

Hi Kaylan,

Which database is available there? Oracle/SQL Server/ MS Access ?????

Thanks,

Dinesh

Hi Dinesh,

I have SQL express edition 2005 installed. By the way my name is Kayln!! hahaha

Thank you !

Kayln

Hi Kayln,

Sorry for mispronouncing your name :.

Here is an article which tells about connecting to sql express:

http://msdn2.microsoft.com/en-us/library/ms228037.aspx

Thanks,

Dinesh