Search Criteria in gridview

[Seok Bee]

Dear Experts,

I would like to have a listing of my current table records based on certain
search criterias to list out in the gridview control.

However, I have tried to use the built-in filtering function from the
datasource. It is not exactly what I wanted. I have more than 1 search
criterias and want to have the filtering based on the condition I set through
the controls in the form. This may be a combination of 1 search condition or
more. I would like to know whehter the gridview control or datasource control
able me to set the search condition dynamically based on the only the
conditions I set in the form controls. Example of the search criterias that I
have in the form are:
- Date Range: From date and time (Textbox control) , To date and time
(Textbox)
- Status : Dropdownlist control
- Department : dropdownlist control
Please advise.

Many thanks in advance.

Regards,
SB