Solved

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

Posted on 2006-11-14
3
1,822 Views
Last Modified: 2012-06-27
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
Comment
Question by:AbhilashN
3 Comments
 
LVL 5

Accepted Solution

by:
rameedev earned 500 total points
Comment Utility
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now