Dynamic dataset filter

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

Situation:

Vb .net windows application
SQL 2000 Database


I have a flat "customer" table on a database and wish to design an
application which behaves similar to itunes, so that the table can be
filtered.

For example instead of "genre" I want a list of "customer
class's" which will be generated from a "group by" on the
"customer class" on the "customer" table.

The difference is that in itunes you only click on one filter record,
which brings up the related records. This can easily be done using
relationships in the dataset.

I wish to add a check box next to each selection in the filter list and
build the related records up.

I tried look at including the checkbox field into the relations, but
this creates a number of problems.

I might be missing something here; I can see myself having to do all
the work on the server side. This would slow and costly.

The "customer class" is the first of 4 filters to be applied.


Any ideas..

Thanks Rich , Manchester , UK

.

Relevant Pages

  • Re: Lots of Bits
    ... and performance is perhaps increased for the database. ... purist might frown upon it for more theoretical purposes as well as the many ... > match customer filter values with campaign filter values. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Making a List from a worksheet database
    ... I would rather not use a filter. ... >>I have a worksheet which is a database of things people have ordered. ... >> Each Row has a customer number, date ordered, item number, item ... >> I'd like to have another worksheet for a year end type summary where I ...
    (microsoft.public.excel)
  • Enumerate uses and domains
    ... I am building a web page that will enable the customer to import users ... to his database. ... DirectorySearcher with filter of users to find the users? ... Prev by Date: ...
    (microsoft.public.windows.server.active_directory)
  • Dataview web part filtering on Friendly AUTH_USER server variable
    ... There is a field called Customer_ in the database. ... I am using the Data View Filter to limit the results based on Customer_ ... it is filtering on DOMANNAME\USERNAME instead of USERNAME ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Spreadsheet/VBA Project Consulting: 50% Discount or Even Free - Limited Time Only
    ... > UDQ Services has years of experience with MS Excel and VBA (Visual Basic ... > templates, spreadsheet applications, and database applications. ... > P001: Mortgage Transaction Spreadsheet Database ... Customer List Converted from Excel Table to Word ...
    (microsoft.public.excel.worksheet.functions)