dotnet windows forms databinding: Multiple combo of same table -- dotnet windows forms databinding

Multiple combo of same table

Hemang Shah
1/29/2005 6:59:59 PM

dotnet windows forms databinding: 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

Re: Multiple combo of same table

Sahil Malik
1/30/2005 8:39:13 AM

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/

[quoted text, click to view]