drop down list question.

•

What is DaniWeb IT Discussion Community?

You're currently browsing the ASP.NET section within the Web Development category of DaniWeb, a massive community of 456,499 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,735 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting

Thread Tools Display Modes

Views: 2201 | Replies: 4

•

Join Date: Sep 2007

Posts: 7

Reputation: stevendmar is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

stevendmar stevendmar is offline

Offline

Newbie Poster

drop down list question.

Sep 18th, 2007

Using Visual Web Developer, I am wanting to use a Drop-Down list on a Web Form. I know how to use HTML to create and add items to a Drop-Down list. The problem is that I need to populate the list from a database. So I used a DropDownList control from the menu. I specify where the database is and which table and columns to use. The problem I am running into, and not seeing any fix for, is that I need to be able to select an item and automatically be linked to another page. I set a table in my DB to be a hyperlink field, but that does not seem to work. I set the AutoPost to true, but all that seems to do is refresh the page. I am guessing that it is trying to place data on the same page, but that is not what I need.

So basically, all I need is a Drop Down that gets populated from a DB, and when a item is selected in the Drop Down it links to another page. Sounds easy, huh?

I need someone who is smarter than me. Can this even be done? Please help. Thank you.

•

Join Date: May 2006

Location: Bellevue, WA

Posts: 1,548

Reputation: Infarction has a spectacular aura about

Rep Power: 8

Solved Threads: 51

Infarction Infarction is offline

Offline

Battle Programmer

Re: drop down list question.

Sep 18th, 2007

Using the AutoPostBack, check the value of the drop down box. Something like this:

 Help with Code Tags 
 c# Syntax (Toggle Plain Text) 
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Page.IsPostBack)
        {
            if (DropDownList1.SelectedValue == "foo")
                Response.Redirect("somepage.aspx");
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Page.IsPostBack)
        {
            if (DropDownList1.SelectedValue == "foo")
                Response.Redirect("somepage.aspx");
        }
    }

Or, if you use VB:

 Help with Code Tags 
 VB Syntax (Toggle Plain Text) 
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Page.IsPostBack Then
            If DropDownList1.SelectedValue = "foo" Then
                Response.Redirect("somepage.aspx")
            End If
        End If
    End Sub
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Page.IsPostBack Then
            If DropDownList1.SelectedValue = "foo" Then
                Response.Redirect("somepage.aspx")
            End If
        End If
    End Sub

•

Join Date: Sep 2007

Posts: 7

Reputation: stevendmar is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

stevendmar stevendmar is offline

Offline

Newbie Poster

Re: drop down list question.

Sep 18th, 2007

I think I understand that, still learning codes. What does "foo" do? Thanks, I will give this a try.

•

Join Date: Sep 2007

Posts: 7

Reputation: stevendmar is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

stevendmar stevendmar is offline

Offline

Newbie Poster

Re: drop down list question.

Sep 18th, 2007

It still sort of refreshes the page.

•

Join Date: May 2006

Location: Bellevue, WA

Posts: 1,548

Reputation: Infarction has a spectacular aura about

Rep Power: 8

Solved Threads: 51

Infarction Infarction is offline

Offline

Battle Programmer

Re: drop down list question.

Sep 18th, 2007

foo is a value to compare against. You'll want to replace it with whatever value you have, and other values with else if statements. And I'm totally out of the habit of writing code. Those should be DropDownList.SelectedValue.Equals("foo") rather than using == and =