Solved

ComboBox and RowFilter

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

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…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

778 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