Solved

ComboBox and RowFilter

Posted on 2004-10-11
1
962 Views
Last Modified: 2012-08-13
Hi,

I'm using the display value (= Val) of a ComboBox (= Combo1) to filter records in a DataGrid.

The ComboBox is bound to a DataView (= dv) which is itself bound to a DataTable (= dt).

My problem is that there are several occurences of each item and obviously I need to keep only one for filtering purposes.

How can I achieve that?

I've seen something about  SQL's "CLAUSE DISTINCT" but how can I use that in a RowFilter expression?

Any help shall be greatly appreciated.

0
Comment
Question by:Ghanisen
[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
1 Comment
 
LVL 4

Accepted Solution

by:
eozz_2000 earned 500 total points
ID: 12281802
When I have that problem, I select the distinct options to filter my dataView and add them to the comboBox manually.

My dataGrid is bounded to my dataView, and the dataView is filtered by the text in my comboBox.
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
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.

739 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