Drop down list value remain selected even after submit button click

[wonder_gal]

Hi,

I have 2 drop down lists and 1 submit button. It works such that after the user has selected values from BOTH the drop down lists, then the user will click a "Search" button. My problem is, after the user click the "Search" button, the second drop down list is no longer displayed with the selected value, instead it displayed a default value. May I know how can I make sure the selected value remain selected even after the user clicks the "Search" button on the page?

For your info, my coding goes as

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

        If Not IsPostBack() Then
            Populate1stDropDownList()
        End If

        Populate2ndDropDownList()

    End Sub

Private Sub Populate1stDropDownList()
        Dim strSQL As String

        strSQL = "SELECT XXX"
        selCompanyName.DataSource = XXX
        selCompanyName.DataTextField = XXX
        selCompanyName.DataBind()
    End Sub

    Public Sub Populate2ndDropDownList()
        Dim strSQL As String

        strSQL = "SELECT XXX"
        selUsername.DataSource = XXX
        selUsername.DataTextField = XXX
        selUsername.DataBind()
    End Sub

Can someone kindly help?

 

[giadich]

Populate2ndDropDownList() sits outside of the IsPostBack code block. This will cause the 2nd drop down list to be re-populated every time the page is posted back.

I think moving it in would solve the issue without doing any extra coding to maintain the state of the control.

Brian Dao
http://brian-dao.blogspot.com

PS. Check out this blog: http://brian-dao.blogspot.com/2007/05/viewstate-and-postback.html