0

Hi,
I have the following code that should create a dropdown when the value in the another dropdown changes. So dropdown2 is created when value of dropdown1 is changed. And dropdown2 is also programatically associated with a datasource which is access in this case.
The dropdown gets created, but for some reason doesn't get populated. What am I doing wrong?

Protected Sub dropdown1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles dropdown1.SelectedIndexChanged

        Dim ds As New AccessDataSource
        Dim dropdown2 As New DropDownList
        Dim val As String

        ds.DataFile = "<db path>"
        ds.ID = "ds"
        dropdown2.DataSource = ds
        val = dropdown1.SelectedValue


        If val = "xyz" Then
            dropdown2.DataValueField = "xyz"
            dropdown2.DataTextField = "xyz"
            ds.SelectCommand = "select distinct xyz from Tbl;"
        End If
        form.Controls.Add(dropdown2)
        form.Controls.Add(ds)
    End Sub

Thx.

2
Contributors
2
Replies
3
Views
8 Years
Discussion Span
Last Post by serkan sendur
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.