Displaying data from the database

[tapan t]

Hello,

I've two SQL tables. Q_Master(Q_ID,Question_DET,DIS_MODE) and
ANS_MASTER(ANS_ID,ANSWERS,QUESTION_ID,SCORE)

There are lot of questions in the database and answers for that
respective questions..What I need is, in my ASP page I need to display
all the questions and Answers for that respective questions.

for example: Question1 : How old are you?
Answer 1: < 20
Answer 2: Between 21 and 25
Answer 3: Between 26 and 30
Answer 4: >30

I need to display these answers based on the display mode. If the
dis_mode=selbox I need to display all the above answers in a selectbox
and if dis_mode=option..I need to display the same in option buttons.

Please help me in doing this

 

[Cor]

Hi Tapan,

Here a link to the vb.resource kit, with a lot of samples and walkthroughs
how to do those things you ask.

http://msdn.microsoft.com/vbasic/vbrkit/default.aspx

And if you have problems installing it

http://msdn.microsoft.com/vbasic/vbrkit/faq/#installvdir

I hope this helps?

Cor