Hoping someone can help end the misery.

I have a an aspx page that displays customer contact info at the top followed by a databound dropdownlist that contains a list of products the customer has purchased. The bottom of the page contains a label for each month of the current fiscal year showing total sales of the selected product per month.

When the page is first loaded, 3 ID's are passed from the previous page through a querystring to give me the id's required to load each of the 3 sections. Based on the 3rd one, a default product is selected in the dropdownlist and the labels are loaded accordingly.

Here's the problem:
Whenever I click in the dropdownlist to select a different product the page reloads and the customer data is gone, the dropdownlist is empty, and the labels show the previous information.

My OnSelectedIndexChanged event doesn't seem to connect with the dropdownlist. I have assigned hardcoded text to a label in the handler and it never gets set.

How can I refresh my page showing the new data based on the value selected in the dropdownlist?

Here's the code I am working with:

<SCRIPT language="vb" runat="server">
    Dim pgSalesmanID As Integer
    Dim pgCustomerID As Integer
    Dim pgProductID As Integer
    Dim curPos as Integer = 0

SUB Page_Load(sender as Object, e as EventArgs)
   If (Request.QueryString("sID") <> "") then
       pgSalesmanID = Convert.ToInt32(Request.QueryString("sID"))
   End if
   If (Request.QueryString("cID") <> "") then
    pgCustomerID = Convert.ToInt32(Request.QueryString("cID"))
   End if
   If (Request.QueryString("pID") <> "") then
        pgProductID = Convert.ToInt32(Request.QueryString("pID"))
   End if
   If (Request.QueryString("pos") <> "") then
    curPos = Convert.ToInt32(Request.QueryString("pos"))
   End if

   IF NOT Page.isPostBack then
    bindSQL()
   END IF
END SUB

SUB productList_OnChange (sender As Object, e As EventArgs)
   pgProductID = productList.SelectedItem.Value
   bindSQL()
END SUB


SUB bindSQL()
   loadProductList()
END SUB

SUB loadProductList()
   Dim cn as SQLConnection
   Dim cmd as SQLCommand
   Dim rdr as SQLDataReader
   Dim sConnectString as String = "connectionString"
   Dim sSql as String = "sp_mySp '8, 250, 11"

   cn = New SQLConnection(sConnectString)
   Try
    cn.Open()
    cmd = New SQLCommand(sSQL, cn)
    rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
    productList.DataSource = rdr
    productList.DataBind()

    Catch myException As Exception
    Response.Write("An error has occurred trying to load
           Product: " & myException.ToString())
   Finally
        If Not rdr Is Nothing Then
       rdr.Close()
        End If
        productList.Items.Insert(0, "Select Product")
        If (pgProductID <> 0) then
        productList.SelectedValue = pgProductID
    Else
            productList.SelectedIndex = 0
    End If
   End Try
END SUB

</SCRIPT>


Then my grid:

<ASP:DropDownList id="productList" width="250"
    DataValueField="ProductID"
    DataTextField="ProductCode"
    AutoPostBack="true"
    OnSelectedIndexChanged="productList_OnChange"
    runat="server"/>


I hope my question isn't to confusing. Thanks for any help you can provide.

Could there be an error in retrieving the data:

Dim sSql as String = "sp_mySp '8, 250, 11"

There is an additional ' in front of your parameter list. Maybe the event does fire, but results in an error.

Form what I can see here, the OnSelectedIndexChanged should fire, and call productList_OnChange.

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

The stored procedure does fire and it populates the dropdownlist without any problems on page load. (the asterix probably got messed up when I formated it in the text box before posting).

The funny thing is that productList_OnChange never seems to fire. I had the productID assigned to a label instead and it never gets set.

I also tried setting the handler from the sub like this:
SUB productList_OnChange (sender As Object, e As EventArgs) handles
    productList.SelectedIndexChanged
...but then my page wouldn't load at all.

I also tried turning off autoPostBack and used a button instead, but I still never get the value the user selected in the dropdownlist.

I also tried switching autowireup on and off. No go..

If I drop the databinding and hardcode the items for the dropdownlist then the event fires and I can retrieve my value. As soon as I databind it doesn't connect.

Does it make a difference if I databind using a dataset verses a reader? I am grasping at straws here.

Thanks for you comment Imar.

This isn't the answer but cleaner code.

SUB bindSQL()
   Dim cn as SQLConnection
   Dim cmd as SQLCommand
   Dim rdr as SQLDataReader
   Dim sConnectString as String = "connectionString"
   Dim sSql as String = "sp_mySp '8, 250, 11"

   cn = New SQLConnection(sConnectString)
   Try
    cn.Open()
    cmd = New SQLCommand(sSQL, cn)
    rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
    productList.DataSource = rdr
    productList.DataBind()

    Catch myException As Exception
    Response.Write("An error has occurred trying to load
           Product: " & myException.ToString())
   Finally
        If Not rdr Is Nothing Then
       rdr.Close()
        End If
        productList.Items.Insert(0, "Select Product")
        If (pgProductID <> 0) then
        productList.SelectedValue = pgProductID
    Else
            productList.SelectedIndex = 0
    End If
   End Try
END SUB

Try this:

SUB Page_Load(sender as Object, e as EventArgs)

   IF NOT Page.isPostBack then
    bindSQL()
If (Request.QueryString("sID") <> "") then
       pgSalesmanID = Convert.ToInt32(Request.QueryString("sID"))
   End if
   If (Request.QueryString("cID") <> "") then
    pgCustomerID = Convert.ToInt32(Request.QueryString("cID"))
   End if
   If (Request.QueryString("pID") <> "") then
        pgProductID = Convert.ToInt32(Request.QueryString("pID"))
   End if
   If (Request.QueryString("pos") <> "") then
    curPos = Convert.ToInt32(Request.QueryString("pos"))
   End if

   END IF
END SUB

The only thing is that I have to pull in the query string variable before calling bindSQL. In the sample code above it shows the stored procedure variables hardcoded, but they are actually passed using pgProductID.ToString() for each variable. Which loads ok the first round.

I did try wrapping the query strings and bindSQL into the IF NOT page.isPostBack statement. My OnSelectedIndexChanged event still doesn't fire. Additionally, the page has a save button that calls and update stored procedure. For it to fire, update and refresh the page with the saved data, I found I needed to have the query string items outside the test for NOT page.IsPostBack.

I tried clearing my cache too, but I still can't make the dropdownlist connect to the handler for some reason.

Make sure that you have EnableViewState set to true if you have a master page.

Make sure you have EnableViewState set to true if you have a master page.