Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
270
WinGrid loading data on Demand from a dataset
posted

Hey folks,

 

my task is to program a wingrid application with a given datasource (preferred by data-adapter which I fill during runtime). The problem is the performance!

So I want to avoid long load durations for the whole data I request. I have already looked at the samples and browsed around the forum, but in the samples collection there is just a sample with non-database bounded data.

 

e.g. my dataset would be filled with 1.000.000+ records at once....this would need time and performance. But can I keep my sql-statement and fire it up in such way that the datasource or the grid or anything else just get the data on demand?

 

(One more thing is that the data-collection can contain of multiple relations leaded into bands)

 

I hope somebody can help me

Thanks in advance

Parents
No Data
Reply
  • 560
    posted

    Hi,

    this is no big task: just use the UltraDataSource as your DataSource. This has an event associated which is fired on fetching the cell values. You can then use this for fetching the data from a different local DataTable. If the DataTable is running out of rows you can load the next block of rows from your database.

    Some hint: I'm using an open database cursor on the sql side to avoid row anomalies within the result set. This means when someone is inserting/deleting rows while an other user uses your overview grid.

     

    I hope this helps (it was short I know),

    Frank

     

Children