Hi Mike,

First off, thanks for answering.

1) What I do after a task is added to an Employee is:

            1: this.ultraGrid1.DataSource = Employees;

            2: this.ultraGrid1.Rows.Refresh(Infragistics.Win.UltraWinGrid.RefreshRow.ReloadData, true);
            3: this.ultraGrid1.Rows.ExpandAll(true);
            4: this.ultraGrid1.ActiveRow = this.ultraGridPrescribed.Rows.First();

InitializeLayout eventhandler is called after codeline 1 and 4. There (in the InitializeLayout event handler) I go in the foreach loop through each band and column to call PerformAutoResize like you can see in the code sample from my 1st post. So... What am I doing wrong according to you? I don't understand.

2) I couldn't find the ColSizing property, but I did find the AllowColSizing property in the Override property of the Band. So I set AllowColSizing property to Free on the bands Employees and Tasks. And I also set ColumnAutoSizeMode to AllRowsInBand at both bands. Didn't work.

3) Is it perhaps a problem that the Employees band uses Row Layout for the column arrangement and Tasks band uses Groups and Levels?

DannyvdK said:

1) What I do after a task is added to an Employee is:

            1: this.ultraGrid1.DataSource = Employees;

            2: this.ultraGrid1.Rows.Refresh(Infragistics.Win.UltraWinGrid.RefreshRow.ReloadData, true);
            3: this.ultraGrid1.Rows.ExpandAll(true);
            4: this.ultraGrid1.ActiveRow = this.ultraGridPrescribed.Rows.First();

InitializeLayout eventhandler is called after codeline 1 and 4. There (in the InitializeLayout event handler) I go in the foreach loop through each band and column to call PerformAutoResize like you can see in the code sample from my 1st post. So... What am I doing wrong according to you? I don't understand.

The InitializeLayout event will fire after step 1 here, setting the DataSource of the grid. But it will not fire after step 4, or any of the other steps you listed here. If it's firing again, then something else is going on.

Anyway, in your initial post you said that the grid has no child rows at first. So there's nothing to size in the second band. Did I misunderstand?

DannyvdK said:

2) I couldn't find the ColSizing property, but I did find the AllowColSizing property in the Override property of the Band. So I set AllowColSizing property to Free on the bands Employees and Tasks. And I also set ColumnAutoSizeMode to AllRowsInBand at both bands. Didn't work.

Yes, AllowColSizing is the correct property. Sorry for the confusion. :)

DannyvdK said:

3) Is it perhaps a problem that the Employees band uses Row Layout for the column arrangement and Tasks band uses Groups and Levels?

Employees is the second band? I guess that might be related, but the PerformAutoResize method should still work, assuming you call that method after the data in the Employees band has been added to the grid.

Perhaps you could post a small sample project demonstrating the behavior you are getting? If I could see a sample, I could debug it and tell you exactly why it's not working.

Hey Mike,

Sorry, busy busy busy...

Finally got around to making a small sample project (see attached ZIP file)

1) start up project.

  - Notice that the info in both grids are sized properly

  - As an extra problem, also notice that a + sign is displayed in front of the employees in the right grid while not actually having tasks in the collection. But this is a different problem. I worked around this in the real application by expanding and collasping all.

2) Select 'Task 1 blablabla..." in the left grid. Select an employee (for example "Peter") in the right grid.

3) Click on "Add Task"

  - Notice how the added task is not resized at all.

Why?

Hi,

DannyvdK said:

As an extra problem, also notice that a + sign is displayed in front of the employees in the right grid while not actually having tasks in the collection. But this is a different problem. I worked around this in the real application by expanding and collasping all.

That sounds like a very inefficient solution. All you have to do to fix this is set:

ultraGrid2.DisplayLayout.Override.ExpansionIndicator = Infragistics.Win.UltraWinGrid.ShowExpansionIndicator.CheckOnDisplay;

DannyvdK said:

3) Click on "Add Task"

  - Notice how the added task is not resized at all.

