Posted on: 9/18/2013 6:13:56 PM | Views : 737

I am tryingn to a do a search from three possible buttons.  I have the gridview query set by using or's in between each criteria.  When I click on search the gridview does not dispaly to do a select.  Any ideas? Below is the code.  I did do a test query and it works from there, but not the actual page.
 
SELECT * FROM [Restitution_Master] WHERE (([CLIENT_ID] = @CLIENT_ID) OR ([CLIENT_LNAME] LIKE '%' + @CLIENT_LNAME + '%')  OR ([CLIENT_CASE] = @CLIENT_CASE))
...

Go to the complete details ...