Hi Mike, I'm the same user how create this post, but i just bought the new Ultimate version 18.2 and create this new account for that keys.

Your example was the best solution, really thanks you, this is how see now:

If some in the forum need some solution I will love to share the code, just ask.

In this moment I have a couple of questions, in your example you use a UltraDataSource to populate the grid, my tree will have a dynamic structure and its populate from a SQL database and I have the following columns:

• ID - A unique integer number
• Name - The text to display in the cell
• ForeColor - A string with the HTML Color for the font
• BakColor - A string with the HMTL Color for the background
• ID_Related - A integer that who tell me who is the parent 

This is the first time than I use the UltraDataSource and my questions are:

• How to dynamically create the child bands for the grid in the UltraDataSource
• how to access those bands to give them value

I will appreciate your help.

Best regards,

Alejandro Castrejon

To answer your question, populating the UltraDataSource manually would look something like this: 

            var rootBand = this.ultraDataSource1.Band;
            rootBand.Key = "Root Band";
            rootBand.Columns.Add("Id", typeof(int));
            rootBand.Columns.Add("Name", typeof(string));
            rootBand.Columns.Add("BackColor", typeof(Color));

            var childBand = rootBand.ChildBands.Add("Child Band");
            childBand.Columns.Add("Id", typeof(int));
            childBand.Columns.Add("Name", typeof(string));
            childBand.Columns.Add("BackColor", typeof(Color));

            for (int i = 0; i < 3; i++)
            {
                var parentRow = this.ultraDataSource1.Rows.Add(new object[] { i, "Name" + i.ToString(), Color.Blue} );

                for (int j = 0; j < 3; j++)
                {
                    var childrow = parentRow.GetChildRows("Child Band").Add(new object[] { j, "Name" + j.ToString(), Color.Red });

                }
            }

            this.ultraGrid1.SetDataBinding(this.ultraDataSource1, "Root Band");

Hi Alejandro, 

If you are binding the grid to a hierarchical data source that's coming from SQL, then you would probably be better off off using a DataSet rather than UltraDataSource. The DotNet framework has classes to populate a DataSet from SQl using the DataAdapter class. 

UltraDataSource is really for when you want to create the structure and populate all of the data up-front manually. You could get your SQL data and copy it into an UltraDataSource, of course. That might be useful in some cases, since UltraDataSource is a bit more efficient when it comes to getting the child rows. But that's a trade-off in both getting all of the data up-front and also making it more difficult to update the back-end.