I am evaluating infragistics for one of the projects we are developing and run into this specific issue, I need advise if I am doing something wrong
I have attached an objectdatasource to webhierarchicaldatasource, enabled paging behaviour with inheritance set to true, objectdatasource paging enabled, getcount and getters with paging parameters are set for the objectdatasource, but when I debug the asp application, my objectdatasource is always called with pageindex and recordtofetch parameters as zero. On the same page I have WebDataGrid control using the same objectdatasource, and paging works just find.
Do you have any idea what I may be doing wrong?
It is not an option to fetch the whole data to the client to display as the data is huge (more than 4K records matching the criteria), so I definitely need paging.
May be it is better to restate my problem:
I am using objectdatasource objects attached to webhierarchicaldatasource(WHDS), and WHDS is attached to webhierarchicaldatagrid(WHDG). When the page loads, grid is fetching all records from the tables through objectdatasource, whatever the page index the user selects, methods in objectdatasource are called by pageindex and rowcounts with zeros. GetCount method on objectdatasource is not called also. (Paging is enabled and setup properly in objectdatasources, as paging works fine if I use the same objectdatasources to WebDataGrid).
So can a developer or support personal confirm that paging on the server side is not supported on WHDG through objectdatasources?
Or does anyone have a sample application using objectdatasources for hierachical data grid with paging? (paging on server side, I don't want to fetch all records to client as it take more than a minute on local area connection)
Can a developer confirm that it is not possible to enable paging on the server side with hierarchical data source?
Hi,
The paging functionality of the hierarchical grid should work. However the hierarchical data source control requests all the data from ObjectDataSource and paging is performed after that (again on the server side).
Thanks for the reply.
I am looking for a solution that fetches only required records from the database while paging (table may contain more than 1000 records), and I need to use an objectdatasource (that can provide totalcount, pageindex parametered methods to fetch required data), I assume all the records are fetched than?
Thanks in advance
Hello,
I am also getting the same issue. Did you got any idea/solution for this issue? please help me!!!!
How we can set that page count manually, becuse now WHDG(even include ChildGrid also) while loading datasoucre based on the total records having only the page count will set, normally the "Behaviors.Paging.PageCount(its read only property)".
Its possible for manual page count assign like "UltraWebGrid" cotrol?
Thanks for appreciate any one help!!!--Raja S.
Where you able to solve this? I'm having the same issue. I cannot modify the page count of the WHDG if not all data is returned.
Thanks.
This is not possible in WHDG. I have raised this issue into support team. they promised in future release, but still not yet get any response.
Try Some Possible Way:
1. Use normal paging nation like our "Gridview"2. Before assign dataSet/DataTable in WHDG, Store in your records result from "Viewstate". 3. Assign each page post back (IsPostBack = true) in this 'viewstate" in your WHDG (If you used multiple level, you should assign multiple level)Ex Code:
foreach (ContainerGridRecord row in this.whdgPreceptor.GridView.Rows) { if (row.RowIslands.Count > 0) { if (((ContainerGrid)row.RowIslands[0]).Key == "M_MAIN") { string secondLevelKey = string.Empty; if (row.DataKey[0] !=null) secondLevelKey = row.DataKey[0].ToString().Trim(); if (row.DataKey[1] != null) secondLevelKey = secondLevelKey + "_" + row.DataKey[1].ToString().Trim(); if (ViewState["FilesForMonth_" + secondLevelKey] != null) { DataSet ds = (DataSet)ViewState["FilesForMonth_" + secondLevelKey]; ((ContainerGrid)row.RowIslands[0]).DataSource = ds; ((ContainerGrid)row.RowIslands[0]).DataBind(); } } } else { row.Expanded = false; }
All the Best !!!
Regards,Rajalingam