The situation is the wingrid has so many rows, about 1500 rows. I think it's not convinent for users. So I want to make the wingrid display in several pages, but I can't find some properties to do this thing.
Do I need to write code to so or I didn't find the property for paging display ?
Thank you!
WinGrid does not have any paging support.
It does support loading data on-demand using the UltraDataSource component. Check out the sample included with NetAdvantage - there's a sampleof displaying a million rows in a grid using this technique. I beleive the sample exists both in the WinGrid Samples Explorer and also as a separate sample under UltraDataSource.
OK... I saw the sample, it was very impressive.
But, I have not much idea how I can implement it with vb.net.
Where can I find the sample codes of it?
Thank you.
I found and saw the sample code, however, it did not help me much to do my task.
I have a dataset which have one datatable with lots and lots of datarows. (And it keeps increasing)
Dim dt as datatable = ds.Tables(0)
Instead of connecting this datatable directly to ultraGrid1 like
ultraGrid1.DataSource = dt
I'd like first put all those dataRows into UltraDataSource1, then I'd like to connect these two like
ultraGrid1.DataSource = UltraDataSource1
My question is how can I put all those datarows into UltraDataSource1?
Hi,
Copying all of the rows into an UltraDataSource would not help you with any sort of paging or loading on demand. This would be less efficient than just binding the grid to the data source.
The LoadOnDemand functionality uses the UltraDataSource as an intermediary between the grid and the "real" data source. What you do is handle events on the UltraDataSource that request data and populate the UltraDataSource cells on the fly as data is requested.
The Million Rows Sample demonstrates this by just using numeric values in place of a real data source.
OK... I've got it worked. Now when I scroll down the UltraGrid, every 1000 rows it triggers go to DB and
get another new 1000 rows.
Now, I'd like make the UltraGrid scrollable to anywhere in the grid without that triggering.
The triggering happens only when I am done with scrolling.
Is there any way to override UltraDataSource_CellDataRequested while scrolling and make it is called only when I release the scroll bar?
I switched between Deffered and Immediate of Scroll Style of UltraGrid, however, both of them triggered the UltraDataSource_CellDataRequested while scrolling.
I need to do this and am very new to infragistics.
can you post some code sample. I have a grid with 2 bands (parent/child)
I am using a bindinglist and not a datasource for my grid
Thanks
I'm not sure what you are asking. The only samples available are the ones that install with the product. There may be additional samples in the Infragistics Knowledge Base.