Hi,
I am new to this form. please can some body help me on this.
I have one grid (GRID 1) as shown below which a datasetbinded to winUltraGrid version 3.2. I need to group the column "Advisor" and obtain the same result and bind the result to another grid(GRID 2) to one of the column "Advisor". Please tell me how can i obtain the result set of Group by columns and bind it to a single column. It is urgent please..
GRID 1:-
GRID 2:-
Advisor D1 Quantity D2 Quantity Variance + AXA Rosenberg Investment Mgmt LLc (3 items) 400 400 0 + Blue Chip Mgmt LLc (3 items) 250 600 2
Thanks
Shashi
Hi Shashi,
The grid doesn't have any built-in functionality to do this. You can use OutlookGroupBy to group the rows in the grid. But that has no effect on the underlying data source. There's no table that exists in the grid that you could then bind to another grid. What you would have to do is examine the individual rows under the GroupByRow and create a data source that contained the data for the second grid.
Mike,
Thanks for the advice. I currently using the OutlookGroupBy feature to group by column and I can traverse through the groupby rows and then use
"isgroupbyrow" or use "Isgroupbycolumn" property.But I am unable to collect those rows collection with "+" expand indicator.
Please can you give some sample code where i can get the rows collection which is grouped by column and create a datasource.
Thanks,
To get the children of a GroupByRow, cast the row into a GroupByRow and use the ChildRows property.
But please can you tell me how to bind those rows to the gird with Expansion Indicator and same apperance as that of Outlook groupby.
If some sample example is provided it would be helpful.
Regards,
I'm afraid I do not understand your question.
m2shash said:please can you tell me how to bind those rows
Which rows? The child rows of a particular GroupBy Row? You can't bind the child rows directly. The grid does not expose any table that contains just the rows in an island. You would have to copy the data from those rows into some sort of data source, like a DataTable or UltraDataSource and bind the grid to that.