• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1844
  • Last Modified:

Implementing Combo box filter on window form : C# .NET 1.1

Hi,
I am currently using .net framework1.1  and window forms.
In one form i got two combo boxes in which values are coming from two different tables.
I want to make it such that if a user selects item from the first combo box
it filters the values and shows only relavent ones in the second combo box.
Please give some idea or option to do it.

thanks
0
AbhilashN
Asked:
AbhilashN
1 Solution
 
rameedevCommented:
There are couple of ways of doing it....

1) Load first combobox from first table. On selecting a vlues from the 1st combo get the value and use it to construct a sql statement based on this value and use it to load the 2nd combo,

// other way

2) Load 2 datasets from both the sql tables and use the first one to bind it to the 1st combo. On selecting a value from the first combo use the selected value to make a query on the 2nd dataset you will get an array of datarows...use it to constrcut datatable and bind it to the 2nd combo.

the 2nd dataset loaded initially must also have the column which is there in the 1st combo
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now