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 ...