This is a migrated thread and some comments may be shown as answers.

Layout Saving Issue

10 Answers 176 Views

GridView

This is a migrated thread and some comments may be shown as answers.

10 Answers, 1 is accepted

answered on 14 Sep 2012, 12:23 PM

Hi William,

You can change the XmlSerializationInfo metadata information to include SummaryRowGroupHeaders in the saved layout. Here is an example:

using System.ComponentModel;

using System.Data;

using System.Windows.Forms;

using Telerik.WinControls.UI;

namespace Lab.Grid

{

public partial class GridSaveLoadGroupForm : MainForm

{

private RadGridView gridView = new RadGridView();

public GridSaveLoadGroupForm()

{

InitializeComponent();

gridView.Dock = DockStyle.Fill;

gridView.Parent = this;

gridView.BringToFront();

DataTable table = new DataTable();

table.Columns.Add("ID");

table.Columns.Add("Name");

table.Rows.Add(1, "name1");

table.Rows.Add(2, "user2");

table.Rows.Add(3, "name3");

table.Rows.Add(4, "name4");

table.Rows.Add(1, "user5");

table.Rows.Add(5, "name6");

table.Rows.Add(3, "user7");

table.Rows.Add(8, "name8");

this.gridView.DataSource = table;

this.gridView.MasterTemplate.SummaryRowGroupHeaders.Add(new GridViewSummaryRowItem(new GridViewSummaryItem[] { new GridViewSummaryItem("ID", "FormatString: {0}", GridAggregateFunction.Count) }));

this.gridView.XmlSerializationInfo.SerializationMetadata.Add(typeof(GridViewTemplate), "SummaryRowGroupHeaders", DesignerSerializationVisibilityAttribute.Content);

}

protected override void OnButton1Click()

{

gridView.SaveLayout("c:\\test-123.xml");

}

protected override void OnButton3Click()

{

gridView.LoadLayout("c:\\test-123.xml");

}

I hope this helps.

Regards,
Julian Benkov
the Telerik team

RadControls for WinForms Q2'12 release is now live! Check out what's new or download a free trial >>

answered on 07 Nov 2012, 01:25 PM

Hi William,

Thank you for writing.

You can try to update the values of the expanded ChildRows of a DataGroup using the GroupExpanded event handler:

void gridView_GroupExpanded(object sender, GroupExpandedEventArgs e)

{

foreach (GridViewRowInfo row in e.DataGroup.GroupRow.ChildRows)

{

row.InvalidateRow();

}

I hope this helps. If you continue to experience the issues please send me a sample application with your implementation of the Summary calculations that demonstrate the issue so we can investigate it locally and find best solution for the case.

All the best,
Julian Benkov
the Telerik team

Q3’11 of RadControls for WinForms is available for download (see what's new). Get it today.

answered on 09 Nov 2012, 04:59 AM

Hi

The code sample provided in last post didn't work.
I have attached the code files(both cs and designer) using to add summaries to my grid, i didn't get enough time for making a sample application for you. Please review them and ask if any confusion.

Thanks

using System;

using System.Data;

using System.Windows.Forms;

using CS.CommonLib;

using Moftak.Net.Utilities;

using CS.WinControls;

using System.ComponentModel;

namespace Telerik.WinControls.UI

{

public partial class RadGridLayoutSummary : Form

{

#region Declaration And Constructor

private readonly RadGridViewEx _gridControl;

public RadGridLayoutSummary()

{

InitializeComponent();

}

public RadGridLayoutSummary(RadGridViewEx gridControl)

: this()

{

_gridControl = gridControl;

_gridControl.EnableHotTracking = true;

}

#endregion Declaration And Constructor

#region PageLoad

private void RadGridLayoutSummary_Load(object sender, EventArgs e)

{

try

{

InitializeComboValues();

groupBox1.Controls.Add(radComboPosition);

groupBox1.Controls.Add(radComboColumn);

groupBox1.Controls.Add(radComboFunction);

InitComboBoxes();

}

catch (Exception ex)

{

ErrorHandler.GenerateErrorMail(ex, true, this);

}

#endregion PageLoad

#region Function

/// <summary>

/// fills position combo with values

/// </summary>

private void InitializeComboValues()

{

var item1 = new RadListDataItem("Group Header Row", "0");

radComboPosition.Items.Add(item1);

var item2 = new RadListDataItem("Top Summary Rows", "1");

radComboPosition.Items.Add(item2);

var item3 = new RadListDataItem("Bottom Summary Rows", "2");

radComboPosition.Items.Add(item3);

}

/// <summary>

/// Initializes Combo Data

/// </summary>

private void InitComboBoxes()

{

//Types

radComboFunction.DataSource = Enum.GetValues(typeof(GridAggregateFunction));

radComboFunction.SelectedIndex = 1;

//Columns

FillColumnCombo();

//Position

radComboPosition.SelectedIndex = 0;

radComboBox3.SelectedIndex = 0;

}

/// <summary>

/// fills combo column will records

/// </summary>

private void FillColumnCombo()

{

// Create new DataTable and DataSource objects.

var table = new DataTable();

// Create new DataColumn, set DataType, ColumnName and add to DataTable.

var column = new DataColumn {DataType = Type.GetType("System.String"), ColumnName = "HeaderName"};

table.Columns.Add(column);

// Create second column.

column = new DataColumn {DataType = Type.GetType("System.String"), ColumnName = "FieldName"};

table.Columns.Add(column);

// Create new DataRow objects and add to DataTable.

for (int i = 0; i < _gridControl.MasterTemplate.Columns.Count; i++)

{

DataRow row = table.NewRow();

row["HeaderName"] = _gridControl.MasterTemplate.Columns[i].HeaderText;

row["FieldName"] = _gridControl.MasterTemplate.Columns[i].Name;

table.Rows.Add(row);

}

// Create a DataView using the DataTable.

var view = new DataView(table) {Sort = "HeaderName ASC"};

// Set a DataGrid control's DataSource to the DataView.

radComboColumn.DisplayMember = "HeaderName";

radComboColumn.ValueMember = "FieldName";

radComboColumn.DataSource = view;

}

private static GridViewSummaryRowItem CollectionItem(GridViewSummaryRowItemCollection collection, int rowIndex, out bool updated)

{

updated = false;

if (collection == null || rowIndex < 0) return null;

while (rowIndex >= collection.Count)

{

updated = true;

collection.Add(new GridViewSummaryRowItem());

}

return collection[rowIndex];

}

/// <summary>

/// Rebuild Combo Items And add summary to the specific row

/// </summary>

/// <param name="comboBox"></param>

/// <param name="count"></param>

private static void RebuildComboBoxItems(RadDropDownList comboBox, int count)

{

comboBox.BeginUpdate();

comboBox.Items.Clear();

for (int i = 0; i < count; i++)

{

comboBox.Items.Add(new RadListDataItem(string.Format("Row {0}", i + 1)));

}

comboBox.Items.Add(new RadListDataItem("New Row"));

comboBox.SelectedIndex = count - 1;

comboBox.EndUpdate();

}

#endregion Function

#region Events

private void btnSave_Click(object sender, EventArgs e)

{

try

{

GridViewSummaryRowItem item = null;

string formatString = string.Empty;

bool updated;

switch (radComboPosition.SelectedIndex)

{

case 0:

item = CollectionItem(

_gridControl.MasterTemplate.SummaryRowGroupHeaders,

0, out updated);

formatString = string.Format("{2} of {0}: {1}; ",

ConvertUtility.GetStringValue(radComboColumn.SelectedValue), "{0:###,##0.00;(###,##0.00);}",

//radComboColumn.GetItemText(radComboColumn.SelectedIndex), "{0}",

(GridAggregateFunction)radComboFunction.SelectedIndex);

break;

case 1:

item = CollectionItem(

_gridControl.MasterTemplate.SummaryRowsTop,

radComboBox3.SelectedIndex,

out updated

);

if (updated)

RebuildComboBoxItems(radComboBox3, _gridControl.MasterTemplate.SummaryRowsTop.Count);

//formatString = string.Format("{0}: {1}; ",

// (GridAggregateFunction)radComboFunction.SelectedIndex, "{0}");

formatString = string.Format("{0}: {1}; ",

(GridAggregateFunction)radComboFunction.SelectedIndex, "{0:###,##0.00;(###,##0.00);}");

break;

case 2:

item = CollectionItem(

_gridControl.MasterTemplate.SummaryRowsBottom,

radComboBox3.SelectedIndex,

out updated

);

if (updated)

RebuildComboBoxItems(radComboBox3, _gridControl.MasterTemplate.SummaryRowsBottom.Count);

//formatString = string.Format("{0}: {1}; ",

// (GridAggregateFunction)radComboFunction.SelectedIndex, "{0}");

formatString = string.Format("{0}: {1}; ",

(GridAggregateFunction)radComboFunction.SelectedIndex, "{0:###,##0.00;(###,##0.00);}");

break;

}

if (item == null)

return;

string fieldName = radComboColumn.SelectedValue.ToString();

// ((RadComboBoxItem)radComboColumn.se).Text;

item.Add(new GridViewSummaryItem(

fieldName,

formatString,

(GridAggregateFunction) radComboFunction.SelectedIndex

));

//http://www.telerik.com/community/forums/winforms/gridview/layout-saving-issue.aspx

//[749] Save summaries in layouts

//[750] Update summaries if new search

if(radComboPosition.SelectedIndex.Equals(0))

{

//_gridControl.MasterTemplate.SummaryRowGroupHeaders.Add(

// new GridViewSummaryRowItem(new GridViewSummaryItem[]

// {

//                                           new GridViewSummaryItem(ConvertUtility.GetStringValue(radComboColumn.SelectedValue),

// formatString,

//                                               (GridAggregateFunction)radComboFunction.SelectedIndex)

// }));

//_gridControl.MasterTemplate.SummaryRowGroupHeaders.Add(item);

_gridControl.XmlSerializationInfo.SerializationMetadata.Add(typeof(GridViewTemplate),

"SummaryRowGroupHeaders",

DesignerSerializationVisibilityAttribute

.Content);

}

CustomMessageBox.Show(@"Summary Added Successfully.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information);

Close();

}

catch (Exception ex)

{

ErrorHandler.GenerateErrorMail(ex, true, this);

}

private void btnCancel_Click(object sender, EventArgs e)

{

Close();

}

#endregion Events

}

namespace Telerik.WinControls.UI

{

partial class RadGridLayoutSummary

{

/// <summary>

/// Required designer variable.

/// </summary>

private System.ComponentModel.IContainer components = null;

/// <summary>

/// Clean up any resources being used.

/// </summary>

/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>

protected override void Dispose(bool disposing)

{

if (disposing && (components != null))

{

components.Dispose();

}

base.Dispose(disposing);

}

#region Windows Form Designer generated code

/// <summary>

/// Required method for Designer support - do not modify

/// the contents of this method with the code editor.

/// </summary>

private void InitializeComponent()

{

System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(RadGridLayoutSummary));

this.groupBox1 = new System.Windows.Forms.GroupBox();

this.btnCancel = new System.Windows.Forms.Button();

this.btnSave = new System.Windows.Forms.Button();

this.lblSummaryType = new System.Windows.Forms.Label();

this.lblSummaryColumn = new System.Windows.Forms.Label();

this.lblSummaryPosition = new System.Windows.Forms.Label();

this.radComboColumn = new Telerik.WinControls.UI.RadDropDownList();

this.radComboPosition = new Telerik.WinControls.UI.RadDropDownList();

this.radComboFunction = new Telerik.WinControls.UI.RadDropDownList();

this.radComboBox3 = new Telerik.WinControls.UI.RadDropDownList();

this.radComboBoxItem6 = new Telerik.WinControls.UI.RadListDataItem();

this.radComboBoxItem5 = new Telerik.WinControls.UI.RadListDataItem();

this.groupBox1.SuspendLayout();

((System.ComponentModel.ISupportInitialize)(this.radComboColumn)).BeginInit();

((System.ComponentModel.ISupportInitialize)(this.radComboPosition)).BeginInit();

((System.ComponentModel.ISupportInitialize)(this.radComboFunction)).BeginInit();

((System.ComponentModel.ISupportInitialize)(this.radComboBox3)).BeginInit();

this.SuspendLayout();

//

// groupBox1

//

this.groupBox1.Controls.Add(this.btnCancel);

this.groupBox1.Controls.Add(this.btnSave);

this.groupBox1.Controls.Add(this.lblSummaryType);

this.groupBox1.Controls.Add(this.lblSummaryColumn);

this.groupBox1.Controls.Add(this.lblSummaryPosition);

this.groupBox1.Dock = System.Windows.Forms.DockStyle.Fill;

this.groupBox1.Location = new System.Drawing.Point(0, 0);

this.groupBox1.Name = "groupBox1";

this.groupBox1.Size = new System.Drawing.Size(264, 144);

this.groupBox1.TabIndex = 0;

this.groupBox1.TabStop = false;

//

// btnCancel

//

this.btnCancel.DialogResult = System.Windows.Forms.DialogResult.Cancel;

this.btnCancel.Location = new System.Drawing.Point(207, 116);

this.btnCancel.Name = "btnCancel";

this.btnCancel.Size = new System.Drawing.Size(50, 25);

this.btnCancel.TabIndex = 4;

this.btnCancel.Text = "Cancel";

this.btnCancel.UseVisualStyleBackColor = true;

this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);

//

// btnSave

//

this.btnSave.Location = new System.Drawing.Point(158, 116);

this.btnSave.Name = "btnSave";

this.btnSave.Size = new System.Drawing.Size(43, 25);

this.btnSave.TabIndex = 3;

this.btnSave.Text = "Save";

this.btnSave.UseVisualStyleBackColor = true;

this.btnSave.Click += new System.EventHandler(this.btnSave_Click);

//

// lblSummaryType

//

this.lblSummaryType.AutoSize = true;

this.lblSummaryType.Location = new System.Drawing.Point(8, 77);

this.lblSummaryType.Name = "lblSummaryType";

this.lblSummaryType.Size = new System.Drawing.Size(80, 13);

this.lblSummaryType.TabIndex = 2;

this.lblSummaryType.Text = "Summary Type:";

//

// lblSummaryColumn

//

this.lblSummaryColumn.AutoSize = true;

this.lblSummaryColumn.Location = new System.Drawing.Point(8, 50);

this.lblSummaryColumn.Name = "lblSummaryColumn";

this.lblSummaryColumn.Size = new System.Drawing.Size(91, 13);

this.lblSummaryColumn.TabIndex = 1;

this.lblSummaryColumn.Text = "Summary Column:";

//

// lblSummaryPosition

//

this.lblSummaryPosition.AutoSize = true;

this.lblSummaryPosition.Location = new System.Drawing.Point(8, 24);

this.lblSummaryPosition.Name = "lblSummaryPosition";

this.lblSummaryPosition.Size = new System.Drawing.Size(93, 13);

this.lblSummaryPosition.TabIndex = 0;

this.lblSummaryPosition.Text = "Summary Position:";

//

// radComboColumn

//

this.radComboColumn.DisplayMember = "HeaderName";

this.radComboColumn.DropDownSizingMode = ((Telerik.WinControls.UI.SizingMode)((Telerik.WinControls.UI.SizingMode.RightBottom | Telerik.WinControls.UI.SizingMode.UpDown)));

this.radComboColumn.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;

this.radComboColumn.Location = new System.Drawing.Point(107, 50);

this.radComboColumn.Name = "radComboColumn";

//

this.radComboColumn.RootElement.AutoSizeMode = Telerik.WinControls.RadAutoSizeMode.WrapAroundChildren;

this.radComboColumn.Size = new System.Drawing.Size(155, 20);

this.radComboColumn.TabIndex = 1;

this.radComboColumn.TabStop = false;

this.radComboColumn.ValueMember = "FieldAlias";

//

// radComboPosition

//

this.radComboPosition.BackColor = System.Drawing.SystemColors.Control;

this.radComboPosition.DropDownSizingMode = ((Telerik.WinControls.UI.SizingMode)((Telerik.WinControls.UI.SizingMode.RightBottom | Telerik.WinControls.UI.SizingMode.UpDown)));

this.radComboPosition.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;

this.radComboPosition.FormatString = "{0}";

this.radComboPosition.Location = new System.Drawing.Point(107, 24);

this.radComboPosition.Name = "radComboPosition";

//

this.radComboPosition.RootElement.AutoSizeMode = Telerik.WinControls.RadAutoSizeMode.WrapAroundChildren;

this.radComboPosition.Size = new System.Drawing.Size(155, 20);

this.radComboPosition.TabIndex = 0;

this.radComboPosition.TabStop = false;

//

// radComboFunction

//

this.radComboFunction.DropDownSizingMode = ((Telerik.WinControls.UI.SizingMode)((Telerik.WinControls.UI.SizingMode.RightBottom | Telerik.WinControls.UI.SizingMode.UpDown)));

this.radComboFunction.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;

this.radComboFunction.Location = new System.Drawing.Point(107, 77);

this.radComboFunction.Name = "radComboFunction";

//

this.radComboFunction.RootElement.AutoSizeMode = Telerik.WinControls.RadAutoSizeMode.WrapAroundChildren;

this.radComboFunction.Size = new System.Drawing.Size(155, 20);

this.radComboFunction.TabIndex = 2;

this.radComboFunction.TabStop = false;

//

// radComboBox3

//

this.radComboBox3.Anchor = System.Windows.Forms.AnchorStyles.Top;

this.radComboBox3.DropDownSizingMode = ((Telerik.WinControls.UI.SizingMode)((Telerik.WinControls.UI.SizingMode.RightBottom | Telerik.WinControls.UI.SizingMode.UpDown)));

this.radComboBox3.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;

this.radComboBox3.ForeColor = System.Drawing.Color.Black;

this.radComboBox3.FormatString = "{0}";

this.radComboBox3.Items.AddRange(new Telerik.WinControls.UI.RadListDataItem[] {

this.radComboBoxItem6,

this.radComboBoxItem5});

this.radComboBox3.Location = new System.Drawing.Point(21, 265);

this.radComboBox3.Name = "radComboBox3";

//

this.radComboBox3.RootElement.AutoSizeMode = Telerik.WinControls.RadAutoSizeMode.WrapAroundChildren;

this.radComboBox3.RootElement.ForeColor = System.Drawing.Color.Black;

this.radComboBox3.Size = new System.Drawing.Size(138, 20);

this.radComboBox3.TabIndex = 3;

this.radComboBox3.TabStop = false;

//

// radComboBoxItem6

//

//this.radComboBoxItem6.CanFocus = false;

//this.radComboBoxItem6.Name = "radComboBoxItem6";

this.radComboBoxItem6.Text = "Row 1";

//

// radComboBoxItem5

//

//this.radComboBoxItem5.CanFocus = false;

//this.radComboBoxItem5.Name = "radComboBoxItem5";

this.radComboBoxItem5.Text = "New Row";

//

// RadGridLayoutSummary

//

this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);

this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;

this.CancelButton = this.btnCancel;

this.ClientSize = new System.Drawing.Size(264, 144);

this.Controls.Add(this.groupBox1);

this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.Fixed3D;

this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));

this.MaximizeBox = false;

this.MinimizeBox = false;

this.Name = "RadGridLayoutSummary";

this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;

this.Text = "Grid Layout Summary";

this.Load += new System.EventHandler(this.RadGridLayoutSummary_Load);

this.groupBox1.ResumeLayout(false);

this.groupBox1.PerformLayout();

((System.ComponentModel.ISupportInitialize)(this.radComboColumn)).EndInit();

((System.ComponentModel.ISupportInitialize)(this.radComboPosition)).EndInit();

((System.ComponentModel.ISupportInitialize)(this.radComboFunction)).EndInit();

((System.ComponentModel.ISupportInitialize)(this.radComboBox3)).EndInit();

this.ResumeLayout(false);

}

#endregion

private System.Windows.Forms.GroupBox groupBox1;

private System.Windows.Forms.Label lblSummaryPosition;

private Telerik.WinControls.UI.RadDropDownList radComboPosition;

private System.Windows.Forms.Label lblSummaryColumn;

private Telerik.WinControls.UI.RadDropDownList radComboColumn;

private Telerik.WinControls.UI.RadDropDownList radComboFunction;

private System.Windows.Forms.Button btnSave;

private System.Windows.Forms.Button btnCancel;

private System.Windows.Forms.Label lblSummaryType;

private Telerik.WinControls.UI.RadDropDownList radComboBox3;

private Telerik.WinControls.UI.RadListDataItem radComboBoxItem5;

private Telerik.WinControls.UI.RadListDataItem radComboBoxItem6;

}

answered on 12 Nov 2012, 02:32 PM

Hi William,

Thank you for sharing your Form implementation. I reviewed the source code and I cannot find where the problematic section is or which processing generates wrong result. Therefore, in order to be able to assist you, I would kindly ask you to create a sample project with some part of your data which can demonstrate the experienced behavior. This will allow us to understand the issue which is the necessary step in order to be able to address it.

Thank you for your cooperation. I am looking forward to your response.

Greetings,
Julian Benkov
the Telerik team

Q3’12 of RadControls for WinForms is available for download (see what's new). Get it today.

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Productivity and Design Tools

Layout Saving Issue

10 Answers, 1 is accepted