Hi,

I have a gridview, and I have a search textbox and button which sets the filter on the SqlDataSource that the gridview uses.

It all works fine, until you try to Edit (i'm assuming that Delete and Update wont work either while its filtered) a record while it is filtered.

Has anyone else faced this problem?

Thanks,
Mikey

Ok i found a solution for this.

Basically you need to reset the filter on page load.

What i did is i added a hidden text box that holds the SqlDataSource1.FilterExpression value. And on page load if its a postback, i just re apply it...

SqlDataSource1.FilterExpression = txtFilter.Text;

and viola! fixes the edit and also the paging problem (caused by the same thing).

found the solution here:

http://groups.google.com/group/micro...3418e5c544a959

Peace,
Mikey