Hello,

Please find attached sample. It should guide you how to select by using parameter. You can also shifting the parameter and rebind it to WebGrid.

Note: To run the sample, please use Northwind database.

Regards,
Handy

Hello Handy ,

  Thank you for your samples and help . However , it seems that there is not any samples about paging operation in the attachment file .

   My issue is about displaying the data of webgrid after paging operation , especially executing search operation  . After clicking the search button , the data of the first page is showed normal , because the data of webgrid is sifted according to the querying condition you provided . But after clicking the icon of next page in the footer of webgrid , the data of webgrid is displayed without sifted .

  Can you help me to solve this issue ? Thank you very much !

Hello,

Can you provides more details such as a simple runable sample for your issue? We need it to investigate your issue. Do you mean that in the next page, the data still showed the same data as page 1? How about page 3? If it only happens for page 2, try to set  PagingDataRetrievalMode="ReturnPartialRows".
This issue usually hapen when implement custom paging.

Regards,
Handy

Hello Handy ,

    Thank you for your help . However , the method you provided can not work . So I make a simple runable sample . In this sample , when I click the Search button , the data of first page is normal . But after I click the icon of next page , I click the icon of previous page , then I find the data of first page is unormal . The data is not sifted .

   Can you help me to solve this problem ? Thank you very much !

Hello,

It is not shifted because there is no select parameter method in there. You did use parameter, but there is no specific method to handle the parameter.
In your sample, the parameter is correctly sent. But even though the parameter is correct, there is no operation to filter the parameter at all at back end. Perhaps, in your Select logic, you need to add your filter expression or query.

Example:  

 DataView view = new DataView(table);
 view.RowFilter = "VisitDisplayName = " + "'moduleName'";

 In this way, you won't need to call any code in button click, because everything would be handled by select method in ISDataSource.

Regards,
Handy

Hi:

         Im so sorry. You misunderstood what I meant.  In my opinion ,I have used  the parameter.

         I use  Fuzzy query. Picture1 is my Initial Table.When I search "ans",press Search button .Please look at picture2,VisitDisplayName must have the text of "ans" in the row,that is right. then I turn to the next page, please look at the picture 3,Attention to the lower right corner of the picture 3 , this is the page 2 .  When I turn back to  the page1. It is not the page1 before ,row of VisitDisplayName have the text of "an",this is my  really  problem.
 

Hi,

I knew the problem. As I told you before, your filter and select parameter is not correct. Have you tested by using my suggestion code? I already tested it before send it to you. It works perfectly. 

Regards,
Handy

ok,the example works perfectly.thank for your help