Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Dependent Dropdownlist boxes
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Dependent Dropdownlist boxes

 Post Reply Post Reply
Author
Misty View Drop Down
Senior Member
Senior Member
Avatar

Joined: 06 February 2002
Location: United States
Status: Offline
Points: 711
Post Options Post Options   Thanks (0) Thanks(0)   Quote Misty Quote  Post ReplyReply Direct Link To This Post Topic: Dependent Dropdownlist boxes
    Posted: 13 September 2005 at 1:54am

I have a form with two drop down boxes. The first one, dropCounty is fine. But I'd like for the second one, dropCity to depend on dropCounty for the value. I would like for the dropCity box to show only cities that are for the certain county that was chosen. I would like for the second drop down box to be hidden until the person has chosen a county.  Can someone please help me with the code for this?


Here's my code:

        '----------------------------------------------------------------

        ' name: BindCountyList() - Fine

        '----------------------------------------------------------------

        Sub BindCountyList()

   

    Dim strConnect As String   

    Dim conCounty As New System.Data.SqlClient.SQLConnection

    Dim cmdSelect As New System.Data.SqlClient.SQLCommand

    Dim dtrCounty As System.Data.SqlClient.SqlDataReader

   

    'Get connection string from Web.Config

    strConnect = ConfigurationSettings.AppSettings("ConnectionString")

 

    conCounty = New System.Data.SqlClient.SQLConnection(strConnect)

    conCounty.Open()

    cmdSelect = New System.Data.SqlClient.SQLCommand( "Select CountyID, County From County Order by County", conCounty)

    dtrCounty = cmdSelect.ExecuteReader()

 

    dropCounty.DataSource = dtrCounty

    dropCounty.DataValueField = "CountyID"

    dropCounty.DataTextField = "County"

    dropCounty.DataBind()

   

     'Add and select a "Select County" option for the DDL

     dropCounty.Items.Insert(0, new ListItem("Select County", ""))

     dropCounty.SelectedIndex = 0

 

    dtrCounty.Close()

  &nbs

Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 15 September 2005 at 9:36am
Not feeling like going through all your code but essentially, have ddl1 for countries and ddl2 for cities
with visible=false and ddl1.AutoPostBack=True
 
[code]
   

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        If Not Page.IsPostBack Then

            BindCountryList()

        End If

    End Sub

 

    Private Sub BindCountryList()

        Dim strConnect As String

        Dim conCounty As New System.Data.SqlClient.SqlConnection

        Dim cmdSelect As New System.Data.SqlClient.SqlCommand

        Dim dtrCounty As System.Data.SqlClient.SqlDataReader

        'Get connection string from Web.Config

        strConnect = ConfigurationSettings.AppSettings("ConnectionString")

        conCounty = New System.Data.SqlClient.SqlConnection(strConnect)

        conCounty.Open()

        cmdSelect = New System.Data.SqlClient.SqlCommand("Select CountyID, County From County Order by County", conCounty)

        dtrCounty = cmdSelect.ExecuteReader()

        dropCounty.DataSource = dtrCounty

        dropCounty.DataValueField = "CountyID"

        dropCounty.DataTextField = "County"

        dropCounty.DataBind()

        dtrCounty.Close()

        conCounty.Close()

    End Sub

 

    Private Sub dropCounty_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dropCounty.SelectedIndexChanged

        dropCity.Items.Clear()

        Dim strConnect As String

        Dim conCity As New System.Data.SqlClient.SqlConnection

        Dim cmdSelect As New System.Data.SqlClient.SqlCommand

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.