Intersoft Community - ISDataSource - Search problem with paging operation when using ISDataSource

Search problem with paging operation when using ISDataSource

gavin — Thu, 08 Sep 2011 23:04:05 GMT

ok,the example works perfectly.thank for your help

Search problem with paging operation when using ISDataSource

handy@intersoftpt.com — Thu, 08 Sep 2011 21:39:40 GMT

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

Search problem with paging operation when using ISDataSource

gavin — Thu, 08 Sep 2011 06:33:52 GMT

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.

Search problem with paging operation when using ISDataSource

handy@intersoftpt.com — Thu, 08 Sep 2011 04:45:54 GMT

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

Search problem with paging operation when using ISDataSource

gavin — Thu, 08 Sep 2011 00:08:01 GMT

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 !

Search problem with paging operation when using ISDataSource

handy@intersoftpt.com — Fri, 02 Sep 2011 05:34:28 GMT

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

Search problem with paging operation when using ISDataSource

gavin — Fri, 02 Sep 2011 02:49:38 GMT

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 !

Search problem with paging operation when using ISDataSource

handy@intersoftpt.com — Wed, 31 Aug 2011 21:55:12 GMT

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

Search problem with paging operation when using ISDataSource

gavin — Tue, 30 Aug 2011 10:48:31 GMT

Hi ,

I meet a problem of paging operation when I use ISDataSource . The data of webgrid is displayed through paging operation . When I want to search some information , I pass parameters with ControlParameter of ISDataSource . The data of first page is displayed normally , however , the data of second page is not sifted according to the parameters .

When I debug my code , I find the parameters I passed is normal when the data of first page is displayed . But the parameters I passed is null after I click the icon of next page in the footer of webgrid , and the data of webgrid is showed without sifting .

I want to know why . Anyone can help me ? Thanks a lot .