Filterexpression

[MaddogC]

I have a gridview that is bound to an objectdatasource. I want to add a search box and button to my page. I have threfore added a filterexpression to the gridview. Firstly the Like statement in my filterexpression does not appear to be working. Secondly, how do I get the search button to refresh for a new search?


filterexpression="ORG_NAME LIKE '{0}'"
>
<filterparameters>
<asp:ControlParameter ControlID="txtSearch" PropertyName="Text" />

</filterparameters>

 

[ca8msm]

I imagine (as I prefer to hand-code database activity rather than use the built-in methods like the SqlDataSource) that you'll have to use something like:

                 ...
                 FilterExpression="ORG_NAME='{0}'">
                <FilterParameters>
                    <asp:ControlParameter Name="ORG_NAME" ControlId="txtSearch" PropertyName="Text"/>
                </FilterParameters>
                ...

Try using the above and see if it works. If it does, then it's the way you've set up the LIKE statement within the FilterExpression.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[MaddogC]

I've tried this already. It works fine with "=", can't see a problem with the LIKE though??

 

[ca8msm]

Maybe it's the object that is in your ObjectDataSource that can't handle LIKE statements, as the example in the help files works fine for me:

http://msdn2.microsoft.com/en-US/library/ms227680.aspx

____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[MaddogC]

The LIKE is working as long as I put the full string in. For example if I was searching by city and put in LONDON it works, however 'LON' in the search string returns nothing??