OK. I need some help. I am trying to set up a grid that looks something like this:
In the InitializeLayout event I have code to set up the columns based on my Typed Dataset:
private void gridVDCF_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e)
{
UltraGridBand band = e.Layout.Bands[0];
int headerPosition = 0;
band.Columns[WorkViewAccountsConstants.COL_DAY].Header.Caption = "";
band.Columns[WorkViewAccountsConstants.COL_DAY].Width = 75;
band.Columns[WorkViewAccountsConstants.COL_DAY].Header.VisiblePosition = headerPosition++;
band.Columns[WorkViewAccountsConstants.COL_DAY].CellActivation = Activation.NoEdit;
band.Columns[WorkViewAccountsConstants.COL_VALUE_DATE].Header.Caption = WorkViewAccountsConstants.DISP_VALUE_DATE;
band.Columns[WorkViewAccountsConstants.COL_VALUE_DATE].Width = 100;
band.Columns[WorkViewAccountsConstants.COL_VALUE_DATE].Header.VisiblePosition = headerPosition++;
band.Columns[WorkViewAccountsConstants.COL_VALUE_DATE].CellActivation = Activation.NoEdit;
band.Columns[WorkViewAccountsConstants.COL_CREDITS_AC].Header.Caption = WorkViewAccountsConstants.DISP_ACCOUNT_CURRENCY;
band.Columns[WorkViewAccountsConstants.COL_CREDITS_AC].Width = 100;
band.Columns[WorkViewAccountsConstants.COL_CREDITS_AC].Header.VisiblePosition = headerPosition++;
band.Columns[WorkViewAccountsConstants.COL_CREDITS_AC].CellActivation = Activation.NoEdit;
band.Columns[WorkViewAccountsConstants.COL_CREDITS_USD].Header.Caption = WorkViewAccountsConstants.DISP_USD;
band.Columns[WorkViewAccountsConstants.COL_CREDITS_USD].Width = 100;
band.Columns[WorkViewAccountsConstants.COL_CREDITS_USD].Header.VisiblePosition = headerPosition++;
band.Columns[WorkViewAccountsConstants.COL_CREDITS_USD].CellActivation = Activation.NoEdit;
band.Columns[WorkViewAccountsConstants.COL_DEBITS_AC].Header.Caption = WorkViewAccountsConstants.DISP_ACCOUNT_CURRENCY;
band.Columns[WorkViewAccountsConstants.COL_DEBITS_AC].Width = 100;
band.Columns[WorkViewAccountsConstants.COL_DEBITS_AC].Header.VisiblePosition = headerPosition++;
band.Columns[WorkViewAccountsConstants.COL_DEBITS_AC].CellActivation = Activation.NoEdit;
band.Columns[WorkViewAccountsConstants.COL_DEBITS_USD].Header.Caption = WorkViewAccountsConstants.DISP_USD;
band.Columns[WorkViewAccountsConstants.COL_DEBITS_USD].Width = 100;
band.Columns[WorkViewAccountsConstants.COL_DEBITS_USD].Header.VisiblePosition = headerPosition++;
band.Columns[WorkViewAccountsConstants.COL_DEBITS_USD].CellActivation = Activation.NoEdit;
band.Columns[WorkViewAccountsConstants.COL_COMMITTED_AC].Header.Caption = WorkViewAccountsConstants.DISP_ACCOUNT_CURRENCY;
band.Columns[WorkViewAccountsConstants.COL_COMMITTED_AC].Width = 100;
band.Columns[WorkViewAccountsConstants.COL_COMMITTED_AC].Header.VisiblePosition = headerPosition++;
band.Columns[WorkViewAccountsConstants.COL_COMMITTED_AC].CellActivation = Activation.NoEdit;
band.Columns[WorkViewAccountsConstants.COL_COMMITTED_USD].Header.Caption = WorkViewAccountsConstants.DISP_USD;
band.Columns[WorkViewAccountsConstants.COL_COMMITTED_USD].Width = 100;
band.Columns[WorkViewAccountsConstants.COL_COMMITTED_USD].Header.VisiblePosition = headerPosition++;
band.Columns[WorkViewAccountsConstants.COL_COMMITTED_USD].CellActivation = Activation.NoEdit;
}
Then I call a method to set up the groups:
private void SetupGrid()
UltraGridBand band = this.gridVDCF.DisplayLayout.Bands[0];
//Arrange the band's column in Group Layout style
band.RowLayoutStyle = RowLayoutStyle.GroupLayout;
UltraGridGroup firstGroup = band.Groups.Add("FirstGroup", "Committed Credits");
UltraGridGroup secondGroup = band.Groups.Add("SecondGroup", "Committed Debits");
UltraGridGroup thirdGroup = band.Groups.Add("ThirdGroup", "Value Date Committed Funds");
band.Columns[WorkViewAccountsConstants.COL_CREDITS_AC].RowLayoutColumnInfo.ParentGroup = firstGroup;
band.Columns[WorkViewAccountsConstants.COL_CREDITS_USD].RowLayoutColumnInfo.ParentGroup = firstGroup;
band.Columns[WorkViewAccountsConstants.COL_DEBITS_AC].RowLayoutColumnInfo.ParentGroup = secondGroup;
band.Columns[WorkViewAccountsConstants.COL_DEBITS_USD].RowLayoutColumnInfo.ParentGroup = secondGroup;
band.Columns[WorkViewAccountsConstants.COL_COMMITTED_AC].RowLayoutColumnInfo.ParentGroup = thirdGroup;
band.Columns[WorkViewAccountsConstants.COL_COMMITTED_USD].RowLayoutColumnInfo.ParentGroup = thirdGroup;
I want the non-grouped columns to appear first, but the grid puts the grouped columns first and the non-grouped columns at the end. Also, I would like the column headers of the non-grouped columns to span vertically - like in the graphic, the ValueDate column is taller.
As a starting point I used this sample:
http://help.infragistics.com/NetAdvantage/WinForms/2010.3/CLR2.0/?page=WinGrid_Grouping_Columns_in_Row_Layout_using_code.html
I feel that I almost got it. I just need a little assistance to get it to look like I want it to.
Thanks!
Hi,
adrian_maull said:I feel that I almost got it. I just need a little assistance to get it to look like I want it to.
Yep, it sounds like you are almost there.
To arrange the columns and groups in the order you want, you use the OriginX property on the RowLayoutColumnInfo or RowLayoutGroupInfo.
The spans of every object default to 2x2, so in a case like this, you will probably want to use multiples of 2 for your OriginX values. Or, you could set the SpanX and SpanY on each object to 1 to make things a little easier.
So let's assume you do this the cleaner way and you loop through every column and set it's RowLayoutColumnInfo.SpanX and SpanY to 1.
Then you would set the OriginX on the "Value Date" column to 0. On the "Committed Credits" group, you would set the OriginX to 1 (since the span of the previous column is 1). The "Committed Credits" is two columns wide, to the next OriginX would be 3 so the OriginX of the "Committed Debts group would be 3. And so on down the line.
To make the "Value Date" column span the height of the groups, you would need to set it's SpanY to 2 (one for the group header and one for the column headers within the groups).
how can i insert a row in this grid
How can i insert free row in excel?in c# language?
Thank you for help.
Hello chaibi,
You could insert a row through the datasource assigned to the WinGrid and also use the 'AllowAddNew' property on the Override: http://help.infragistics.com/NetAdvantage/WinForms/2012.2/CLR4.0/?page=Infragistics4.Win.UltraWinGrid.v12.2~Infragistics.Win.UltraWinGrid.UltraGridOverride~AllowAddNew.html.