Re: Web Form/SQL Table Structure

Hi Steven,

I Have a couple of question about using the first table structure. The main
issue is that the user needs to be able to update their information over
time.

Lets say I have 3 questions (to make this short) that need to be answered,
each of a different control type:
Question 01: DropDownList
Question 02: MultiLine Text Box
Question 03: RadioButtonList

So the Repeater tool output would look something like this:

1. What Region are you operating in?
DropDownList for regions

2. What is the ops plan and revenue projection for this region?
MultiLine TextBox

3. Is the product available today?
0 yes 0 no

So using the Repeater Tool,
1. How would I call the correct control for the question (DropDownList,
RadioButtonList, TextBox)?
2. How do I name the controls on the fly?
3. How and when would I populate the DropDownList with values from a
stored procedure since I don't know what the DDL name is for binding?
4. When do you do the Binding for DropDownList and RadioButtonList
controls

Anyway, thanks for your help...



MarketingRequest
----------------
MktRequest_ID
MktQuestion
MktAnswer


MarketingRequest
----------------
MktRequest_ID
MktQuestion01
MktAnswer01
MktQuestion02
MktAnswer02
MktQuestion03
MktAnswer03





"Steven Cheng[MSFT]" <stcheng@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:qEypz0lxGHA.3392@xxxxxxxxxxxxxxxxxxxxxxxx
Hello Steve,

As for database table structure, I also think the first one should be more
reasonable.

In the last message, you said that

=============
However, since this needs to be on a web form, should I use the following:
=============

do you mean you want to display all the questions on the single web page?
If so, there're many means to do this:

1. Use databound template control such as DataList, Repeater to display
the
questions through a DataReader or DataSet query from database.

2. Programmtically use code to construct a Table and add rows to display
each questions from Datareader or DataSet

Also, if you're using template databound control(datalist or repeater), it
also easy to submit the page and query new value in each template control
item and update them into backend database. How do you think of this?

Please feel free to let me know if there is any particular concerns here
or
anything else you wonder.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead



==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.



Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================



This posting is provided "AS IS" with no warranties, and confers no
rights.




.