Multiple Filter Application ADO 2.0

[Guest]

Hi All,

Does anyone know, besides building a concatenated string, how to apply
multiple filters on a datatable? For example, if I have 4 comboboxes with
prefilled values, depending whether a combobox has a chosen value or not,
apply 1 or many (N) filters on a datatable as the user chooses them.

Regards,

Giovanni

 

[Cowboy \(Gregory A. Beamer\)]

You can fire XML at the database and use the XML features (SQL 2000 or
higher). Concatenating is your other option. You can also put the values
into a temp table, but you still have to parse, so it only buys you being
able to precompile more of the sproc. Since statistics will catch certain
things, it may or may not buy you a lot.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***********************************************
Think Outside the Box!
***********************************************