C# Poll

[bjkc1986]

Hi Guys,

I'm trying to develop an opinion poll on my website (Visual Studio 2005) using c# code and a MYSql db.I have created the db and the admin side of the project for adding new polls to the db and deleting polls but I dont know how I can re-create them for the main section of the website i.e converting the questions in the db, which are in text form, into radio boxes, and then storing the votes in the db and generating a graphical view.

The Tables I have created are as follows:

create table pollQuestions 
 
( 
 
pk_Id int auto_increment not null, 
 
question varchar(100) not null, 
 
answer1 varchar(50) not null, 
 
answer2 varchar(50) not null, 
 
answer3 varchar(50) not null, 
 
answer4 varchar(50) not null, 
 
answer5 varchar(50) not null, 
 
primary key(pk_Id), 
 
unique id(pk_Id) 
 
);
 
 
create table pollAnswers 
 
( 
 
pk_Id int auto_increment not null, 
 
pollId int not null, 
 
answer varchar(50) not null, 
 
visitorIP varchar(15) not null, 
 
primary key(pk_Id), 
 
unique Id(pk_Id) 
 
);

I can Insert and delete values into pollQuestions but am having trouble trying to save these answers into pollAnswers and generating a graph with them. Also is there a way I can save the voters ip address to ensure only 1 vote is cast per person.

Apologies for being long-winded but any help would be fantastic.

Thanks

[kenobewan]

Please specify the error problem that you are having saving to poll answers. What do you plan to use to draw the graph? Does using an IP identifier label corporate users as potentially one user? Maybe using a session or cookie to identify users would be better.

[bjkc1986]

Please specify the error problem that you are having saving to poll answers. What do you plan to use to draw the graph? Does using an IP identifier label corporate users as potentially one user? Maybe using a session or cookie to identify users would be better.

I'm very new to this whole area of programming and db's and all that so i was wondering how do i store the selected 1 of the 5 answers into the answer table and increment it so that every time the answer is selected, its incremented. I was hoping to build just a basic bar graph showing the results to date but am unsure how this could be achieved in visual studio 2005

[kenobewan]

Do you have Crystal Reports installed? Here is an article that may help:
Creating Professional Reports using Crystal Report for Visual Studio.NET (Part 1)