Mike,

As many people ask the same question over and over again, why don't you just give us a complete sample? Here is the common scenario:

* I have a SQL Server database and Orders table has three columns (ID, orderDate, orderAmont)

* I have setup a connection and a SqlCommand and I want to read it with SqlDataReader - say "Select * from Orders"

Could you please share a sample to get the data and bind to a WinGrid using LoadOnDemand?

Thank you

Hi Frank,

You set up the bands and columns of the UltraDataSource to mirror your DataTable and display what you want in the grid. Then you bind the grid to the UltraDataSource, just like the sample is doing. Then you set the Count of the grid rows to the count of the rows in your data table, just like the sample is doing. Then you handle the events of the UltraDataSource such as CellDataRequested, just as the sample is doing.

Hi Mike

Thats what I am trying to ask ...

I have a UltraDataSource, a UltraGrid, a DataTable with data.
What do I have to set to fill the Grid using the DataSource ??

Best regards
Frank Uray

Hi Frank,

I'm confused by your confusion. :)  What part of this is confusing you?

The way the million rows sample works is that there's a grid and an UltraDataSource. The UDS has it's data structure set up with columns and it fires events like CellDataRequested when it need the data for a row.The code handles this event and passes back the data to be displayed for that row.The same just uses fake data that is generated in the code. But in your case, you would use the data from your DataTable.

Hi Mike

Thanks for your answer,
but now I am really confused ... :-))

What do I have to do when I have a DataTable with all the
Data in it ? I would like to display this data like it is
in this One million row sample .

Thanks and best regards
Frank Uray