473,769 Members | 3,102 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Help with populating a questionnaire!

Hi,
I'm trying to develop a questionnaire.. .basically a user can pick one
of 5 questionnaires they want to use, and based on their choice, those
questions will appear in their form.

So the database table contains all the questions/radiobutton selections
in one table (well, a view), and they are related to their respective
questionnaires based on a form ID.

Now, How do I populate a RadiobuttonList , AND label above the
radiobuttonlist , so that the the label would hold the question, and the
radiobuttonlist would hold the selections for that question...and this
would be based on form, and based on question (ie, some questions only
have 3 choices, some have 2, etc). I guess I just need some help
starting off the code for both the design, and SQL. Would I use the
Repeater for this? I've never used this before, so I'm not sure how to
implement it. Anyway, if anyone has suggestions, please let me know!!
I need help! Thanks!

Here is some sample data of the table:

QID Question FID Radio_Caption Radio_Value
1 1) Please rate your knowledge FormA very little knowledge 1
1 1) Please rate your knowledge FormA little knowledge 2
1 1) Please rate your knowledge FormA some knowledge 3
2 2) Does anyone in your family FormA Yes 1
2 2) Does anyone in your family FormA No 2
3 3) Genes are made of FormA DNA 1
3 3) Genes are made of FormA RNA 2
3 3) Genes are made of FormA proteins 3
21 1) Have you ever had testing FormB Yes 1
21 1) Have you ever had testing FormB No 2
22 2) The religious affiliation FormB Buddhism 1
22 2) The religious affiliation FormB Catholic 2
22 2) The religious affiliation FormB Hinduism 3

Sep 8 '06 #1
3 1637
Start by using the web to search for tutorials that explain how to populate
a control with data. You can start with tutorials that discuss how to
populate DropDownList controls with data because those tutorials are easy to
find. They will help you get insight into how the database is accessed and
how the data is bound to a control's list items. It seems you will also need
to learn how to generate a control dynamically because you may never know
how many RadioButtons each question will need.

<%= Clinton Gallagher
NET csgallagher AT metromilwaukee. com
URL http://clintongallagher.metromilwaukee.com/
MAP 43°2'17"N 88°2'37"W : 43°2'17"N 88°2'37"W
<st********@gma il.comwrote in message
news:11******** **************@ i42g2000cwa.goo glegroups.com.. .
Hi,
I'm trying to develop a questionnaire.. .basically a user can pick one
of 5 questionnaires they want to use, and based on their choice, those
questions will appear in their form.

So the database table contains all the questions/radiobutton selections
in one table (well, a view), and they are related to their respective
questionnaires based on a form ID.

Now, How do I populate a RadiobuttonList , AND label above the
radiobuttonlist , so that the the label would hold the question, and the
radiobuttonlist would hold the selections for that question...and this
would be based on form, and based on question (ie, some questions only
have 3 choices, some have 2, etc). I guess I just need some help
starting off the code for both the design, and SQL. Would I use the
Repeater for this? I've never used this before, so I'm not sure how to
implement it. Anyway, if anyone has suggestions, please let me know!!
I need help! Thanks!

Here is some sample data of the table:

QID Question FID Radio_Caption Radio_Value
1 1) Please rate your knowledge FormA very little knowledge 1
1 1) Please rate your knowledge FormA little knowledge 2
1 1) Please rate your knowledge FormA some knowledge 3
2 2) Does anyone in your family FormA Yes 1
2 2) Does anyone in your family FormA No 2
3 3) Genes are made of FormA DNA 1
3 3) Genes are made of FormA RNA 2
3 3) Genes are made of FormA proteins 3
21 1) Have you ever had testing FormB Yes 1
21 1) Have you ever had testing FormB No 2
22 2) The religious affiliation FormB Buddhism 1
22 2) The religious affiliation FormB Catholic 2
22 2) The religious affiliation FormB Hinduism 3

