Changing the MaxBandDepth after a Grid is bound

State See Verified Answer
Replies 4 replies
Subscribers 7 subscribers
Views 1501099 views
Users 0 members are here

UltraGrid

9364

Vern posted over 10 years ago

I have a Grid which is bound to a DataTable. Grid is intentionally bound to this datasource such (using self-referencing relationship) that it rows in this table are shown in bands on the Grid. Rows are dynamically added to this DataTable which may show in a new band. So we do not know the number of bands needed ahead of time. If we leave the MaxBandDepth as default, it takes very long for the databinding to happen. So we have set it to an arbitrary small number.

My plan was to change to the MaxBandDepth only if I have a need to show a new band i.e. when new DataRows get added to the DataTable. I tried doing in some code that is comes after InitializeLayout. But the Grid does not seem to recognize change in MaxBandDepth if done after InitializeLayout. What are my options?

- ResetDisplayLayout? and then rerun InitializeLayout?

- Any other way to force set MaxBandDepth?

4625

Offline Ivaylo Petrov posted over 10 years ago in reply to Vern

Hello Vern,

I am glad that my solution is working as per your requirement.

Please feel free to contact us if you have any questions related to our products.

Thank you for using Infragistics Components!
Cancel
Reply

Cancel
9364

Vern posted over 10 years ago in reply to Ivaylo Petrov

My colleague tried the suggested solution of rebinding and that worked great. Thanks Ivaylo!
Cancel
Reply

Cancel
4625

Offline Ivaylo Petrov posted over 10 years ago

Hello Vern,

I am checking about the progress of this issue. Please let me know if you need any further assistance on it or I am missing something. Thank you for using Infragistics Components!
Cancel
Reply

Cancel
4625

Verified Answer
Offline Ivaylo Petrov posted over 10 years ago

Hello Vern,

Thank you for posting in our forums!

You must set the MaxBandDepth property before binding the UltraGrid to a data source in order for this property to have any effect. Therefore appropriate way of refreshing the UltraGrid`s layout is by setting the data binding explicitly ( ultraGrid1.SetDataBinding(this.ultraGrid1.DataSource, String.Empty ), in order to apply the value of the MaxBandDepth property.

For further reference, see the following documentation page:
http://help.infragistics.com/doc/WinForms/2014.1/CLR4.0/?page=Infragistics4.Win.UltraWinGrid.v14.1~Infragistics.Win.UltraWinGrid.UltraGridLayout~MaxBandDepth.html

Another approach that may fit your requirement is to use the UltraDataSource component, that gives you the opportunity to load UltraGrid`s data on demand.

For further reference, see the following documentation page:
http://help.infragistics.com/doc/WinForms/2014.1/CLR4.0/?page=WinDataSource_Load_Data_on_Demand.html

Also see the attached sample project on the bottom of my post. Please feel free to modify and attached it to your next post, if I am missing something.

I am waiting for your feedback.

UltraGridMaxBands.zip
Cancel
Reply

Reject Answer

Cancel