Multiple combo of same table

[Hemang Shah]

Hello

I have a lookup table in my database like this:

tblLookup
LookupType
LookupValue


Suppose that lookup type is Language Spoken; Country; Gender etc..

and I want the individual combo box to list only the values of one type.

So I can have a combo for each: LanguageSpoken, Country, Gender etc.

There are about 20 lookups..

So what is the best practice ?

To create 20 DataView of the same table and apply filter ? (All have to be
visible simultaneously) or populate an array and bind the combo to the array
?

Please Advise

HS

 

[Sahil Malik]

I like the array approach better. You'll probably have to do a new
DataBinding to get the proper display text and value though.

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/