Display values from database (variable) to drop down in ASP

Question

I am working with ASP page where I receive the values from a stored procedure to variable properly, but I am not sure how to assign values to drop down.

I used the same way for the text box and it works fine.

In code below I am assigning values from data set to variable

cc_db_SiteSurveyOnly=bbInfoRs("SiteSurveyOnly").Value

And here is a code for the the HTML

            <select name="cc_LocalSiteSiteSurveyOnly" VALUE="<%=cc_db_SiteSurveyOnly%>">
               <option value="">Select</option>
               <option value="Y">Y</option>
               <option value="N">N</option>
            </select>

Community · Accepted Answer · 2017-05-23 12:10:11Z

1

Look here: https://msdn.microsoft.com/en-us/library/0dzka5sf(v=vs.71).aspx

And populate with DataBinding. Here's a question already answered about that:

Databind a dropdownlist

edited May 23, 2017 at 12:10

CommunityBot

11 silver badge

answered Sep 8, 2016 at 19:50

n8wrl

19.9k4 gold badges70 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Display values from database (variable) to drop down in ASP

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related