Conditional Query On ASPNET Page

Dear Friends,


I am working on search customer information page.

I have 5 search options,

Name,
Email,
Order Number,
Product Name,
Order Date


I am using check boxes, I need to allow admin to enter above information and click on search,

How will I make my query and sends to DB server to pull up records which satisfies where clause:

For example,

Select * from orders where Email = #Email#

This is simple, but I can not hardcode all queries, I don€™t know in advance what different search option ADMIN may choose.

Any suggestion for logic or query make up,

Thanks,

Fahim.