How to bind two dropdown controls with the same query result

[taree]

Will it possible to bind the same query result to two dropdown controls like this? thank you

 Dim strStringBuilder As StringBuilder
        strStringBuilder = New StringBuilder
        With strStringBuilder
            .Append("SELECT TM from tbTM ")
        End With

        Dim cmdMemos As OleDbCommand = New OleDbCommand
        cmdMemos.Connection = MyTechMemoConn
        cmdMemos.CommandType = CommandType.Text
        cmdMemos.CommandText = strStringBuilder.ToString
        Dim adMemoStatus As New OleDbDataAdapter(cmdMemos)

        Dim dsMemos As New DataSet

        adMemoStatus.Fill(dsMemos, "MemoStatus")
        drpSuperSTM.DataSource = dsMemos
        drpSuperSTM.DataTextField = "TM"
        drpSuperSTM.DataValueField = "TM"
        drpTM.DataTextField = "TM"
        drpTM.DataValueField = "TM"
        drpSuperSTM.DataBind()
        drpTM.DataBind()

 

[jmeckley]

yes, load the data into a datatable. then set each dropdownlist's DataSource to the dataTable.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[taree]

Thank you Jason. I am curious though why did not the above code work for me?

 

[taree]

I figured it out. I was missing
drpTM.DataSource = dsMemos for second dropdown control.

thank you