Solved

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

Posted on 2006-11-14
3
1,836 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 5

Accepted Solution

by:
rameedev earned 500 total points
ID: 17944945
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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Hi all and welcome to my first article on Experts Exchange. A while ago, someone asked me if i could do some tutorials on object oriented programming. I decided to do them on C#. Now you may ask me, why's that? Well, one of the re…
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.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

631 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