iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Latest Development Blogs
Browse By Tag
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 .
ok,the example works perfectly.thank for your help
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.
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 !
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.
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 !
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.
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.
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.
Forgot your password | Sign up
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname
Already a member? Sign in