forms: master/detail dropdown list?

[Jerome]

Hi,

I've got a table like this

Cat1 ¦ Item1
Cat1 ¦ Item2
Cat1 ¦ Item3
Cat2 ¦ ItemA
Cat2 ¦ ItemB

I would now like to create a master and a detail dropdownlist, meaning
the master DDL displays "Cat1; Cat2" and if I select "Cat1" for example
the detail DDl will display "Item1; Item2; Item3".

I tried different ways but nothing really works. Can anyone point me to
a working solution?

Thanks a lot!

Jerome

[Grant Merwitz]

by table, do you mean DataBase table or .NET dataTable

IF its a database,
you can first query the Cat items Grouping by or distinct, to give you the
list like:
Cat1
Cat2

You can then populate the first drop down with that list.
ONce the user picks on of those options, you can then do an additional
DataBase request to get the list of Items filtered by the selected category.

This will take a server postbck though and isn't the best user experience.
You can use Cacheing to speed this up, or javascript

HTH

"Jerome" <su************ *@gmail.com> wrote in message
news:eU******** ******@TK2MSFTN GP10.phx.gbl...

Hi,

I've got a table like this

Cat1 ¦ Item1
Cat1 ¦ Item2
Cat1 ¦ Item3
Cat2 ¦ ItemA
Cat2 ¦ ItemB

I would now like to create a master and a detail dropdownlist, meaning the
master DDL displays "Cat1; Cat2" and if I select "Cat1" for example the
detail DDl will display "Item1; Item2; Item3".

I tried different ways but nothing really works. Can anyone point me to a
working solution?

Thanks a lot!

Jerome

[Jerome]

Hi, thanks for answering.

Yes, I meant a database table.
And populating the first DDL isn't the problem, the second is.

Since the whole list would be way to long for only one DDL, I thought it
would be better to split it in 2. So the user first chooses the category
in the first and then the item in the second. The question now was how
to populate the second DDL based on the first one.

If Postback isn't the best way, what other options do I have and how
would I implement that in my ASP.NET code?

Thanks a lot.

Grant Merwitz wrote:

by table, do you mean DataBase table or .NET dataTable

IF its a database,
you can first query the Cat items Grouping by or distinct, to give you the
list like:
Cat1
Cat2

You can then populate the first drop down with that list.
ONce the user picks on of those options, you can then do an additional
DataBase request to get the list of Items filtered by the selected category.

This will take a server postbck though and isn't the best user experience.
You can use Cacheing to speed this up, or javascript

HTH

"Jerome" <su************ *@gmail.com> wrote in message
news:eU******** ******@TK2MSFTN GP10.phx.gbl...

Hi,

I've got a table like this

Cat1 ¦ Item1
Cat1 ¦ Item2
Cat1 ¦ Item3
Cat2 ¦ ItemA
Cat2 ¦ ItemB

I would now like to create a master and a detail dropdownlist, meaning the
master DDL displays "Cat1; Cat2" and if I select "Cat1" for example the
detail DDl will display "Item1; Item2; Item3".

I tried different ways but nothing really works. Can anyone point me to a
working solution?

Thanks a lot!

Jerome

[Grant Merwitz]

The easiest most straight forward way would be to do an additional call
causing a post back.
Where for every call you'de be repopulating the same dropdowns contents with
a filetered list based on the first list.

This could be done with the SelectedIndexCh anged option on the first
dropdownlist, that will call a method that reads its selected value,
retrieves a filtered list from your DB based on that value, and then binds
this list to the second DropDown.

To avoid doing a post back, you'll either have to user XmlHttp (xml over
http), to bind the list client side, or initially build javascript from your
given dataset to filter the list client side.
This is quite a bit more complex, and although a better user experience, the
first method is much easier to implement and more importantly works
"Jerome" <su************ *@gmail.com> wrote in message
news:OW******** *****@TK2MSFTNG P10.phx.gbl...

Hi, thanks for answering.

Yes, I meant a database table.
And populating the first DDL isn't the problem, the second is.

