Solved

ComboBox and RowFilter

Posted on 2004-10-11
1
954 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

863 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

23 Experts available now in Live!

Get 1:1 Help Now