In the VB6 Ultragrid with SQL Server we used to make the SQL with a SHAPE. The first shape became band 0, and the next section of the sql became band 1 and so on.
It was like predefining the Column Header groups that people can now do by dragging the column to the top of the grid.
If I want to do this in the designer, how do I do that?
Hi,
If you want to display hierarchical data in the grid, there are two ways to do it. One is by taking a flat set of data and using OutlookGroupBy - that's what happens when you drag a column header into the GroupByBox. To do that programmatically, you use something like this:
grid.DisplayLayout.Bands[0].SortedColumns.Add(column, false, true)
The last "true" there indicates that the column should be grouped by, as well as sorted.
The other way is to supply an actual hierarchical data source, like a DataSet with tables and Relationships.