Hello all,
I've prepared a page that has a couple of DropDownLists.
When the value of DropDownList1 is changed, it prepares a list of items in DropDownList2 based on the value of DropDownList1.
The data for the lists comes from an Excel spreadsheet which is captured as soon as the form is loaded.
Unfortunately, I can only get the correct values into DropDownList2 if the AutoPostBack property of DropDownList1 is true. However, what I'm finding is that by setting AutoPostBack to true, it loads the data again when the value of List1 is changed.
I've tried setting a boolean flag to indicate that the data is loaded, and check for it before loading the data, but this is reset because of the AutoPostBack (I think).
Any pointers would be appreciated.