Solved

ComboBox and RowFilter

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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

636 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