asp SqlDataSource Filter Expression; multiple Search Boxes

Question

I am trying to perform a single search on a single column of data in an asp:GridView, however I want multiple filter (search) boxes above each column so one could search within its own perspective column. What would clearly fix this theoretically is to have multiple FilterExpressions. I am using VB and am very new and easily misunderstood with VB, please bare with:

PS. I have gotten it to work no problem when only having ONE filter (search) box, this currently doesn't do anything

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="xxx" 
    ProviderName="xxxx" 
    SelectCommand="SELECT [ddiID], [volusionID], [Customer], [email], [Total], [SumOfTotal] FROM [BBnewsalesQry] ORDER BY [Customer]"
    FilterExpression="customer like '%{0}%' OR ddiID like '%{0}%'">
      <FilterParameters>
         <asp:ControlParameter Name="ddiID" ControlID="ddiIDSearch" PropertyName="Text" />
         <asp:ControlParameter Name="customer" ControlID="txtSearch" PropertyName="Text" />
      </FilterParameters>
</asp:SqlDataSource>
<div>
   <b>DDI Search:</b> <asp:TextBox ID="ddiIDSearch" runat="server" />
   <b>Customer Search:</b> <asp:TextBox ID="txtSearch" runat="server" />
   <asp:ImageButton ID="btnSearch" ImageUrl="http:xxx" runat="server" />
   <asp:ImageButton ID="btnClear" ImageUrl="http:xxx" runat="server" />
</div>

Then inside the GridView:

<asp:TemplateField HeaderText="ddiID" SortExpression="ddiID">
        <ItemStyle HorizontalAlign="Left" />
           <ItemTemplate>
              <asp:Label ID="lblddiid" Text='<%#HighlightText(Eval("ddiid")) %>' 
                        CssClass="TextField" runat="server" />
           </ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="volusionID" HeaderText="volusionID" ReadOnly="True" SortExpression="volusionID" />
<asp:TemplateField HeaderText="customer" SortExpression="customer">
         <ItemStyle HorizontalAlign="Left" />
           <ItemTemplate>
              <asp:Label ID="lblcustomer" Text='<%#HighlightText(Eval("customer")) %>' 
                        CssClass="TextField" runat="server" />
           </ItemTemplate>
</asp:TemplateField>

Mark Hall · Accepted Answer · 2012-01-20 23:50:25Z

7

you are referencing the same parameter twice - try the following:

FilterExpression="customer like '%{0}%' OR ddiID like '%{1}%'"

edited Jan 20, 2012 at 23:50

Mark Hall

54.7k9 gold badges101 silver badges116 bronze badges

answered Jan 20, 2012 at 23:45

steve

861 silver badge2 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Davide Caruso Davide986 · Accepted Answer · 2015-02-05 11:38:25Z

0

I have resolved the problem of create two or more "Like clause" in the "Where" statement using:

Where CHARINDEX(@Par1, Col1)<>0) and ...

answered Feb 5, 2015 at 11:38

Davide Caruso Davide986

1

Collectives™ on Stack Overflow

asp SqlDataSource Filter Expression; multiple Search Boxes

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related