I find when I query for the groups (which the user set up using the grouping box, the grid indicates there aren't any groups.  I tried something like

      grdServer.DisplayLayout.Bands(0).Groups  (and there weren't any Groups defined)

I believe I was using the Groups property on the band to get this.  The only way I could even discover anything about the user defined group was by querying the each Column by using the following code:

       grdServer.DisplayLayout.Bands(0).Columns(index).IsGroupByColumn

I didn't see any means to get the opened/closed state of the group.  How can I do that.

(My grid is getting loaded with data from a single table into Band(0)).

Thanks,

Andy

The Groups property on the band refers to groups of columns. OutlookGroupBy, which groups the rows, is completely different and unrelated to that.

The Groups you are talking about here are rows - or, more specifically, GroupByRows.

So if you want to loop through the groups and determine which are expanded, you would loop through the grid.Rows collection and examine the Expanded property on the grid. You may also want to cast the UltraGridRow into an UltraGridGroupByRow so that you can access the row's Value and/or column for information on the grouping.

My guess is that the active GroupByRow is not highlighted at all. But when you click on the row, it's getting selected and that's the highlight you are seeing. So in addition to the setting the ActiveRow, you probably just need to set the Selected property on the row to true.

Thanks Mike I got it to work, so the open groups are opened (if they still exist) when the data is refreshed.

Now I am trying to set the active row, so that row is highlighted.

It works fine for a row that contains data, but it doesn't completely work for a header row.  The proper header row is set as active, but the row is not being highlighted by the grid.  (In the case of a data row, the active row is highlighted).

What do I have to do to get the active header row to be highlighted?

Well... presumably you need two pieces of information to identify the row. The first is the GroupByColumn that the row belongs to. The second is the Value of that row.

You can get both of these very easily. Cast the row into an UltraGridGroupByRow and then you can access the Value and Column property.

Thanks Mike.

I think I see how I can do this.  Only about 10% of the rows should be different with each refresh, so if I have a way to uniquely identify the row's group, I can save that it's state (expanded/closed).  Is there a good property to use to identify the row group?

It may work out to be easier and faster for me to add a second grid, so I can simply modify the data in my dataset and not ever change the data source, instead of resetting the data source each time.

Hi Andy,

If you are losing the groupings, then you are probably setting the grid's DataSource or calling the SetDataBinding method. So you are attaching to a new data source.

In such a case, keeping the same groups expanded is not really possible, because the groups are dependent on the data, and you are applying a new set of Data to the grid. The old data isn't there any more and there's new data in it's place and the grid has no way of associating the old data with the new data.

The only way this could work is for you to handle it yourself. That means looping through every row in the grid (recursively if there is more than one level of grouping) and then recording the expanded state of each GroupByRow, based on the Value. Then you would have to loop through every row again after you changed the data source and examine each row, see if a matching Value exists in the recorded information and expand that row, as needed.

If you are looking for a simpler solution, then I'm afraid there isn't one.