Since the whole list would be way to long for only one DDL, I thought it
would be better to split it in 2. So the user first chooses the category
in the first and then the item in the second. The question now was how to
populate the second DDL based on the first one.

If Postback isn't the best way, what other options do I have and how would
I implement that in my ASP.NET code?

Thanks a lot.

Grant Merwitz wrote:

by table, do you mean DataBase table or .NET dataTable

IF its a database,
you can first query the Cat items Grouping by or distinct, to give you
the list like:
Cat1
Cat2

You can then populate the first drop down with that list.
ONce the user picks on of those options, you can then do an additional
DataBase request to get the list of Items filtered by the selected
category.

This will take a server postbck though and isn't the best user
experience.
You can use Cacheing to speed this up, or javascript

HTH

"Jerome" <su************ *@gmail.com> wrote in message
news:eU******** ******@TK2MSFTN GP10.phx.gbl...

Hi,

I've got a table like this

Cat1 ¦ Item1
Cat1 ¦ Item2
Cat1 ¦ Item3
Cat2 ¦ ItemA
Cat2 ¦ ItemB

I would now like to create a master and a detail dropdownlist, meaning
the master DDL displays "Cat1; Cat2" and if I select "Cat1" for example
the detail DDl will display "Item1; Item2; Item3".

I tried different ways but nothing really works. Can anyone point me to a
working solution?

Thanks a lot!

Jerome

[clintonG]

search: dependent listbox

<%= Clinton Gallagher
METROmilwaukee (sm) "A Regional Information Service"
NET csgallagher AT metromilwaukee. com
URL http://metromilwaukee.com/
URL http://clintongallagher.metromilwaukee.com/
"Grant Merwitz" <gr***@workshar e.com> wrote in message
news:uO******** ******@tk2msftn gp13.phx.gbl...

The easiest most straight forward way would be to do an additional call
causing a post back.
Where for every call you'de be repopulating the same dropdowns contents
with a filetered list based on the first list.

This could be done with the SelectedIndexCh anged option on the first
dropdownlist, that will call a method that reads its selected value,
retrieves a filtered list from your DB based on that value, and then binds
this list to the second DropDown.

To avoid doing a post back, you'll either have to user XmlHttp (xml over
http), to bind the list client side, or initially build javascript from
your given dataset to filter the list client side.
This is quite a bit more complex, and although a better user experience,
the first method is much easier to implement and more importantly works
"Jerome" <su************ *@gmail.com> wrote in message
news:OW******** *****@TK2MSFTNG P10.phx.gbl...

Hi, thanks for answering.

Yes, I meant a database table.
And populating the first DDL isn't the problem, the second is.

Since the whole list would be way to long for only one DDL, I thought it
would be better to split it in 2. So the user first chooses the category
in the first and then the item in the second. The question now was how to
populate the second DDL based on the first one.

If Postback isn't the best way, what other options do I have and how
would I implement that in my ASP.NET code?

Thanks a lot.

Grant Merwitz wrote:

by table, do you mean DataBase table or .NET dataTable

IF its a database,
you can first query the Cat items Grouping by or distinct, to give you
the list like:
Cat1
Cat2

You can then populate the first drop down with that list.
ONce the user picks on of those options, you can then do an additional
DataBase request to get the list of Items filtered by the selected
category.

This will take a server postbck though and isn't the best user
experience.
You can use Cacheing to speed this up, or javascript

HTH

"Jerome" <su************ *@gmail.com> wrote in message
news:eU******** ******@TK2MSFTN GP10.phx.gbl...

Hi,

I've got a table like this

Cat1 ¦ Item1
Cat1 ¦ Item2
Cat1 ¦ Item3
Cat2 ¦ ItemA
Cat2 ¦ ItemB

I would now like to create a master and a detail dropdownlist, meaning
the master DDL displays "Cat1; Cat2" and if I select "Cat1" for example
the detail DDl will display "Item1; Item2; Item3".

I tried different ways but nothing really works. Can anyone point me to
a working solution?

Thanks a lot!

Jerome