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 wrote:
> 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#)