Is there virtual mode for the grid?
I mean, is it possible that the grid will load rows on user demand.
So not all the rows will be loaded at once, but only the rows that the user sees will be loaded.
In BindingSource there is a datasource property
so if you have DataTable dt, and BindingSource bs
you simply do Bs.DataSource = dt;
but wiith UltraDataSource if seems that you need to define the columns, and even the rows, one by one,
in runtime.
I'm not sure what you mean? Why do you need to define the define the data source at design-time? There's no limitation on the UltraDataSource that says you can't create bands and columns at run-time.
If I understand correctly, I cant use the standard microsoft BindingSource.
I have to use UltraDataSource .
And in UltraDataSource, I must define my data source in design time.
But first it is very clumsy to define it in design time, and also many time we dont know
the datasource in design time, and define it in runtime.
There's a property on the grid called LoadStyle (on the DisplayLayout).
However, this property will not do you much good unless your data source also supports loading data on-demand. The UltraDataSource component does this and there is a sample included with NetAdvantage which loads a million rows into the grid on-demand.