Sep 8 '06 #2
I've looked some stuff up, and only found basic code which I've played
with. My problem is now combining the labels/radiobuttonlist s into
specific questions by relating them to each other. I'd rather figure
this part out first, and then try to figure out how to dynamically
check for how many radiobuttons will be needed. Any ideas?
clintonG wrote:
Start by using the web to search for tutorials that explain how to populate
a control with data. You can start with tutorials that discuss how to
populate DropDownList controls with data because those tutorials are easyto
find. They will help you get insight into how the database is accessed and
how the data is bound to a control's list items. It seems you will also need
to learn how to generate a control dynamically because you may never know
how many RadioButtons each question will need.

<%= Clinton Gallagher
NET csgallagher AT metromilwaukee. com
URL http://clintongallagher.metromilwaukee.com/
MAP 43°2'17"N 88°2'37"W : 43°2'17"N 88°2'37"W
<st********@gma il.comwrote in message
news:11******** **************@ i42g2000cwa.goo glegroups.com.. .
Hi,
I'm trying to develop a questionnaire.. .basically a user can pick one
of 5 questionnaires they want to use, and based on their choice, those
questions will appear in their form.

So the database table contains all the questions/radiobutton selections
in one table (well, a view), and they are related to their respective
questionnaires based on a form ID.

Now, How do I populate a RadiobuttonList , AND label above the
radiobuttonlist , so that the the label would hold the question, and the
radiobuttonlist would hold the selections for that question...and this
would be based on form, and based on question (ie, some questions only
have 3 choices, some have 2, etc). I guess I just need some help
starting off the code for both the design, and SQL. Would I use the
Repeater for this? I've never used this before, so I'm not sure how to
implement it. Anyway, if anyone has suggestions, please let me know!!
I need help! Thanks!

Here is some sample data of the table:

QID Question FID Radio_Caption Radio_Value
1 1) Please rate your knowledge FormA very little knowledge 1
1 1) Please rate your knowledge FormA little knowledge 2
1 1) Please rate your knowledge FormA some knowledge 3
2 2) Does anyone in your family FormA Yes 1
2 2) Does anyone in your family FormA No 2
3 3) Genes are made of FormA DNA 1
3 3) Genes are made of FormA RNA 2
3 3) Genes are made of FormA proteins 3
21 1) Have you ever had testing FormB Yes 1
21 1) Have you ever had testing FormB No 2
22 2) The religious affiliation FormB Buddhism 1
22 2) The religious affiliation FormB Catholic 2
22 2) The religious affiliation FormB Hinduism 3
Sep 11 '06 #3
I guess I need to come up with the code for a loop, but i'm not sure of
the syntax....
st********@gmai l.com wrote:
I've looked some stuff up, and only found basic code which I've played
with. My problem is now combining the labels/radiobuttonlist s into
specific questions by relating them to each other. I'd rather figure
this part out first, and then try to figure out how to dynamically
check for how many radiobuttons will be needed. Any ideas?
clintonG wrote:
Start by using the web to search for tutorials that explain how to populate
a control with data. You can start with tutorials that discuss how to
populate DropDownList controls with data because those tutorials are easy to
find. They will help you get insight into how the database is accessed and
how the data is bound to a control's list items. It seems you will alsoneed
to learn how to generate a control dynamically because you may never know
how many RadioButtons each question will need.

