DataSet filtering

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tim Smith (timasmith_at_hotmail.com)
Date: 06/18/04 

Date: 17 Jun 2004 17:31:46 -0700

Hi,

If I retreive a set of records from my database e.g.

NAME GROUP
John Beetles
John Sting
John Queen
Bob Brittany

and I have in a dataset. If I want to display in a list

Bob
John

is there an easy way to do a operation such as SELECT DISTINCT NAME FROM DATASET
so that I can filter it without doing another database call?

thanks

Tim

Relevant Pages

  • DataSet filtering
    ... If I retreive a set of records from my database e.g. ... John Beetles ... John Sting ... Bob Brittany ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Permission to open database
    ... John I got it to work with the code below I got from an example I found. ... Dim rst As DAO.Recordset ... "Please contact the Database Adminstrator for assistance.", ... "WelcomeForm" ...
    (microsoft.public.access.gettingstarted)
  • Re: Exporting Info To Word File
    ... degree of automation) to get individual records from an existing databse when ... need from my database. ... "John Nurick" wrote: ... >>> document from the template, and place the information in the bookmarks ...
    (microsoft.public.access.externaldata)
  • Re: Communication Log
    ... "John Marshall, MVP" wrote: ... Visio MVP ... May I send you copy of the database that I made? ... a communication log in the database so that it will store the Date, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Export Project notes to Access or Excel
    ... John: I have the same problem as the OP. ... Unfortunately SQL Reporting Services does not have a text field that will ... The macro couldn't get past the 'Dim cn ... Actually you CAN use the code you found in the Project database ...
    (microsoft.public.project)