Multiple FilterParameters in GridView

D

David

Using VS2005 and SQL2005.
Is there any way to handle multiple FilterParameters or ControlParameters in
SQLDataSource on a GridView? I have 4 asp:textbox fields that can have any
combination of conditions, but if empty I want to ignore them. I know how
to do it in SQL code but want to eliminate that if I can do it with
parameters in SQLDataSource control. I am using just 1 now (see below) and
it works great. Thanks.

David
FilterExpression="FileName Like '%{0}%'">

<FilterParameters>

<asp:ControlParameter Name="FileName" ControlId="txtFindName"
PropertyName="Text"/>

</FilterParameters>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,995
Messages
2,570,230
Members
46,818
Latest member
Brigette36

Latest Threads

Top