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
Solved

ComboBox and RowFilter

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VB 2005 Tooltips on Form Load Event 15 34
I need help converting a bitmap to an image in VB.Net 1 42
Help with preventing selection from a combobox 11 34
Visual studio 2015 1 21
1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
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…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

809 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