Unless I a missing something, there's no real mystery here. This is exactly what I explained above - PerformAutoResize is a method, not a property. The grid doesn't continuously resize every new or modified row and keep them autosized. And there is nothing in your code that is telling the grid to auto-size the cells in this new row.

The only place you are calling PerformAutoResize is in the InitializeLayout event and that doesn't get called with you add a new task because you have no done anything that would require re-initializing the Layout.

You are setting the DataSource on each grid and also refreshing the rows, but this is essentially a no-op in this sample, because you are setting the DataSource to the same value it's already set to.

It has nothing to do with your issue, but re-setting the DataSource is not a good practice, anyway. This is going to cause you to lose the column width, positions, selection, and any other user-customizations made to the grid.

Anyway, if you want to autosize when you add a task, why not just call the PerformAutoResize method at the end of the add task method?

As for the ExpansionIndicator. Thanks. Didn't know about that property. Works.

As for the PerformAutoResize problem. I know it's a method and not a property. My InitializeLayout in my real application is called each time I add or remove stuff. I don't know why exactly. So there must be a difference with my sample project. Need to find that difference. Didn't test it in the sample project. But indeed in the sample project my initialize layout is only called once. Like you said.

But calling PerformAutoResize after adding a task is an option for me in the real application also, so I' ll do that. So to test it I've added a PerformAutoResizeColumns at the very end of the routine add task routine in the sample project. So now the routine looks like:

       private void buttonAddTask_Click(object sender, EventArgs e) {

            Task tsk = (Task)ultraGrid1.ActiveRow.ListObject;

            Employee emp = (Employee)ultraGrid2.ActiveRow.ListObject;

            if (emp.Tasks == null) {
                emp.Tasks = new BindingList<Task>();
            }

            emp.Tasks.Add(tsk);

            ultraGrid1.DataSource = DummyRepository.Tasks;
            ultraGrid1.Rows.Refresh(Infragistics.Win.UltraWinGrid.RefreshRow.ReloadData, true);
            ultraGrid2.DataSource = DummyRepository.Employees;
            ultraGrid2.Rows.Refresh(Infragistics.Win.UltraWinGrid.RefreshRow.ReloadData, true);
            ultraGrid2.Rows.ExpandAll(true);
            ultraGrid2.DisplayLayout.PerformAutoResizeColumns(false, Infragistics.Win.UltraWinGrid.PerformAutoSizeType.VisibleRows);
        }

Please adjust the sample project accordingly. Notice the 1st time you add a task, the columns of the added task don't get resized. The 2nd task you add does. So we' re a little bit further, but how come this happens?

Last, but not least. I don't want to necessarily reset the DataSource, but I'm struggling to get the grids to do exactly what I want. This is what I've come up with so far. So if you can help me, please do. Adjust my sample project the way you think it should work. I could use a little help...

On one of post it mentined like this :The best thing to do is to leave on the AutoSize property or auto-size the columns in the export layout to ensure that the data will fit in the report.

So how to do autosize column ? is it same like this ?

ugrdExporter.AutoSize = Infragistics.Win.UltraWinGrid.DocumentExport.AutoSize.SizeColumnsToContent

I am using 13.1.20131.2060 version.

Hi,

I'm not sure if BeginExport is any better. That event is obsolete, so you might try ExportStarting, but event that might be too late. The best thing to do is to set the property before you call the Export method. I typically set it at design-time.

If that still doesn't work, then my best guess is that there is something about your data or your grid settings which is causing the autosizing to fail. What version of the controls are you using?

If you can post a small sample project demonstrating the problem, we would be happy to check it out.

Thanks for quick reply, So now I am doing like this still it's not working.

Private Sub ugrdExporter_BeginExport(sender As Object, e As Infragistics.Win.UltraWinGrid.DocumentExport.BeginExportEventArgs) Handles ugrdExporter.BeginExport

ugrdExporter.AutoSize = Infragistics.Win.UltraWinGrid.DocumentExport.AutoSize.SizeColumnsAndRowsToContent

End Sub

The AutoSize property on the exporter needs to be set before the export operation begins. You can't set it in these events - it's too late by then.