filtering from multiple dropdownlists

I created a datagrid which populates data from sql server. There about
8 columns on the grid I need to be able to filter on. I did setup
several dropdownlists and was sucessfully able to filter based on and
"AND" crietia.

ex. CITY = "SSDF" AND STATE ="OK" AND PHONE = "325-695-9656" AND
.....etc etc ...

This part seems fine, but my users need to be able to filter somtimes
on AND and somtimes on OR, but it seems that I have to specify it one
way or the other.

Is there a way to collect the criteria and and pass it to the
datasource at runtime. or any other suggestions as to how I should go
about doing this.

Thanks

.

Relevant Pages

  • Re: filtering from multiple dropdownlists
    ... If the user filters, collect the ... filter and rerun the filter mechanism on the data source. ... but my users need to be able to filter somtimes ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • Re: Display if count = 5
    ... criteria line of the field that is being counted, ... And, if you count something in the design grid in a query, ... if you have designed a complicated filter. ...
    (microsoft.public.access.queries)
  • Re: SPGridView (mis)behavior...help!!!!
    ... on the first grid then it works. ... If i try to sort by using the dropdown (from the header ... SPGridView) on either of the other three grids, ... If I click to open the dropdown to sort or filter, ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: SQL renamed expression name not recognised in WHERE
    ... OP's original query and my nested table expression ... directive as a filter on a derived value only. ... The corrected version (which run equally well under SQL Server and Oracle ...
    (comp.sys.ibm.as400.misc)
  • Re: 2005 Log Reader
    ... I am thinking 'filter' too, ... Looking for a SQL Server replication book? ... execute 'sp_replcmds' on 'PASASERV\PASLIVE'.'. ... construct replicated command from LSN.'. ...
    (microsoft.public.sqlserver.replication)
Loading