<%= Clinton Gallagher
NET csgallagher AT metromilwaukee. com
URL http://clintongallagher.metromilwaukee.com/
MAP 43°2'17"N 88°2'37"W : 43°2'17"N 88°2'37"W
<st********@gma il.comwrote in message
news:11******** **************@ i42g2000cwa.goo glegroups.com.. .
Hi,
I'm trying to develop a questionnaire.. .basically a user can pick one
of 5 questionnaires they want to use, and based on their choice, those
questions will appear in their form.
>
So the database table contains all the questions/radiobutton selections
in one table (well, a view), and they are related to their respective
questionnaires based on a form ID.
>
Now, How do I populate a RadiobuttonList , AND label above the
radiobuttonlist , so that the the label would hold the question, and the
radiobuttonlist would hold the selections for that question...and this
would be based on form, and based on question (ie, some questions only
have 3 choices, some have 2, etc). I guess I just need some help
starting off the code for both the design, and SQL. Would I use the
Repeater for this? I've never used this before, so I'm not sure how to
implement it. Anyway, if anyone has suggestions, please let me know!!
I need help! Thanks!
>
Here is some sample data of the table:
>
QID Question FID Radio_Caption Radio_Value
1 1) Please rate your knowledge FormA very little knowledge 1
1 1) Please rate your knowledge FormA little knowledge 2
1 1) Please rate your knowledge FormA some knowledge 3
2 2) Does anyone in your family FormA Yes 1
2 2) Does anyone in your family FormA No 2
3 3) Genes are made of FormA DNA 1
3 3) Genes are made of FormA RNA 2
3 3) Genes are made of FormA proteins 3
21 1) Have you ever had testing FormB Yes 1
21 1) Have you ever had testing FormB No 2
22 2) The religious affiliation FormB Buddhism 1
22 2) The religious affiliation FormB Catholic 2
22 2) The religious affiliation FormB Hinduism 3
>
Sep 11 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1042
by: Rattanan Nantiyakul | last post by:
Subject: A Student Needs Your Help with Research Dear All, I am pursing a Master’s degree from Monash University. Currently, I am in the final stage of my program. I am doing a research project examining the impact of Microsoft’s Reporting Services Product on the business intelligence market. It is to this end that I request your participation.
0
1077
by: rattanan | last post by:
Dear All, I am pursing a Master's degree from Monash University. Currently, I am in the final stage of my program. I am doing a research project examining the impact of Microsoft's Reporting Services Product on the business intelligence market. It is to this end that I request your participation. The following URL will lead you to the online questionnaire. Completing the questionnaire should take approximately 10 minutes of your time....
0
269
by: rattanan | last post by:
Subject: A Student Needs Your Help with Research Dear All, I am pursing a Master’s degree from Monash University. Currently, I am in the final stage of my program. I am doing a research project examining the impact of Microsoft’s Reporting Services Product on the business intelligence market. It is to this end that I request your participation.
3
2235
by: Jason A. Thompson | last post by:
Dear Access Gurus, I have a database which I hoped to use to administer questionnaires, or rather that someone who knows nothing about Access could use to administer them. Each q'aire item is on a different form and I dropped in command buttons on each to move forward and backward through the "pages" of the q'aire. Problem is, the first record in the common underlying table is overwritten each time we go through the q'aire. (The code to...
4
8478
by: madereal | last post by:
howdy scriptors… here’s my question: Project Background: I’m creating a database that will hold questionnaire data. Situation: I would like to set up a combobox with a changing rowsource property on a continuous form. I have created a query for the record source so that the text value of the rowsource property is included as a separate field for each record. I have call this field: and an example of the text is: (1;Yes;2;No). ...
47
2887
by: Jo | last post by:
Hi there, I'm Jo and it's the first time I've posted here. I'm in process of creating a database at work and have come a little unstuck.....I'm a bit of a novice and wondered if anyone could help. I work in a library and send out dual language books to babies of dual or other nationality. The db is to be used for logging a range of book titles and numbers ordered and books sent out to individuals. I am trying to work out a way of...
2
1471
by: Vili | last post by:
Hi all I am having problems with creating an functional questionnaire with asp.net 2.0 and MSSQL 2005 database. I have a table with field id (key & auto int), clientId (int), QuestionId (int), And answer (nvarchar(255)) and a set of questions on an another table. Questions can have 0 or more answers
4
2794
by: cheeseomlette | last post by:
Hi there, I am learning Visual Basic language through Visual Basic Express 2005, and am unfortunately having a tough time with it - it just doesn't seem to come intuitively to me. I have to create a psychology questionnaire where the participant is displayed with 5 questions, and they have to select (using radio buttons) how strongly they agree on a scale of 1 to 7. Their score at the end corresponds to the amount their selection adds up...
0
1461
by: doobybug | last post by:
Hi all, I really need your help! I am new to java and have some problems with my code. I have a program which inputs questionnaires and creates an object for each questionnaire. These objects are then saved in a vector which in turn is then encoded in an XML file. For all this I have made a class called MainInput. The problem is with MainOutpu class. I want to make a class that prints the questionnaires in alphabetical order (which is already...
0
9589
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9423
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
9999
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9866
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8876
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7413
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
1
3967
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3570
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2815
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.