Posted on: 4/3/2015 10:03:42 PM | Views : 647

I am working on gridview and searching records from it using one dropdown list and one textbox. User select category from dropdown list and than type a keyword(S) to get desired search result. but the problem i am facing here is. I have one record with has category id=10 and another record witch has category id=1 when i select a category from dropdown list which has id =10 a record belongs to category id=1 also appears on filtered result. i have no idea why this is happing. 
here are some error pictures




Does this line has effect on search result? 
([cat_id] like Replace( @cat_id,0,'%'))) because it was ...

Go to the complete details ...