Hi Michael,

Thanks for your suggestion.

AddNew() method works on the Level 2 band but on the Level 3 band.

I found a workaround that if I show a message box just before calling the method SetCount(), it works.

So I think this is to do something with the focus/state of the ultra grid control.

I am assigning the data to the DataRow object in the InitializeDataRow() and setting the cell data in OnCellDataRequested event.

If this does not give a hint then I will post the same application.

As I mentioned that sample application works perfectly but the third level band is not visible in my work place without showing a message box.

Hi Michael,

Please take a look at this sample code. The application at my office follows a similar pattern.

Although the sample code works but not the one at my office.

using Infragistics.Win.UltraWinDataSource;
using System.Collections.Generic;
using System.Windows.Forms;

namespace WindowsFormsApp1
{
    public partial class Form1 : Form
    {
        UltraDataSource DataSource = new UltraDataSource();
        List<DataClass> _dataClasses = new List<DataClass>();

        public Form1()
        {
            InitializeComponent();
            GetDataSource();
            LoadData();
            ultraGrid1.DataSource = DataSource;
        }

        private void GetDataSource()
        {
            var ds = new UltraDataSource(components);
            ds.Band.Key = "One";

            foreach(UltraDataColumn col in ultraDataSource1.GetBandByKey("One").Columns)
            {
                ds.Band.Columns.Add(col.Key, col.DataType);
            }

            UltraDataBand db2 = ds.Band.ChildBands.Add("Two");
            foreach (UltraDataColumn col in ultraDataSource1.GetBandByKey("Two").Columns)
            {
                db2.Columns.Add(col.Key, col.DataType);
            }

            UltraDataBand db3 = db2.ChildBands.Add("Three");
            foreach (UltraDataColumn col in ultraDataSource1.GetBandByKey("Three").Columns)
            {
                db3.Columns.Add(col.Key, col.DataType);
            }

            ds.InitializeDataRow += Ds_InitializeDataRow;
            ds.CellDataRequested += Ds_CellDataRequested;

            DataSource = ds;
        }

        private void LoadData()
        {
            var d1 = new DataClass("1", "2");
            var d2 = new DataClass("1", "2");
            var d3 = new DataClass("1", "2");

            _dataClasses.Add(d1);
            _dataClasses.Add(d2);
            _dataClasses.Add(d3);
            DataSource.Rows.SetCount(_dataClasses.Count);
        }

        private void UltraGrid1_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e)
        {
            AddInfoColum(0);
            AddInfoColum(1);
        }

        protected void AddInfoColum(int bandIndex)
        {
            
            var columnName = "Button";
            var infoColumn = ultraGrid1.DisplayLayout.Bands[bandIndex].Columns.Add(columnName);
            infoColumn.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.Button;
            infoColumn.Width = 5;
            infoColumn.Header.SetVisiblePosition(0, true);
            infoColumn.Key = "Info";
        }

        private void Ds_CellDataRequested(object sender, CellDataRequestedEventArgs e)
        {
            DataClass dc = (DataClass)e.Row.Tag;
            if(e.Column.Key == "Col1")
            {
                e.Data = dc.Col1;
            }
            if (e.Column.Key == "Col2")
            {
                e.Data = dc.Col2;
            }
            e.CacheData = false;
        }

        private void Ds_InitializeDataRow(object sender, InitializeDataRowEventArgs e)
        {
            var band = e.Row.Band;
            DataClass dataClass = _dataClasses[e.Row.Index];
            e.Row.Tag = dataClass;
        }

        private void UltraGrid1_ClickCellButton(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
        {
            var row = e.Cell.Row;
            var ultraDataRow = e.Cell.Row.ListObject as UltraDataRow;
            if(ultraDataRow != null && ultraDataRow.Band.Key == "One")
            {
                ultraDataRow.GetChildRows("Two").SetCount(_dataClasses.Count);
            }

            if (ultraDataRow != null && ultraDataRow.Band.Key == "Two")
            {
                // In the actual program the below statement would not show the band unless I show a Message box
                ultraDataRow.GetChildRows("Three").SetCount(_dataClasses.Count);
            }
            row.ExpandAll();
        }

        public class DataClass
        {
            public string Col1 { get; set; }
            public string Col2 { get; set; }

            public DataClass(string col1, string col2)
            {
                Col1 = col1;
                Col2 = col2;
            }
        }
    }
}

 The screen dump shows the Data source band hierarchy.

The workaround I am using now is like a hack, so I wanted to fix it in a proper manner.

Hello Phaniraj, 

Thank you for following up. The sample code above works? Which version of Infragistics is your application using?

Hi Michael,

Yes this code works perfectly fine.

At my office we use the version 2014.1 and it worked on my home laptop as well when I installed a trial version(most recent) last weekend.

Do you see any issues with the methodology?

If the issue is working with 18.1 but not in 14.1 that would mean something was either fixed or masking the issue. If you can upgrade to 18.1 that would be preferable. 2014.1 is no longer maintained and retired. 

Let me know if you have any questions. 

The sample application that I shared above works on 18.1 and 14.1 both perfectly.

But the level 3 band is not visible on the application at my work place.

I have spent lot of time on the code but could not figure out what the issues is.

The workaround to show a message box to make the band visible works for now, but is not an ideal solution.

I am guessing by making changes to the code, probably in an event would fix the issue, but I am not sure where.

This is most likely a problem with the data source. What kind of DataSource are you using? If it's something custom, then the implementation might be returning null for the child data in the first row and first child row, which means that the BindingManager will be unable to get the data structure from the data source for that level. 

If you are using an existing data source class, like a DataSet or UltraDataSource then that sort of thing shouldn't happen. 

Hi is there any further update on this?  I too am now seeing this behaviour, the third level band in my grid no longer displays.  This used to work so I have a suspicion that something has changed in the Infragistics code around this?  I am using v19.1.20191.150.

My grid is bound to a DataSource with 10 levels of bands, after assigned the DataSource to the grid and looking at the DisplayLayout.Bands collection I only see 2 bands.

Hello, 

This is most likely a timing issue because you are implementing load on demand with the UltraDataSource.

There are Windows Forms samples in our Samples Browser (an application you can optionally install) that will help guide you to using virtual mode properly using the UltraDataSource. Perhaps following how we do this might address the issues your application. 

All of our samples are installed and saved locally by default to Public Documents location on the C Drive:

==> C:\Users\Public\Documents\Infragistics\201x.x\Windows Forms\Samples

In addition, would it be possible for you to send your entire application (privately of course)? I can sign an NDA,etc. Our goal is to reproduce and isolate the behavior to identify the root cause before providing you with a viable solution. 

Let me know if you have any questions.