Databinding and order of events

[Rex the Strange]

I'm having a problem here and am looking for the answer. I have two
listboxes. One is a dropdown and the other is a simple list of items
which is databound . I want to be able to allow the user to change the
value in the dropdown which would, in turn, change the values in the
list.

So, I create a background routine to change the sql accordingly. Create
routine to respond to the event of the dropdown changing values. Set
autopostback to true. When can I change my sql statement? It seems to
be either before the onselectedindexchanged event fires or, if on the
databinding event of the list, it doesn't fire at all after the first
retrieval.

I'm sure this is a common thing. Please, how is it done?

tia,
rts

 

[Rex the Strange]

I'm having a problem here and am looking for the answer. I have two
listboxes. One is a dropdown and the other is a simple list of items
which is databound . I want to be able to allow the user to change the
value in the dropdown which would, in turn, change the values in the
list.

So, I create a background routine to change the sql accordingly. Create
routine to respond to the event of the dropdown changing values. Set
autopostback to true. When can I change my sql statement? It seems to
be either before the onselectedindexchanged event fires or, if on the
databinding event of the list, it doesn't fire at all after the first
retrieval.

I'm sure this is a common thing. Please, how is it done?

tia,
rts

Never mind. I just worked it out. You need to actually call the binding
method manually from the onselectedindexchanged event handler by
specifying:

textboxname.DataBind (); (in C#)