Forums Ultimate UI for Windows Forms
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
Close
Wai Khuen
20
Load summary dataset and actual seperately
posted

Hi,

We've a requirement to retrieve huge dataset and populate into ultrawingrid.

It'll first load a summary dataset and display it in ultrawingrid in a group by state. When user click on "expand row", it'll go back to the database to fetch the underlying data for that summary row.

Purpose of doing that is, of course performance, since we don't want to fetch a large dataset from the server.

How can it this be implemented?

Thanks in advance.

Parents
No Data
Reply
  • 12333
    posted

    Hi,

    One technique you can use is to create a representation of your data model using the UltraDataSource (also known as WinDataSource).

     

    WinDataSource is a component that allows you to define a schema that represents your data model so that you can bind it to WinGrid and then programmatically interact with the WinDataSource API to achieve a load-on-demand functionality in your app.

    Here is the documentation for WinDataSource:

    http://help.infragistics.com/NetAdvantage/WinForms/2010.3/CLR2.0/?page=WinDataSource.html

     

    Another valuable resource that shows how to work with WinDataSource and WinGrid is the following sample. Please download the Windows Forms samples from your login account (directions here) and check out the following sample when you run the Sample Browser:

    The approach you can take is:

    • Create a schema in UltraDataSource to represent 2 levels:
      • Level [0] is your summary entity
      • Level [1] is your detail entity for each summary
    • Handle the CellDataRequested event so that when child records are requested, you can fetch them from the back end.
Children
No Data