Cloning Possible?

[Guest]

Hi All


I have created a survey form in which the questionaire contains 20
questions. Of the 20, 16 are dropdownlist boxes where the user can select
their answer, the Selections are all the same. I am currently running a
function that creates a new dropdownlist by calling a stored proceedure and
adding it to the dropdownlist every time i need one of the 16 boxes. This
seems inefficient to me to be creating them in this manner and being new to
ASP.Net I am wondering if some one with more experience than me can show me
how to clone the the first box after the first dropdownlist is created from
the datareader.

Any Help is greatly appreciated

TIA

TheMightyThor

 

[Steve C. Orr [MVP, MCSD]]

One good solution would be to execute your query once and cache the data
into a DataTable.
Then you can attach each of your dropdownlists to the same DataTable.
Here's more info:
http://www.dotnet247.com/247reference/System/Data/DataTable.aspx
http://msdn.microsoft.com/library/en-us/cpref/html/frlrfsystemwebcachingcacheclasstopic.asp