Dynamic dataset filter

microsoft.public.dotnet.framework.adonet

25 Apr 2006 11:53 AM

rpoole

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