/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor2 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor3 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor4 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor5 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor6 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor7 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor8 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor9 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor10 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor11 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor12 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor13 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor14 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); this.gridGroupingControl1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl(); this.dataSet11 = new SummaryTutorial.DataSet1(); ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit(); this.SuspendLayout(); // // gridGroupingControl1 // this.gridGroupingControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.gridGroupingControl1.BackColor = System.Drawing.SystemColors.Window; this.gridGroupingControl1.DataSource = this.dataSet11.Orders; this.gridGroupingControl1.FreezeCaption = false; this.gridGroupingControl1.GridOfficeScrollBars = Syncfusion.Windows.Forms.OfficeScrollBars.Metro; this.gridGroupingControl1.GridVisualStyles = Syncfusion.Windows.Forms.GridVisualStyles.Metro; this.gridGroupingControl1.Location = new System.Drawing.Point(3, 0); this.gridGroupingControl1.Name = "gridGroupingControl1"; this.gridGroupingControl1.Size = new System.Drawing.Size(1007, 655); this.gridGroupingControl1.TabIndex = 0; this.gridGroupingControl1.TableDescriptor.AllowNew = false; this.gridGroupingControl1.TableDescriptor.Appearance.AnyCell.Font.Facename = "Segoe UI"; this.gridGroupingControl1.TableDescriptor.Appearance.AnyCell.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(138)))), ((int)(((byte)(138)))), ((int)(((byte)(138))))); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.Borders.Bottom = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.Borders.Right = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(235)))), ((int)(((byte)(235)))), ((int)(((byte)(235)))))); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(138)))), ((int)(((byte)(138)))), ((int)(((byte)(138))))); this.gridGroupingControl1.TableDescriptor.Appearance.AnyRecordFieldCell.Borders.Bottom = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnyRecordFieldCell.Borders.Right = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnySummaryCell.Borders.Right = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(208)))), ((int)(((byte)(208)))), ((int)(((byte)(208))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnySummaryCell.Borders.Top = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(208)))), ((int)(((byte)(208)))), ((int)(((byte)(208))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnySummaryCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(208)))), ((int)(((byte)(208)))), ((int)(((byte)(208)))))); this.gridGroupingControl1.TableDescriptor.Appearance.ColumnHeaderCell.Font.Bold = true; this.gridGroupingControl1.TableDescriptor.Appearance.GroupCaptionCell.CellType = "ColumnHeader"; gridColumnDescriptor1.HeaderImage = null; gridColumnDescriptor1.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor1.MappingName = "CustomerID"; gridColumnDescriptor1.SerializedImageArray = ""; gridColumnDescriptor2.HeaderImage = null; gridColumnDescriptor2.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor2.MappingName = "EmployeeID"; gridColumnDescriptor2.SerializedImageArray = ""; gridColumnDescriptor3.HeaderImage = null; gridColumnDescriptor3.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor3.MappingName = "Freight"; gridColumnDescriptor3.SerializedImageArray = ""; gridColumnDescriptor4.HeaderImage = null; gridColumnDescriptor4.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor4.HeaderText = "Order Date"; gridColumnDescriptor4.MappingName = "OrderDate"; gridColumnDescriptor4.SerializedImageArray = ""; gridColumnDescriptor5.HeaderImage = null; gridColumnDescriptor5.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor5.MappingName = "OrderID"; gridColumnDescriptor5.SerializedImageArray = ""; gridColumnDescriptor6.HeaderImage = null; gridColumnDescriptor6.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor6.HeaderText = "Required Date"; gridColumnDescriptor6.MappingName = "RequiredDate"; gridColumnDescriptor6.SerializedImageArray = ""; gridColumnDescriptor7.HeaderImage = null; gridColumnDescriptor7.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor7.HeaderText = "Ship Address"; gridColumnDescriptor7.MappingName = "ShipAddress"; gridColumnDescriptor7.SerializedImageArray = ""; gridColumnDescriptor8.HeaderImage = null; gridColumnDescriptor8.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor8.HeaderText = "Ship City"; gridColumnDescriptor8.MappingName = "ShipCity"; gridColumnDescriptor8.SerializedImageArray = ""; gridColumnDescriptor9.HeaderImage = null; gridColumnDescriptor9.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor9.HeaderText = "Ship Country"; gridColumnDescriptor9.MappingName = "ShipCountry"; gridColumnDescriptor9.SerializedImageArray = ""; gridColumnDescriptor10.HeaderImage = null; gridColumnDescriptor10.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor10.HeaderText = "Ship Name"; gridColumnDescriptor10.MappingName = "ShipName"; gridColumnDescriptor10.SerializedImageArray = ""; gridColumnDescriptor11.HeaderImage = null; gridColumnDescriptor11.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor11.HeaderText = "Shipped Date"; gridColumnDescriptor11.MappingName = "ShippedDate"; gridColumnDescriptor11.SerializedImageArray = ""; gridColumnDescriptor12.HeaderImage = null; gridColumnDescriptor12.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor12.HeaderText = "Ship Postal Code"; gridColumnDescriptor12.MappingName = "ShipPostalCode"; gridColumnDescriptor12.SerializedImageArray = ""; gridColumnDescriptor13.HeaderImage = null; gridColumnDescriptor13.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor13.HeaderText = "Ship Region"; gridColumnDescriptor13.MappingName = "ShipRegion"; gridColumnDescriptor13.SerializedImageArray = ""; gridColumnDescriptor14.HeaderImage = null; gridColumnDescriptor14.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor14.HeaderText = "Ship Via"; gridColumnDescriptor14.MappingName = "ShipVia"; gridColumnDescriptor14.SerializedImageArray = ""; this.gridGroupingControl1.TableDescriptor.Columns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor[] { gridColumnDescriptor1, gridColumnDescriptor2, gridColumnDescriptor3, gridColumnDescriptor4, gridColumnDescriptor5, gridColumnDescriptor6, gridColumnDescriptor7, gridColumnDescriptor8, gridColumnDescriptor9, gridColumnDescriptor10, gridColumnDescriptor11, gridColumnDescriptor12, gridColumnDescriptor13, gridColumnDescriptor14 }); this.gridGroupingControl1.TableDescriptor.TableOptions.ColumnHeaderRowHeight = 32; this.gridGroupingControl1.TableDescriptor.TableOptions.RecordRowHeight = 22; this.gridGroupingControl1.Text = "gridGroupingControl1"; // // dataSet11 // this.dataSet11.DataSetName = "DataSet1"; this.dataSet11.Locale = new System.Globalization.CultureInfo("en-US"); this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // Form1 // this.MinimumSize = new System.Drawing.Size(800, 400); this.ClientSize = new System.Drawing.Size(1012, 656); this.Controls.Add(this.gridGroupingControl1); this.Name = "Form1"; this.Text = "Group Summary "; ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor2 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor3 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor4 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor5 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor6 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor7 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1)); this.panel1 = new System.Windows.Forms.Panel(); this.label2 = new System.Windows.Forms.Label(); this.afterDetails = new Syncfusion.Windows.Forms.Tools.CheckBoxAdv(); this.beforeDetails = new Syncfusion.Windows.Forms.Tools.CheckBoxAdv(); this.captionText = new Syncfusion.Windows.Forms.Tools.CheckBoxAdv(); this.showCaption = new Syncfusion.Windows.Forms.Tools.CheckBoxAdv(); this.ShowCaptionPlus = new Syncfusion.Windows.Forms.Tools.CheckBoxAdv(); this.label1 = new System.Windows.Forms.Label(); this.panel3 = new System.Windows.Forms.Panel(); this.label4 = new System.Windows.Forms.Label(); this.label3 = new System.Windows.Forms.Label(); this.lblProperty = new System.Windows.Forms.Label(); this.lblPropertyDisplay = new System.Windows.Forms.Label(); this.panel4 = new System.Windows.Forms.Panel(); this.gridGroupingControl1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl(); this.dataSet11 = new ChildGroupOptions.DataSet1(); this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection(); this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand(); this.panel5 = new System.Windows.Forms.Panel(); this.tipDesc = new System.Windows.Forms.ToolTip(this.components); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.afterDetails)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.beforeDetails)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.captionText)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.showCaption)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.ShowCaptionPlus)).BeginInit(); this.panel3.SuspendLayout(); this.panel4.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit(); this.panel5.SuspendLayout(); this.SuspendLayout(); // // panel1 // this.panel1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Right))); this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; this.panel1.Controls.Add(this.label2); this.panel1.Controls.Add(this.afterDetails); this.panel1.Controls.Add(this.beforeDetails); this.panel1.Controls.Add(this.captionText); this.panel1.Controls.Add(this.showCaption); this.panel1.Controls.Add(this.ShowCaptionPlus); this.panel1.Controls.Add(this.label1); this.panel1.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.panel1.ForeColor = System.Drawing.Color.DimGray; this.panel1.Location = new System.Drawing.Point(792, 4); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(210, 513); this.panel1.TabIndex = 0; // // label2 // this.label2.Font = new System.Drawing.Font("Segoe UI", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.label2.Location = new System.Drawing.Point(29, 168); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(176, 23); this.label2.TabIndex = 21; this.label2.Text = "Add New Record Field"; // // afterDetails // this.afterDetails.BeforeTouchSize = new System.Drawing.Size(150, 21); this.afterDetails.Font = new System.Drawing.Font("Segoe UI", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.afterDetails.Location = new System.Drawing.Point(37, 232); this.afterDetails.MetroColor = System.Drawing.Color.FromArgb(((int)(((byte)(27)))), ((int)(((byte)(161)))), ((int)(((byte)(226))))); this.afterDetails.Name = "afterDetails"; this.afterDetails.Size = new System.Drawing.Size(136, 24); this.afterDetails.Style = Syncfusion.Windows.Forms.Tools.CheckBoxAdvStyle.Metro; this.afterDetails.DrawFocusRectangle = true; this.afterDetails.TabIndex = 20; this.afterDetails.Text = "After Details"; this.afterDetails.ThemesEnabled = false; this.afterDetails.CheckStateChanged += new System.EventHandler(this.afterDetails_CheckStateChanged); // // beforeDetails // this.beforeDetails.BeforeTouchSize = new System.Drawing.Size(150, 21); this.beforeDetails.Checked = true; this.beforeDetails.CheckState = System.Windows.Forms.CheckState.Checked; this.beforeDetails.Font = new System.Drawing.Font("Segoe UI", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.beforeDetails.Location = new System.Drawing.Point(37, 200); this.beforeDetails.MetroColor = System.Drawing.Color.FromArgb(((int)(((byte)(27)))), ((int)(((byte)(161)))), ((int)(((byte)(226))))); this.beforeDetails.Name = "beforeDetails"; this.beforeDetails.Size = new System.Drawing.Size(136, 24); this.beforeDetails.Style = Syncfusion.Windows.Forms.Tools.CheckBoxAdvStyle.Metro; this.beforeDetails.DrawFocusRectangle = true; this.beforeDetails.TabIndex = 19; this.beforeDetails.Text = "Before Details"; this.beforeDetails.ThemesEnabled = false; this.beforeDetails.CheckStateChanged += new System.EventHandler(this.beforeDetails_CheckStateChanged); // // captionText // this.captionText.BeforeTouchSize = new System.Drawing.Size(150, 21); this.captionText.Font = new System.Drawing.Font("Segoe UI", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.captionText.Location = new System.Drawing.Point(37, 119); this.captionText.MetroColor = System.Drawing.Color.FromArgb(((int)(((byte)(27)))), ((int)(((byte)(161)))), ((int)(((byte)(226))))); this.captionText.Name = "captionText"; this.captionText.Size = new System.Drawing.Size(146, 24); this.captionText.Style = Syncfusion.Windows.Forms.Tools.CheckBoxAdvStyle.Metro; this.captionText.DrawFocusRectangle = true; this.captionText.TabIndex = 18; this.captionText.Text = "Modify Caption Text"; this.captionText.ThemesEnabled = false; this.captionText.CheckStateChanged += new System.EventHandler(this.captionText_CheckStateChanged); // // showCaption // this.showCaption.BeforeTouchSize = new System.Drawing.Size(150, 21); this.showCaption.Checked = true; this.showCaption.CheckState = System.Windows.Forms.CheckState.Checked; this.showCaption.Font = new System.Drawing.Font("Segoe UI", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.showCaption.Location = new System.Drawing.Point(37, 87); this.showCaption.MetroColor = System.Drawing.Color.FromArgb(((int)(((byte)(27)))), ((int)(((byte)(161)))), ((int)(((byte)(226))))); this.showCaption.Name = "showCaption"; this.showCaption.Size = new System.Drawing.Size(146, 24); this.showCaption.Style = Syncfusion.Windows.Forms.Tools.CheckBoxAdvStyle.Metro; this.showCaption.DrawFocusRectangle = true; this.showCaption.TabIndex = 17; this.showCaption.Text = "Show Caption"; this.showCaption.ThemesEnabled = false; this.showCaption.CheckStateChanged += new System.EventHandler(this.showCaption_CheckStateChanged); // // ShowCaptionPlus // this.ShowCaptionPlus.BeforeTouchSize = new System.Drawing.Size(150, 21); this.ShowCaptionPlus.Checked = true; this.ShowCaptionPlus.CheckState = System.Windows.Forms.CheckState.Checked; this.ShowCaptionPlus.Font = new System.Drawing.Font("Segoe UI", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.ShowCaptionPlus.Location = new System.Drawing.Point(37, 57); this.ShowCaptionPlus.MetroColor = System.Drawing.Color.FromArgb(((int)(((byte)(27)))), ((int)(((byte)(161)))), ((int)(((byte)(226))))); this.ShowCaptionPlus.Name = "ShowCaptionPlus"; this.ShowCaptionPlus.Size = new System.Drawing.Size(136, 24); this.ShowCaptionPlus.Style = Syncfusion.Windows.Forms.Tools.CheckBoxAdvStyle.Metro; this.ShowCaptionPlus.DrawFocusRectangle = true; this.ShowCaptionPlus.TabIndex = 16; this.ShowCaptionPlus.Text = "Show Caption +/-"; this.ShowCaptionPlus.ThemesEnabled = false; this.ShowCaptionPlus.CheckStateChanged += new System.EventHandler(this.ShowCaptionPlus_CheckStateChanged); // // label1 // this.label1.Font = new System.Drawing.Font("Segoe UI", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.label1.Location = new System.Drawing.Point(29, 25); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(160, 23); this.label1.TabIndex = 9; this.label1.Text = "Child Group Options"; // // panel3 // this.panel3.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.panel3.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; this.panel3.Controls.Add(this.label4); this.panel3.Controls.Add(this.label3); this.panel3.Controls.Add(this.lblProperty); this.panel3.Controls.Add(this.lblPropertyDisplay); this.panel3.Font = new System.Drawing.Font("Segoe UI", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.panel3.ForeColor = System.Drawing.Color.DimGray; this.panel3.Location = new System.Drawing.Point(9, 526); this.panel3.Name = "panel3"; this.panel3.Size = new System.Drawing.Size(995, 118); this.panel3.TabIndex = 4; // // label4 // this.label4.Font = new System.Drawing.Font("Segoe UI", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.label4.Location = new System.Drawing.Point(24, 72); this.label4.Name = "label4"; this.label4.Size = new System.Drawing.Size(129, 23); this.label4.TabIndex = 3; this.label4.Text = "Changed Property :"; // // label3 // this.label3.Font = new System.Drawing.Font("Segoe UI", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.label3.Location = new System.Drawing.Point(24, 16); this.label3.Name = "label3"; this.label3.Size = new System.Drawing.Size(192, 40); this.label3.TabIndex = 2; this.label3.Text = "Changed ChildGroup Options Property :"; // // lblProperty // this.lblProperty.Font = new System.Drawing.Font("Segoe UI", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.lblProperty.Location = new System.Drawing.Point(218, 72); this.lblProperty.Name = "lblProperty"; this.lblProperty.Size = new System.Drawing.Size(349, 40); this.lblProperty.TabIndex = 1; // // lblPropertyDisplay // this.lblPropertyDisplay.Font = new System.Drawing.Font("Segoe UI", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.lblPropertyDisplay.Location = new System.Drawing.Point(218, 16); this.lblPropertyDisplay.Name = "lblPropertyDisplay"; this.lblPropertyDisplay.Size = new System.Drawing.Size(359, 40); this.lblPropertyDisplay.TabIndex = 0; // // panel4 // this.panel4.Controls.Add(this.gridGroupingControl1); this.panel4.Controls.Add(this.panel1); this.panel4.Dock = System.Windows.Forms.DockStyle.Fill; this.panel4.Location = new System.Drawing.Point(0, 0); this.panel4.Name = "panel4"; this.panel4.Size = new System.Drawing.Size(1236, 651); this.panel4.TabIndex = 6; // // gridGroupingControl1 // this.gridGroupingControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.gridGroupingControl1.BackColor = System.Drawing.SystemColors.Window; this.gridGroupingControl1.DataSource = this.dataSet11.Statistics; this.gridGroupingControl1.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.gridGroupingControl1.ForeColor = System.Drawing.Color.DimGray; this.gridGroupingControl1.FreezeCaption = false; this.gridGroupingControl1.Location = new System.Drawing.Point(6, 4); this.gridGroupingControl1.Name = "gridGroupingControl1"; this.gridGroupingControl1.ShowGroupDropArea = true; this.gridGroupingControl1.Size = new System.Drawing.Size(780, 513); this.gridGroupingControl1.TabIndex = 0; gridColumnDescriptor1.HeaderImage = null; gridColumnDescriptor1.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor1.MappingName = "ID"; gridColumnDescriptor1.SerializedImageArray = ""; gridColumnDescriptor2.HeaderImage = null; gridColumnDescriptor2.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor2.MappingName = "losses"; gridColumnDescriptor2.SerializedImageArray = ""; gridColumnDescriptor3.HeaderImage = null; gridColumnDescriptor3.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor3.MappingName = "School"; gridColumnDescriptor3.SerializedImageArray = ""; gridColumnDescriptor4.HeaderImage = null; gridColumnDescriptor4.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor4.MappingName = "Sport"; gridColumnDescriptor4.SerializedImageArray = ""; gridColumnDescriptor5.HeaderImage = null; gridColumnDescriptor5.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor5.MappingName = "ties"; gridColumnDescriptor5.SerializedImageArray = ""; gridColumnDescriptor6.HeaderImage = null; gridColumnDescriptor6.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor6.MappingName = "wins"; gridColumnDescriptor6.SerializedImageArray = ""; gridColumnDescriptor7.HeaderImage = null; gridColumnDescriptor7.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor7.MappingName = "year"; gridColumnDescriptor7.SerializedImageArray = ""; this.gridGroupingControl1.TableDescriptor.Columns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor[] { gridColumnDescriptor1, gridColumnDescriptor2, gridColumnDescriptor3, gridColumnDescriptor4, gridColumnDescriptor5, gridColumnDescriptor6, gridColumnDescriptor7 }); this.gridGroupingControl1.TableDescriptor.PrimaryKeyColumns.AddRange(new Syncfusion.Grouping.SortColumnDescriptor[] { new Syncfusion.Grouping.SortColumnDescriptor("ID", System.ComponentModel.ListSortDirection.Ascending) }); this.gridGroupingControl1.TableDescriptor.VisibleColumns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("ID"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("losses"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("School"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("Sport"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("ties"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("wins"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("year") }); this.gridGroupingControl1.Text = "gridGroupingControl1"; this.gridGroupingControl1.VersionInfo = "4.201.0.37"; // // dataSet11 // this.dataSet11.DataSetName = "DataSet1"; this.dataSet11.Locale = new System.Globalization.CultureInfo("en-US"); this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // oleDbDataAdapter1 // this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand1; this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1; this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1; this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Statistics", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("ID", "ID"), new System.Data.Common.DataColumnMapping("losses", "losses"), new System.Data.Common.DataColumnMapping("School", "School"), new System.Data.Common.DataColumnMapping("Sport", "Sport"), new System.Data.Common.DataColumnMapping("ties", "ties"), new System.Data.Common.DataColumnMapping("wins", "wins"), new System.Data.Common.DataColumnMapping("year", "year") }) }); this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1; // // oleDbDeleteCommand1 // this.oleDbDeleteCommand1.CommandText = resources.GetString("oleDbDeleteCommand1.CommandText"); this.oleDbDeleteCommand1.Connection = this.oleDbConnection1; this.oleDbDeleteCommand1.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] { new System.Data.OleDb.OleDbParameter("Original_ID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ID", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_School", System.Data.OleDb.OleDbType.VarWChar, 255, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "School", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_School1", System.Data.OleDb.OleDbType.VarWChar, 255, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "School", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Sport", System.Data.OleDb.OleDbType.VarWChar, 255, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Sport", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Sport1", System.Data.OleDb.OleDbType.VarWChar, 255, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Sport", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_losses", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "losses", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_losses1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "losses", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_ties", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ties", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_ties1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ties", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_wins", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "wins", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_wins1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "wins", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_year", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "year", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_year1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "year", System.Data.DataRowVersion.Original, null) }); // // oleDbConnection1 // this.oleDbConnection1.ConnectionString = resources.GetString("oleDbConnection1.ConnectionString"); // // oleDbInsertCommand1 // this.oleDbInsertCommand1.CommandText = "INSERT INTO Statistics(losses, School, Sport, ties, wins, year) VALUES (?, ?, ?, " + "?, ?, ?)"; this.oleDbInsertCommand1.Connection = this.oleDbConnection1; this.oleDbInsertCommand1.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] { new System.Data.OleDb.OleDbParameter("losses", System.Data.OleDb.OleDbType.Integer, 0, "losses"), new System.Data.OleDb.OleDbParameter("School", System.Data.OleDb.OleDbType.VarWChar, 255, "School"), new System.Data.OleDb.OleDbParameter("Sport", System.Data.OleDb.OleDbType.VarWChar, 255, "Sport"), new System.Data.OleDb.OleDbParameter("ties", System.Data.OleDb.OleDbType.Integer, 0, "ties"), new System.Data.OleDb.OleDbParameter("wins", System.Data.OleDb.OleDbType.Integer, 0, "wins"), new System.Data.OleDb.OleDbParameter("year", System.Data.OleDb.OleDbType.Integer, 0, "year") }); // // oleDbSelectCommand1 // this.oleDbSelectCommand1.CommandText = "SELECT ID, losses, School, Sport, ties, wins, year FROM Statistics"; this.oleDbSelectCommand1.Connection = this.oleDbConnection1; // // oleDbUpdateCommand1 // this.oleDbUpdateCommand1.CommandText = resources.GetString("oleDbUpdateCommand1.CommandText"); this.oleDbUpdateCommand1.Connection = this.oleDbConnection1; this.oleDbUpdateCommand1.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] { new System.Data.OleDb.OleDbParameter("losses", System.Data.OleDb.OleDbType.Integer, 0, "losses"), new System.Data.OleDb.OleDbParameter("School", System.Data.OleDb.OleDbType.VarWChar, 255, "School"), new System.Data.OleDb.OleDbParameter("Sport", System.Data.OleDb.OleDbType.VarWChar, 255, "Sport"), new System.Data.OleDb.OleDbParameter("ties", System.Data.OleDb.OleDbType.Integer, 0, "ties"), new System.Data.OleDb.OleDbParameter("wins", System.Data.OleDb.OleDbType.Integer, 0, "wins"), new System.Data.OleDb.OleDbParameter("year", System.Data.OleDb.OleDbType.Integer, 0, "year"), new System.Data.OleDb.OleDbParameter("Original_ID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ID", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_School", System.Data.OleDb.OleDbType.VarWChar, 255, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "School", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_School1", System.Data.OleDb.OleDbType.VarWChar, 255, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "School", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Sport", System.Data.OleDb.OleDbType.VarWChar, 255, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Sport", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Sport1", System.Data.OleDb.OleDbType.VarWChar, 255, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Sport", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_losses", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "losses", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_losses1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "losses", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_ties", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ties", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_ties1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ties", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_wins", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "wins", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_wins1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "wins", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_year", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "year", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_year1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "year", System.Data.DataRowVersion.Original, null) }); // // panel5 // this.panel5.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.panel5.BackColor = System.Drawing.Color.White; this.panel5.Controls.Add(this.panel3); this.panel5.Controls.Add(this.panel4); this.panel5.Location = new System.Drawing.Point(-1, 1); this.panel5.Name = "panel5"; this.panel5.Size = new System.Drawing.Size(1236, 651); this.panel5.TabIndex = 7; // // tipDesc // this.tipDesc.BackColor = System.Drawing.Color.White; this.tipDesc.ForeColor = System.Drawing.Color.Black; this.tipDesc.IsBalloon = true; this.tipDesc.ShowAlways = true; this.tipDesc.UseFading = false; // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.ClientSize = new System.Drawing.Size(1012, 653); this.Controls.Add(this.panel5); this.MinimumSize = new System.Drawing.Size(800, 500); this.Name = "Form1"; this.Text = "Child-Group Options "; this.panel1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.afterDetails)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.beforeDetails)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.captionText)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.showCaption)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.ShowCaptionPlus)).EndInit(); this.panel3.ResumeLayout(false); this.panel4.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit(); this.panel5.ResumeLayout(false); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor43 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor44 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor45 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor46 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor47 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor48 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor49 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor50 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor51 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor52 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor53 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor54 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor55 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor56 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderRowDescriptor gridStackedHeaderRowDescriptor4 = new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderRowDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderDescriptor gridStackedHeaderDescriptor13 = new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderDescriptor gridStackedHeaderDescriptor14 = new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderDescriptor gridStackedHeaderDescriptor15 = new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderDescriptor gridStackedHeaderDescriptor16 = new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderDescriptor(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlConnection2 = new System.Data.SqlClient.SqlConnection(); this.sqlDataAdapterOrders = new System.Data.SqlClient.SqlDataAdapter(); this.propertyGrid1 = new System.Windows.Forms.PropertyGrid(); this.gridGroupingControl1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl(); this.northwindDataSet1 = new StackedHeaders.DataSet1(); this.checkBoxAdv1 = new Syncfusion.Windows.Forms.Tools.CheckBoxAdv(); ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.northwindDataSet1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.checkBoxAdv1)).BeginInit(); this.SuspendLayout(); // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = "SELECT OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, Shi" + "pVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, Ship" + "Country FROM Orders"; this.sqlSelectCommand2.Connection = this.sqlConnection2; // // sqlConnection2 // this.sqlConnection2.ConnectionString = "Network Address=66.135.59.108,49489;initial catalog=NORTHWIND;password=Sync_sampl" + "es;persist security info=True;user id=sa;packet size=4096;Pooling=true"; this.sqlConnection2.FireInfoMessageEventOnUserErrors = false; // // sqlDataAdapterOrders // this.sqlDataAdapterOrders.SelectCommand = this.sqlSelectCommand2; this.sqlDataAdapterOrders.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Orders", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("OrderID", "OrderID"), new System.Data.Common.DataColumnMapping("CustomerID", "CustomerID"), new System.Data.Common.DataColumnMapping("EmployeeID", "EmployeeID"), new System.Data.Common.DataColumnMapping("OrderDate", "OrderDate"), new System.Data.Common.DataColumnMapping("RequiredDate", "RequiredDate"), new System.Data.Common.DataColumnMapping("ShippedDate", "ShippedDate"), new System.Data.Common.DataColumnMapping("ShipVia", "ShipVia"), new System.Data.Common.DataColumnMapping("Freight", "Freight"), new System.Data.Common.DataColumnMapping("ShipName", "ShipName"), new System.Data.Common.DataColumnMapping("ShipAddress", "ShipAddress"), new System.Data.Common.DataColumnMapping("ShipCity", "ShipCity"), new System.Data.Common.DataColumnMapping("ShipRegion", "ShipRegion"), new System.Data.Common.DataColumnMapping("ShipPostalCode", "ShipPostalCode"), new System.Data.Common.DataColumnMapping("ShipCountry", "ShipCountry") }) }); // // propertyGrid1 // this.propertyGrid1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Right))); this.propertyGrid1.BackColor = System.Drawing.Color.White; this.propertyGrid1.CommandsBackColor = System.Drawing.Color.White; this.propertyGrid1.CommandsDisabledLinkColor = System.Drawing.Color.White; this.propertyGrid1.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.propertyGrid1.HelpBackColor = System.Drawing.Color.White; this.propertyGrid1.LineColor = System.Drawing.Color.White; this.propertyGrid1.Location = new System.Drawing.Point(670, 61); this.propertyGrid1.Name = "propertyGrid1"; this.propertyGrid1.SelectedObject = this.gridGroupingControl1; this.propertyGrid1.Size = new System.Drawing.Size(331, 590); this.propertyGrid1.TabIndex = 11; // // gridGroupingControl1 // this.gridGroupingControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.gridGroupingControl1.Appearance.AnyCell.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(102))))); this.gridGroupingControl1.Appearance.StackedHeaderCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(192)))))); this.gridGroupingControl1.Appearance.StackedHeaderCell.Themed = false; this.gridGroupingControl1.BackColor = System.Drawing.SystemColors.Window; this.gridGroupingControl1.ChildGroupOptions.ShowAddNewRecordBeforeDetails = false; this.gridGroupingControl1.ChildGroupOptions.ShowColumnHeaders = true; this.gridGroupingControl1.ChildGroupOptions.ShowStackedHeaders = true; this.gridGroupingControl1.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.gridGroupingControl1.ForeColor = System.Drawing.Color.MidnightBlue; this.gridGroupingControl1.FreezeCaption = false; this.gridGroupingControl1.GridOfficeScrollBars = Syncfusion.Windows.Forms.OfficeScrollBars.Metro; this.gridGroupingControl1.GridVisualStyles = Syncfusion.Windows.Forms.GridVisualStyles.Metro; this.gridGroupingControl1.TableOptions.DefaultColumnWidth = 40; this.gridGroupingControl1.Location = new System.Drawing.Point(9, 2); this.gridGroupingControl1.Name = "gridGroupingControl1"; this.gridGroupingControl1.NestedTableGroupOptions.ShowAddNewRecordBeforeDetails = false; this.gridGroupingControl1.ShowGroupDropArea = true; this.gridGroupingControl1.Size = new System.Drawing.Size(655, 649); this.gridGroupingControl1.TabIndex = 0; this.gridGroupingControl1.TableDescriptor.AllowNew = false; this.gridGroupingControl1.TableDescriptor.Appearance.AnyCell.Font.Facename = "Segoe UI"; this.gridGroupingControl1.TableDescriptor.Appearance.AnyCell.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(138)))), ((int)(((byte)(138)))), ((int)(((byte)(138))))); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.Borders.Bottom = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.Borders.Right = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(235)))), ((int)(((byte)(235)))), ((int)(((byte)(235)))))); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(138)))), ((int)(((byte)(138)))), ((int)(((byte)(138))))); this.gridGroupingControl1.TableDescriptor.Appearance.AnyRecordFieldCell.Borders.Bottom = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnyRecordFieldCell.Borders.Right = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnySummaryCell.Borders.Right = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(208)))), ((int)(((byte)(208)))), ((int)(((byte)(208))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnySummaryCell.Borders.Top = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(208)))), ((int)(((byte)(208)))), ((int)(((byte)(208))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnySummaryCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(208)))), ((int)(((byte)(208)))), ((int)(((byte)(208)))))); this.gridGroupingControl1.TableDescriptor.Appearance.ColumnHeaderCell.Font.Bold = true; this.gridGroupingControl1.TableDescriptor.Appearance.GroupCaptionCell.CellType = "ColumnHeader"; gridColumnDescriptor43.HeaderImage = null; gridColumnDescriptor43.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor43.MappingName = "OrderID"; gridColumnDescriptor43.SerializedImageArray = ""; gridColumnDescriptor44.HeaderImage = null; gridColumnDescriptor44.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor44.MappingName = "CustomerID"; gridColumnDescriptor44.SerializedImageArray = ""; gridColumnDescriptor45.HeaderImage = null; gridColumnDescriptor45.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor45.MappingName = "EmployeeID"; gridColumnDescriptor45.SerializedImageArray = ""; gridColumnDescriptor46.HeaderImage = null; gridColumnDescriptor46.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor46.MappingName = "OrderDate"; gridColumnDescriptor46.SerializedImageArray = ""; gridColumnDescriptor47.HeaderImage = null; gridColumnDescriptor47.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor47.MappingName = "RequiredDate"; gridColumnDescriptor47.SerializedImageArray = ""; gridColumnDescriptor48.HeaderImage = null; gridColumnDescriptor48.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor48.MappingName = "ShippedDate"; gridColumnDescriptor48.SerializedImageArray = ""; gridColumnDescriptor49.HeaderImage = null; gridColumnDescriptor49.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor49.MappingName = "ShipVia"; gridColumnDescriptor49.SerializedImageArray = ""; gridColumnDescriptor50.HeaderImage = null; gridColumnDescriptor50.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor50.MappingName = "Freight"; gridColumnDescriptor50.SerializedImageArray = ""; gridColumnDescriptor51.HeaderImage = null; gridColumnDescriptor51.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor51.MappingName = "ShipName"; gridColumnDescriptor51.SerializedImageArray = ""; gridColumnDescriptor52.HeaderImage = null; gridColumnDescriptor52.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor52.MappingName = "ShipAddress"; gridColumnDescriptor52.SerializedImageArray = ""; gridColumnDescriptor53.HeaderImage = null; gridColumnDescriptor53.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor53.MappingName = "ShipCity"; gridColumnDescriptor53.SerializedImageArray = ""; gridColumnDescriptor54.HeaderImage = null; gridColumnDescriptor54.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor54.MappingName = "ShipRegion"; gridColumnDescriptor54.SerializedImageArray = ""; gridColumnDescriptor55.HeaderImage = null; gridColumnDescriptor55.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor55.MappingName = "ShipPostalCode"; gridColumnDescriptor55.SerializedImageArray = ""; gridColumnDescriptor56.HeaderImage = null; gridColumnDescriptor56.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor56.MappingName = "ShipCountry"; gridColumnDescriptor56.SerializedImageArray = ""; this.gridGroupingControl1.TableDescriptor.Columns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor[] { gridColumnDescriptor43, gridColumnDescriptor44, gridColumnDescriptor45, gridColumnDescriptor46, gridColumnDescriptor47, gridColumnDescriptor48, gridColumnDescriptor49, gridColumnDescriptor50, gridColumnDescriptor51, gridColumnDescriptor52, gridColumnDescriptor53, gridColumnDescriptor54, gridColumnDescriptor55, gridColumnDescriptor56 }); this.gridGroupingControl1.TableDescriptor.PrimaryKeyColumns.AddRange(new Syncfusion.Grouping.SortColumnDescriptor[] { new Syncfusion.Grouping.SortColumnDescriptor("OrderID", System.ComponentModel.ListSortDirection.Ascending) }); gridStackedHeaderRowDescriptor4.Appearance.StackedHeaderCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))))); gridStackedHeaderDescriptor13.Appearance.StackedHeaderCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(128)))))); gridStackedHeaderDescriptor13.Appearance.StackedHeaderCell.TextColor = System.Drawing.Color.Black; gridStackedHeaderDescriptor13.HeaderText = "Header One"; gridStackedHeaderDescriptor13.Name = "StackedHeader 1"; gridStackedHeaderDescriptor13.VisibleColumns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("OrderID"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("CustomerID"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("EmployeeID") }); gridStackedHeaderDescriptor14.Appearance.StackedHeaderCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))))); gridStackedHeaderDescriptor14.HeaderText = "Header Two"; gridStackedHeaderDescriptor14.Name = "StackedHeader 2"; gridStackedHeaderDescriptor14.VisibleColumns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("OrderDate"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("Freight"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("RequiredDate") }); gridStackedHeaderDescriptor15.Appearance.StackedHeaderCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))))); gridStackedHeaderDescriptor15.HeaderText = "Header Three"; gridStackedHeaderDescriptor15.Name = "StackedHeader 3"; gridStackedHeaderDescriptor15.VisibleColumns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("ShippedDate"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("ShipVia"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("ShipName") }); gridStackedHeaderDescriptor16.Appearance.StackedHeaderCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))))); gridStackedHeaderDescriptor16.HeaderText = "Header Four"; gridStackedHeaderDescriptor16.Name = "StackedHeader 4"; gridStackedHeaderDescriptor16.VisibleColumns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("ShipAddress"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("ShipCity"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("ShipRegion"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("ShipPostalCode"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("ShipCountry") }); gridStackedHeaderRowDescriptor4.Headers.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderDescriptor[] { gridStackedHeaderDescriptor13, gridStackedHeaderDescriptor14, gridStackedHeaderDescriptor15, gridStackedHeaderDescriptor16 }); gridStackedHeaderRowDescriptor4.Name = "Row 1"; this.gridGroupingControl1.TableDescriptor.StackedHeaderRows.Add(gridStackedHeaderRowDescriptor4); this.gridGroupingControl1.TableDescriptor.SummaryRows.Add(new Syncfusion.Windows.Forms.Grid.Grouping.GridSummaryRowDescriptor("SummaryRow 1", new Syncfusion.Windows.Forms.Grid.Grouping.GridSummaryColumnDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridSummaryColumnDescriptor("FreightAverage", Syncfusion.Grouping.SummaryType.DoubleAggregate, "Freight", "{Average:###.00}") })); this.gridGroupingControl1.TableDescriptor.SummaryRows.Add(new Syncfusion.Windows.Forms.Grid.Grouping.GridSummaryRowDescriptor("SummaryRow 2", "Total", new Syncfusion.Windows.Forms.Grid.Grouping.GridSummaryColumnDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridSummaryColumnDescriptor("FreightTotal", Syncfusion.Grouping.SummaryType.DoubleAggregate, "Freight", "{Sum:###.00}") })); this.gridGroupingControl1.TableDescriptor.TableOptions.ColumnHeaderRowHeight = 25; this.gridGroupingControl1.TableDescriptor.TableOptions.RecordRowHeight = 20; this.gridGroupingControl1.TableDescriptor.VisibleColumns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("OrderID"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("CustomerID"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("EmployeeID"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("OrderDate"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("Freight"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("RequiredDate"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("ShippedDate"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("ShipVia"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("ShipName"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("ShipAddress"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("ShipCity"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("ShipRegion"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("ShipPostalCode"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("ShipCountry") }); this.gridGroupingControl1.TableOptions.GridLineBorder = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(208)))), ((int)(((byte)(215)))), ((int)(((byte)(229)))))); this.gridGroupingControl1.TopLevelGroupOptions.ShowAddNewRecordBeforeDetails = false; this.gridGroupingControl1.TopLevelGroupOptions.ShowCaption = false; // // northwindDataSet1 // this.northwindDataSet1.DataSetName = "DataSet1"; this.northwindDataSet1.Locale = new System.Globalization.CultureInfo("en-US"); this.northwindDataSet1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // checkBoxAdv1 // this.checkBoxAdv1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); this.checkBoxAdv1.BeforeTouchSize = new System.Drawing.Size(150, 21); this.checkBoxAdv1.DrawFocusRectangle = false; this.checkBoxAdv1.Location = new System.Drawing.Point(679, 13); this.checkBoxAdv1.MetroColor = System.Drawing.Color.FromArgb(((int)(((byte)(88)))), ((int)(((byte)(89)))), ((int)(((byte)(91))))); this.checkBoxAdv1.Name = "checkBoxAdv1"; this.checkBoxAdv1.Size = new System.Drawing.Size(150, 21); this.checkBoxAdv1.Style = Syncfusion.Windows.Forms.Tools.CheckBoxAdvStyle.Metro; this.checkBoxAdv1.TabIndex = 12; this.checkBoxAdv1.Text = "Enable Touch mode"; this.checkBoxAdv1.ThemesEnabled = false; this.checkBoxAdv1.CheckStateChanged += new System.EventHandler(this.checkBoxAdv1_CheckStateChanged); // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.ClientSize = new System.Drawing.Size(1012, 659); this.Controls.Add(this.checkBoxAdv1); this.Controls.Add(this.propertyGrid1); this.Controls.Add(this.gridGroupingControl1); this.MinimumSize = new System.Drawing.Size(850, 500); this.Name = "Form1"; this.Text = "Stacked Headers"; ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.northwindDataSet1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.checkBoxAdv1)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1)); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor2 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor3 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor4 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor5 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor6 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor7 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); this.dataSet12 = new TopLevelGroupOptions.DataSet1(); this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection(); this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand(); this.tipDesc = new System.Windows.Forms.ToolTip(this.components); this.gridGroupingControl1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl(); this.panel1 = new System.Windows.Forms.Panel(); this.label2 = new System.Windows.Forms.Label(); this.afterDetails = new Syncfusion.Windows.Forms.Tools.CheckBoxAdv(); this.beforeDetails = new Syncfusion.Windows.Forms.Tools.CheckBoxAdv(); this.showGroupHeader = new Syncfusion.Windows.Forms.Tools.CheckBoxAdv(); this.showGroupFooter = new Syncfusion.Windows.Forms.Tools.CheckBoxAdv(); this.showCaption = new Syncfusion.Windows.Forms.Tools.CheckBoxAdv(); this.label1 = new System.Windows.Forms.Label(); this.listView1 = new ListView(); this.columnHeader1 = new ColumnHeader(); this.columnHeader2 = new ColumnHeader(); ((System.ComponentModel.ISupportInitialize)(this.dataSet12)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).BeginInit(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.afterDetails)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.beforeDetails)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.showGroupHeader)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.showGroupFooter)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.showCaption)).BeginInit(); this.SuspendLayout(); // // dataSet12 // this.dataSet12.DataSetName = "DataSet1"; this.dataSet12.Locale = new System.Globalization.CultureInfo("en-US"); this.dataSet12.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // oleDbDataAdapter1 // this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand1; this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1; this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1; this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Statistics", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("ID", "ID"), new System.Data.Common.DataColumnMapping("losses", "losses"), new System.Data.Common.DataColumnMapping("School", "School"), new System.Data.Common.DataColumnMapping("Sport", "Sport"), new System.Data.Common.DataColumnMapping("ties", "ties"), new System.Data.Common.DataColumnMapping("wins", "wins"), new System.Data.Common.DataColumnMapping("year", "year") }) }); this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1; // // oleDbDeleteCommand1 // this.oleDbDeleteCommand1.CommandText = resources.GetString("oleDbDeleteCommand1.CommandText"); this.oleDbDeleteCommand1.Connection = this.oleDbConnection1; this.oleDbDeleteCommand1.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] { new System.Data.OleDb.OleDbParameter("Original_ID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ID", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_School", System.Data.OleDb.OleDbType.VarWChar, 255, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "School", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_School1", System.Data.OleDb.OleDbType.VarWChar, 255, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "School", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Sport", System.Data.OleDb.OleDbType.VarWChar, 255, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Sport", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Sport1", System.Data.OleDb.OleDbType.VarWChar, 255, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Sport", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_losses", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "losses", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_losses1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "losses", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_ties", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ties", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_ties1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ties", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_wins", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "wins", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_wins1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "wins", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_year", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "year", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_year1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "year", System.Data.DataRowVersion.Original, null) }); // // oleDbConnection1 // this.oleDbConnection1.ConnectionString = resources.GetString("oleDbConnection1.ConnectionString"); // // oleDbInsertCommand1 // this.oleDbInsertCommand1.CommandText = "INSERT INTO Statistics(losses, School, Sport, ties, wins, year) VALUES (?, ?, ?, " + "?, ?, ?)"; this.oleDbInsertCommand1.Connection = this.oleDbConnection1; this.oleDbInsertCommand1.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] { new System.Data.OleDb.OleDbParameter("losses", System.Data.OleDb.OleDbType.Integer, 0, "losses"), new System.Data.OleDb.OleDbParameter("School", System.Data.OleDb.OleDbType.VarWChar, 255, "School"), new System.Data.OleDb.OleDbParameter("Sport", System.Data.OleDb.OleDbType.VarWChar, 255, "Sport"), new System.Data.OleDb.OleDbParameter("ties", System.Data.OleDb.OleDbType.Integer, 0, "ties"), new System.Data.OleDb.OleDbParameter("wins", System.Data.OleDb.OleDbType.Integer, 0, "wins"), new System.Data.OleDb.OleDbParameter("year", System.Data.OleDb.OleDbType.Integer, 0, "year") }); // // oleDbSelectCommand1 // this.oleDbSelectCommand1.CommandText = "SELECT ID, losses, School, Sport, ties, wins, year FROM Statistics"; this.oleDbSelectCommand1.Connection = this.oleDbConnection1; // // oleDbUpdateCommand1 // this.oleDbUpdateCommand1.CommandText = resources.GetString("oleDbUpdateCommand1.CommandText"); this.oleDbUpdateCommand1.Connection = this.oleDbConnection1; this.oleDbUpdateCommand1.Parameters.AddRange(new System.Data.OleDb.OleDbParameter[] { new System.Data.OleDb.OleDbParameter("losses", System.Data.OleDb.OleDbType.Integer, 0, "losses"), new System.Data.OleDb.OleDbParameter("School", System.Data.OleDb.OleDbType.VarWChar, 255, "School"), new System.Data.OleDb.OleDbParameter("Sport", System.Data.OleDb.OleDbType.VarWChar, 255, "Sport"), new System.Data.OleDb.OleDbParameter("ties", System.Data.OleDb.OleDbType.Integer, 0, "ties"), new System.Data.OleDb.OleDbParameter("wins", System.Data.OleDb.OleDbType.Integer, 0, "wins"), new System.Data.OleDb.OleDbParameter("year", System.Data.OleDb.OleDbType.Integer, 0, "year"), new System.Data.OleDb.OleDbParameter("Original_ID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ID", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_School", System.Data.OleDb.OleDbType.VarWChar, 255, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "School", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_School1", System.Data.OleDb.OleDbType.VarWChar, 255, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "School", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Sport", System.Data.OleDb.OleDbType.VarWChar, 255, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Sport", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_Sport1", System.Data.OleDb.OleDbType.VarWChar, 255, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Sport", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_losses", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "losses", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_losses1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "losses", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_ties", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ties", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_ties1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ties", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_wins", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "wins", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_wins1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "wins", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_year", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "year", System.Data.DataRowVersion.Original, null), new System.Data.OleDb.OleDbParameter("Original_year1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "year", System.Data.DataRowVersion.Original, null) }); // // tipDesc // this.tipDesc.BackColor = System.Drawing.Color.White; this.tipDesc.ForeColor = System.Drawing.Color.Black; this.tipDesc.IsBalloon = true; this.tipDesc.ShowAlways = true; this.tipDesc.UseFading = false; // // gridGroupingControl1 // this.gridGroupingControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.gridGroupingControl1.BackColor = System.Drawing.SystemColors.Window; this.gridGroupingControl1.DataSource = this.dataSet12.Statistics; this.gridGroupingControl1.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.gridGroupingControl1.FreezeCaption = false; this.gridGroupingControl1.GridOfficeScrollBars = Syncfusion.Windows.Forms.OfficeScrollBars.Metro; this.gridGroupingControl1.GridVisualStyles = Syncfusion.Windows.Forms.GridVisualStyles.Metro; this.gridGroupingControl1.Location = new System.Drawing.Point(12, 3); this.gridGroupingControl1.Name = "gridGroupingControl1"; this.gridGroupingControl1.ShowGroupDropArea = true; this.gridGroupingControl1.Size = new System.Drawing.Size(778, 494); this.gridGroupingControl1.TabIndex = 0; this.gridGroupingControl1.TableDescriptor.AllowNew = false; this.gridGroupingControl1.TableDescriptor.Appearance.AnyCell.Font.Facename = "Segoe UI"; this.gridGroupingControl1.TableDescriptor.Appearance.AnyCell.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(138)))), ((int)(((byte)(138)))), ((int)(((byte)(138))))); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.Borders.Bottom = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.Borders.Right = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(235)))), ((int)(((byte)(235)))), ((int)(((byte)(235)))))); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(138)))), ((int)(((byte)(138)))), ((int)(((byte)(138))))); this.gridGroupingControl1.TableDescriptor.Appearance.AnyRecordFieldCell.Borders.Bottom = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnyRecordFieldCell.Borders.Right = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnySummaryCell.Borders.Right = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(208)))), ((int)(((byte)(208)))), ((int)(((byte)(208))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnySummaryCell.Borders.Top = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(208)))), ((int)(((byte)(208)))), ((int)(((byte)(208))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnySummaryCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(208)))), ((int)(((byte)(208)))), ((int)(((byte)(208)))))); this.gridGroupingControl1.TableDescriptor.Appearance.ColumnHeaderCell.Font.Bold = true; this.gridGroupingControl1.TableDescriptor.Appearance.GroupCaptionCell.CellType = "ColumnHeader"; gridColumnDescriptor1.HeaderImage = null; gridColumnDescriptor1.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor1.MappingName = "ID"; gridColumnDescriptor1.SerializedImageArray = ""; gridColumnDescriptor2.HeaderImage = null; gridColumnDescriptor2.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor2.MappingName = "losses"; gridColumnDescriptor2.SerializedImageArray = ""; gridColumnDescriptor3.HeaderImage = null; gridColumnDescriptor3.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor3.MappingName = "School"; gridColumnDescriptor3.SerializedImageArray = ""; gridColumnDescriptor4.HeaderImage = null; gridColumnDescriptor4.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor4.MappingName = "Sport"; gridColumnDescriptor4.SerializedImageArray = ""; gridColumnDescriptor5.HeaderImage = null; gridColumnDescriptor5.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor5.MappingName = "ties"; gridColumnDescriptor5.SerializedImageArray = ""; gridColumnDescriptor6.HeaderImage = null; gridColumnDescriptor6.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor6.MappingName = "wins"; gridColumnDescriptor6.SerializedImageArray = ""; gridColumnDescriptor7.HeaderImage = null; gridColumnDescriptor7.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor7.MappingName = "year"; gridColumnDescriptor7.SerializedImageArray = ""; this.gridGroupingControl1.TableDescriptor.Columns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor[] { gridColumnDescriptor1, gridColumnDescriptor2, gridColumnDescriptor3, gridColumnDescriptor4, gridColumnDescriptor5, gridColumnDescriptor6, gridColumnDescriptor7 }); this.gridGroupingControl1.TableDescriptor.PrimaryKeyColumns.AddRange(new Syncfusion.Grouping.SortColumnDescriptor[] { new Syncfusion.Grouping.SortColumnDescriptor("ID", System.ComponentModel.ListSortDirection.Ascending) }); this.gridGroupingControl1.TableDescriptor.TableOptions.ColumnHeaderRowHeight = 25; this.gridGroupingControl1.TableDescriptor.TableOptions.RecordRowHeight = 20; this.gridGroupingControl1.TableDescriptor.VisibleColumns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("ID"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("losses"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("School"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("Sport"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("ties"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("wins"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("year") }); this.gridGroupingControl1.Text = "gridGroupingControl1"; this.gridGroupingControl1.VersionInfo = "4.201.0.37"; // // panel1 // this.panel1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Right))); this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; this.panel1.Controls.Add(this.label2); this.panel1.Controls.Add(this.afterDetails); this.panel1.Controls.Add(this.beforeDetails); this.panel1.Controls.Add(this.showGroupHeader); this.panel1.Controls.Add(this.showGroupFooter); this.panel1.Controls.Add(this.showCaption); this.panel1.Controls.Add(this.label1); this.panel1.ForeColor = System.Drawing.Color.DimGray; this.panel1.Location = new System.Drawing.Point(798, 3); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(208, 494); this.panel1.TabIndex = 8; // // label2 // this.label2.Font = new System.Drawing.Font("Segoe UI", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.label2.Location = new System.Drawing.Point(29, 184); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(160, 23); this.label2.TabIndex = 15; this.label2.Text = "AddNewRecordField"; // // afterDetails // this.afterDetails.BeforeTouchSize = new System.Drawing.Size(136, 24); this.afterDetails.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.afterDetails.Location = new System.Drawing.Point(37, 248); this.afterDetails.MetroColor = System.Drawing.Color.FromArgb(((int)(((byte)(27)))), ((int)(((byte)(161)))), ((int)(((byte)(226))))); this.afterDetails.Name = "afterDetails"; this.afterDetails.Size = new System.Drawing.Size(136, 24); this.afterDetails.Style = Syncfusion.Windows.Forms.Tools.CheckBoxAdvStyle.Metro; this.afterDetails.DrawFocusRectangle = true; this.afterDetails.TabIndex = 14; this.afterDetails.Text = "After Details"; this.afterDetails.ThemesEnabled = false; this.afterDetails.CheckedChanged += new System.EventHandler(this.afterDetails_CheckedChanged); // // beforeDetails // this.beforeDetails.BeforeTouchSize = new System.Drawing.Size(136, 26); this.beforeDetails.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.beforeDetails.Location = new System.Drawing.Point(37, 216); this.beforeDetails.MetroColor = System.Drawing.Color.FromArgb(((int)(((byte)(27)))), ((int)(((byte)(161)))), ((int)(((byte)(226))))); this.beforeDetails.Name = "beforeDetails"; this.beforeDetails.Size = new System.Drawing.Size(136, 26); this.beforeDetails.Style = Syncfusion.Windows.Forms.Tools.CheckBoxAdvStyle.Metro; this.beforeDetails.DrawFocusRectangle = true; this.beforeDetails.TabIndex = 13; this.beforeDetails.Text = "Before Details"; this.beforeDetails.ThemesEnabled = false; this.beforeDetails.CheckedChanged += new System.EventHandler(this.beforeDetails_CheckedChanged); // // showGroupHeader // this.showGroupHeader.BeforeTouchSize = new System.Drawing.Size(152, 22); this.showGroupHeader.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.showGroupHeader.Location = new System.Drawing.Point(37, 136); this.showGroupHeader.MetroColor = System.Drawing.Color.FromArgb(((int)(((byte)(27)))), ((int)(((byte)(161)))), ((int)(((byte)(226))))); this.showGroupHeader.Name = "showGroupHeader"; this.showGroupHeader.Size = new System.Drawing.Size(152, 22); this.showGroupHeader.Style = Syncfusion.Windows.Forms.Tools.CheckBoxAdvStyle.Metro; this.showGroupHeader.DrawFocusRectangle = true; this.showGroupHeader.TabIndex = 12; this.showGroupHeader.Text = "ShowGroupHeader"; this.showGroupHeader.ThemesEnabled = false; this.showGroupHeader.CheckedChanged += new System.EventHandler(this.showGroupHeader_CheckedChanged); // // showGroupFooter // this.showGroupFooter.BeforeTouchSize = new System.Drawing.Size(152, 26); this.showGroupFooter.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.showGroupFooter.Location = new System.Drawing.Point(37, 104); this.showGroupFooter.MetroColor = System.Drawing.Color.FromArgb(((int)(((byte)(27)))), ((int)(((byte)(161)))), ((int)(((byte)(226))))); this.showGroupFooter.Name = "showGroupFooter"; this.showGroupFooter.Size = new System.Drawing.Size(152, 26); this.showGroupFooter.Style = Syncfusion.Windows.Forms.Tools.CheckBoxAdvStyle.Metro; this.showGroupFooter.DrawFocusRectangle = true; this.showGroupFooter.TabIndex = 11; this.showGroupFooter.Text = "ShowGroupFooter"; this.showGroupFooter.ThemesEnabled = false; this.showGroupFooter.CheckedChanged += new System.EventHandler(this.showGroupFooter_CheckedChanged); // // showCaption // this.showCaption.BeforeTouchSize = new System.Drawing.Size(150, 21); this.showCaption.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.showCaption.Location = new System.Drawing.Point(37, 72); this.showCaption.MetroColor = System.Drawing.Color.FromArgb(((int)(((byte)(27)))), ((int)(((byte)(161)))), ((int)(((byte)(226))))); this.showCaption.Name = "showCaption"; this.showCaption.Size = new System.Drawing.Size(136, 26); this.showCaption.Style = Syncfusion.Windows.Forms.Tools.CheckBoxAdvStyle.Metro; this.showCaption.DrawFocusRectangle = true; this.showCaption.TabIndex = 10; this.showCaption.Text = "ShowCaption"; this.showCaption.ThemesEnabled = false; this.showCaption.CheckedChanged += new System.EventHandler(this.showCaption_CheckedChanged); // // label1 // this.label1.Font = new System.Drawing.Font("Segoe UI", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.label1.Location = new System.Drawing.Point(24, 32); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(165, 23); this.label1.TabIndex = 9; this.label1.Text = "TopLevelGroupOptions"; // // listView1 // this.listView1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.listView1.Columns.AddRange(new System.Windows.Forms.ColumnHeader[] { this.columnHeader1, this.columnHeader2 }); this.listView1.Font = new System.Drawing.Font("Segoe UI", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.listView1.ForeColor = System.Drawing.Color.DimGray; this.listView1.Location = new System.Drawing.Point(10, 509); this.listView1.Name = "listView1"; this.listView1.Size = new System.Drawing.Size(994, 142); this.listView1.TabIndex = 11; this.listView1.TabStop = false; this.listView1.UseCompatibleStateImageBehavior = false; this.listView1.View = System.Windows.Forms.View.Details; // // columnHeader1 // this.columnHeader1.Text = "Property"; this.columnHeader1.Width = 497; // // columnHeader2 // this.columnHeader2.Text = "Details"; this.columnHeader2.Width = 497; // // Form1 // this.ClientSize = new System.Drawing.Size(1012, 656); this.MinimumSize = new System.Drawing.Size(900, 500); this.Controls.Add(this.gridGroupingControl1); this.Controls.Add(this.panel1); this.Controls.Add(this.listView1); this.Name = "Form1"; this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; this.Text = "Top-Level-Group Options"; ((System.ComponentModel.ISupportInitialize)(this.dataSet12)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).EndInit(); this.panel1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.afterDetails)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.beforeDetails)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.showGroupHeader)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.showGroupFooter)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.showCaption)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor2 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor3 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor4 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor5 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor6 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor7 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor8 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor9 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridRelationDescriptor gridRelationDescriptor1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridRelationDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor10 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor11 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridRelationDescriptor gridRelationDescriptor2 = new Syncfusion.Windows.Forms.Grid.Grouping.GridRelationDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridRelationDescriptor gridRelationDescriptor3 = new Syncfusion.Windows.Forms.Grid.Grouping.GridRelationDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor12 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor13 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor14 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridRelationDescriptor gridRelationDescriptor4 = new Syncfusion.Windows.Forms.Grid.Grouping.GridRelationDescriptor(); this.gridGroupingControl1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl(); this.productRatingsDataSet2 = new ProductRatings.ProductRatingsDataSet(); this.groupBox1 = new System.Windows.Forms.GroupBox(); this.comboBoxAdv1 = new Syncfusion.Windows.Forms.Tools.ComboBoxAdv(); this.propertyGrid1 = new System.Windows.Forms.PropertyGrid(); ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.productRatingsDataSet2)).BeginInit(); this.groupBox1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.comboBoxAdv1)).BeginInit(); this.SuspendLayout(); // // gridGroupingControl1 // this.gridGroupingControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.gridGroupingControl1.BackColor = System.Drawing.SystemColors.Window; this.gridGroupingControl1.DataSource = this.productRatingsDataSet2.Products; this.gridGroupingControl1.FreezeCaption = false; this.gridGroupingControl1.Location = new System.Drawing.Point(16, 16); this.gridGroupingControl1.Name = "gridGroupingControl1"; this.gridGroupingControl1.Size = new System.Drawing.Size(772, 615); this.gridGroupingControl1.TabIndex = 0; gridColumnDescriptor1.HeaderImage = null; gridColumnDescriptor1.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor1.HeaderText = "Category ID"; gridColumnDescriptor1.MappingName = "CategoryID"; gridColumnDescriptor1.SerializedImageArray = ""; gridColumnDescriptor2.Appearance.AnyRecordFieldCell.CellType = "TextBox"; gridColumnDescriptor2.Appearance.AnyRecordFieldCell.HorizontalAlignment = Syncfusion.Windows.Forms.Grid.GridHorizontalAlignment.Left; gridColumnDescriptor2.HeaderImage = null; gridColumnDescriptor2.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor2.MappingName = "Discontinued"; gridColumnDescriptor2.SerializedImageArray = ""; gridColumnDescriptor3.HeaderImage = null; gridColumnDescriptor3.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor3.HeaderText = "Product Name"; gridColumnDescriptor3.MappingName = "ProductName"; gridColumnDescriptor3.SerializedImageArray = ""; gridColumnDescriptor4.AllowDropDownCell = true; gridColumnDescriptor4.HeaderImage = null; gridColumnDescriptor4.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor4.MappingName = "Ratings_RatingDescription_Description"; gridColumnDescriptor4.Name = "Ratings"; gridColumnDescriptor4.SerializedImageArray = ""; gridColumnDescriptor4.Width = 176; gridColumnDescriptor5.HeaderImage = null; gridColumnDescriptor5.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor5.HeaderText = "Reorder Level"; gridColumnDescriptor5.MappingName = "ReorderLevel"; gridColumnDescriptor5.SerializedImageArray = ""; gridColumnDescriptor6.HeaderImage = null; gridColumnDescriptor6.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor6.HeaderText = "Supplier"; gridColumnDescriptor6.MappingName = "Suppliers_CompanyName"; gridColumnDescriptor6.SerializedImageArray = ""; gridColumnDescriptor7.HeaderImage = null; gridColumnDescriptor7.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor7.HeaderText = "Unit Price"; gridColumnDescriptor7.MappingName = "UnitPrice"; gridColumnDescriptor7.SerializedImageArray = ""; gridColumnDescriptor8.HeaderImage = null; gridColumnDescriptor8.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor8.HeaderText = "Units In Stock"; gridColumnDescriptor8.MappingName = "UnitsInStock"; gridColumnDescriptor8.SerializedImageArray = ""; gridColumnDescriptor9.HeaderImage = null; gridColumnDescriptor9.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor9.HeaderText = "Units On Order"; gridColumnDescriptor9.MappingName = "UnitsOnOrder"; gridColumnDescriptor9.SerializedImageArray = ""; this.gridGroupingControl1.TableDescriptor.Columns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor[] { gridColumnDescriptor1, gridColumnDescriptor2, gridColumnDescriptor3, gridColumnDescriptor4, gridColumnDescriptor5, gridColumnDescriptor6, gridColumnDescriptor7, gridColumnDescriptor8, gridColumnDescriptor9 }); gridColumnDescriptor10.HeaderImage = null; gridColumnDescriptor10.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor10.HeaderText = "Customer"; gridColumnDescriptor10.MappingName = "Customers_CompanyName"; gridColumnDescriptor10.SerializedImageArray = ""; gridColumnDescriptor11.HeaderImage = null; gridColumnDescriptor11.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor11.HeaderText = "Rating"; gridColumnDescriptor11.MappingName = "RatingDescription_Description"; gridColumnDescriptor11.SerializedImageArray = ""; gridRelationDescriptor1.ChildTableDescriptor.Columns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor[] { gridColumnDescriptor10, gridColumnDescriptor11 }); gridRelationDescriptor2.MappingName = "RatingDescriptionRatings"; gridColumnDescriptor12.HeaderImage = null; gridColumnDescriptor12.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor12.MappingName = "CustomerID"; gridColumnDescriptor12.SerializedImageArray = ""; gridColumnDescriptor13.HeaderImage = null; gridColumnDescriptor13.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor13.MappingName = "City"; gridColumnDescriptor13.SerializedImageArray = ""; gridColumnDescriptor14.HeaderImage = null; gridColumnDescriptor14.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor14.MappingName = "CompanyName"; gridColumnDescriptor14.SerializedImageArray = ""; gridRelationDescriptor3.ChildTableDescriptor.Columns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor[] { gridColumnDescriptor12, gridColumnDescriptor13, gridColumnDescriptor14 }); gridRelationDescriptor3.MappingName = "CustomersRatings"; gridRelationDescriptor1.ChildTableDescriptor.Relations.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridRelationDescriptor[] { gridRelationDescriptor2, gridRelationDescriptor3 }); gridRelationDescriptor1.MappingName = "ProductsRatings"; gridRelationDescriptor1.RelationKind = Syncfusion.Grouping.RelationKind.ForeignKeyKeyWords; gridRelationDescriptor4.MappingName = "SuppliersProducts"; this.gridGroupingControl1.TableDescriptor.Relations.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridRelationDescriptor[] { gridRelationDescriptor1, gridRelationDescriptor4 }); this.gridGroupingControl1.TableDescriptor.SortedColumns.AddRange(new Syncfusion.Grouping.SortColumnDescriptor[] { new Syncfusion.Grouping.SortColumnDescriptor("Ratings", System.ComponentModel.ListSortDirection.Ascending) }); this.gridGroupingControl1.Text = "gridGroupingControl1"; // // productRatingsDataSet2 // this.productRatingsDataSet2.DataSetName = "ProductRatingsDataSet"; this.productRatingsDataSet2.Locale = new System.Globalization.CultureInfo("en-US"); this.productRatingsDataSet2.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // groupBox1 // this.groupBox1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); this.groupBox1.Controls.Add(this.comboBoxAdv1); this.groupBox1.Font = new System.Drawing.Font("Segoe UI", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.groupBox1.Location = new System.Drawing.Point(810, 16); this.groupBox1.Name = "groupBox1"; this.groupBox1.Size = new System.Drawing.Size(188, 68); this.groupBox1.TabIndex = 1; this.groupBox1.TabStop = false; this.groupBox1.Text = "Group By"; // // comboBoxAdv1 // this.comboBoxAdv1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); this.comboBoxAdv1.BackColor = System.Drawing.Color.White; this.comboBoxAdv1.BeforeTouchSize = new System.Drawing.Size(166, 21); this.comboBoxAdv1.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.comboBoxAdv1.Items.AddRange(new object[] { "None", "Discontinued", "Supplier", "Ratings" }); this.comboBoxAdv1.ItemsImageIndexes.Add(new Syncfusion.Windows.Forms.Tools.ComboBoxAdv.ImageIndexItem(this.comboBoxAdv1, "None")); this.comboBoxAdv1.ItemsImageIndexes.Add(new Syncfusion.Windows.Forms.Tools.ComboBoxAdv.ImageIndexItem(this.comboBoxAdv1, "Discontinued")); this.comboBoxAdv1.ItemsImageIndexes.Add(new Syncfusion.Windows.Forms.Tools.ComboBoxAdv.ImageIndexItem(this.comboBoxAdv1, "Supplier")); this.comboBoxAdv1.ItemsImageIndexes.Add(new Syncfusion.Windows.Forms.Tools.ComboBoxAdv.ImageIndexItem(this.comboBoxAdv1, "Ratings")); this.comboBoxAdv1.Location = new System.Drawing.Point(9, 32); this.comboBoxAdv1.MetroColor = System.Drawing.Color.FromArgb(((int)(((byte)(27)))), ((int)(((byte)(161)))), ((int)(((byte)(226))))); this.comboBoxAdv1.Name = "comboBoxAdv1"; this.comboBoxAdv1.Size = new System.Drawing.Size(166, 21); this.comboBoxAdv1.Style = Syncfusion.Windows.Forms.VisualStyle.Metro; this.comboBoxAdv1.TabIndex = 1; // // propertyGrid1 // this.propertyGrid1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Right))); this.propertyGrid1.BackColor = System.Drawing.Color.White; this.propertyGrid1.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.propertyGrid1.HelpBackColor = System.Drawing.Color.White; this.propertyGrid1.LineColor = System.Drawing.Color.White; this.propertyGrid1.Location = new System.Drawing.Point(810, 99); this.propertyGrid1.Name = "propertyGrid1"; this.propertyGrid1.Size = new System.Drawing.Size(188, 532); this.propertyGrid1.TabIndex = 2; // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(1012, 653); this.Controls.Add(this.propertyGrid1); this.Controls.Add(this.groupBox1); this.Controls.Add(this.gridGroupingControl1); this.MinimumSize = new System.Drawing.Size(800, 500); this.Name = "Form1"; this.Text = "Product Ratings "; ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.productRatingsDataSet2)).EndInit(); this.groupBox1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.comboBoxAdv1)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor2 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor3 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor4 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor5 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor6 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor7 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor8 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor9 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor10 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor11 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor12 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor13 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor14 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); this.northwindDataSet1 = new SummaryInCaption.DataSet1(); this.gridGroupingControl1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlConnection2 = new System.Data.SqlClient.SqlConnection(); this.sqlInsertCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlUpdateCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlDeleteCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlDataAdapterOrders = new System.Data.SqlClient.SqlDataAdapter(); this.propertyGrid1 = new System.Windows.Forms.PropertyGrid(); this.panel2 = new System.Windows.Forms.Panel(); ((System.ComponentModel.ISupportInitialize)(this.northwindDataSet1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).BeginInit(); this.SuspendLayout(); // // northwindDataSet1 // this.northwindDataSet1.DataSetName = "DataSet1"; this.northwindDataSet1.Locale = new System.Globalization.CultureInfo("en-US"); this.northwindDataSet1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // gridGroupingControl1 // this.gridGroupingControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.gridGroupingControl1.BackColor = System.Drawing.SystemColors.Window; this.gridGroupingControl1.DataSource = this.northwindDataSet1.Orders; this.gridGroupingControl1.FreezeCaption = false; this.gridGroupingControl1.GridOfficeScrollBars = Syncfusion.Windows.Forms.OfficeScrollBars.Metro; this.gridGroupingControl1.GridVisualStyles = Syncfusion.Windows.Forms.GridVisualStyles.Metro; this.gridGroupingControl1.Location = new System.Drawing.Point(12, 9); this.gridGroupingControl1.Name = "gridGroupingControl1"; this.gridGroupingControl1.ShowGroupDropArea = true; this.gridGroupingControl1.Size = new System.Drawing.Size(725, 634); this.gridGroupingControl1.TabIndex = 0; this.gridGroupingControl1.TableDescriptor.AllowNew = false; this.gridGroupingControl1.TableDescriptor.Appearance.AnyCell.Font.Facename = "Segoe UI"; this.gridGroupingControl1.TableDescriptor.Appearance.AnyCell.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(138)))), ((int)(((byte)(138)))), ((int)(((byte)(138))))); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.Borders.Bottom = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.Borders.Right = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(235)))), ((int)(((byte)(235)))), ((int)(((byte)(235)))))); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(138)))), ((int)(((byte)(138)))), ((int)(((byte)(138))))); this.gridGroupingControl1.TableDescriptor.Appearance.AnyRecordFieldCell.Borders.Bottom = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnyRecordFieldCell.Borders.Right = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnySummaryCell.Borders.Right = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(208)))), ((int)(((byte)(208)))), ((int)(((byte)(208))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnySummaryCell.Borders.Top = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(208)))), ((int)(((byte)(208)))), ((int)(((byte)(208))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnySummaryCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(208)))), ((int)(((byte)(208)))), ((int)(((byte)(208)))))); this.gridGroupingControl1.TableDescriptor.Appearance.ColumnHeaderCell.Font.Bold = true; this.gridGroupingControl1.TableDescriptor.Appearance.GroupCaptionCell.CellType = "ColumnHeader"; gridColumnDescriptor1.HeaderImage = null; gridColumnDescriptor1.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor1.MappingName = "OrderID"; gridColumnDescriptor1.SerializedImageArray = ""; gridColumnDescriptor2.HeaderImage = null; gridColumnDescriptor2.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor2.MappingName = "CustomerID"; gridColumnDescriptor2.SerializedImageArray = ""; gridColumnDescriptor3.HeaderImage = null; gridColumnDescriptor3.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor3.MappingName = "EmployeeID"; gridColumnDescriptor3.SerializedImageArray = ""; gridColumnDescriptor4.HeaderImage = null; gridColumnDescriptor4.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor4.HeaderText = "Order Date"; gridColumnDescriptor4.MappingName = "OrderDate"; gridColumnDescriptor4.SerializedImageArray = ""; gridColumnDescriptor5.HeaderImage = null; gridColumnDescriptor5.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor5.HeaderText = "Required Date"; gridColumnDescriptor5.MappingName = "RequiredDate"; gridColumnDescriptor5.SerializedImageArray = ""; gridColumnDescriptor6.HeaderImage = null; gridColumnDescriptor6.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor6.HeaderText = "Shipped Date"; gridColumnDescriptor6.MappingName = "ShippedDate"; gridColumnDescriptor6.SerializedImageArray = ""; gridColumnDescriptor7.HeaderImage = null; gridColumnDescriptor7.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor7.MappingName = "ShipVia"; gridColumnDescriptor7.SerializedImageArray = ""; gridColumnDescriptor8.HeaderImage = null; gridColumnDescriptor8.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor8.MappingName = "Freight"; gridColumnDescriptor8.SerializedImageArray = ""; gridColumnDescriptor9.HeaderImage = null; gridColumnDescriptor9.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor9.HeaderText = "Ship Name"; gridColumnDescriptor9.MappingName = "ShipName"; gridColumnDescriptor9.SerializedImageArray = ""; gridColumnDescriptor10.HeaderImage = null; gridColumnDescriptor10.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor10.HeaderText = "Ship Address"; gridColumnDescriptor10.MappingName = "ShipAddress"; gridColumnDescriptor10.SerializedImageArray = ""; gridColumnDescriptor11.HeaderImage = null; gridColumnDescriptor11.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor11.HeaderText = "Ship City"; gridColumnDescriptor11.MappingName = "ShipCity"; gridColumnDescriptor11.SerializedImageArray = ""; gridColumnDescriptor12.HeaderImage = null; gridColumnDescriptor12.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor12.HeaderText = "Ship Region"; gridColumnDescriptor12.MappingName = "ShipRegion"; gridColumnDescriptor12.SerializedImageArray = ""; gridColumnDescriptor13.HeaderImage = null; gridColumnDescriptor13.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor13.HeaderText = "Ship Postal Code"; gridColumnDescriptor13.MappingName = "ShipPostalCode"; gridColumnDescriptor13.SerializedImageArray = ""; gridColumnDescriptor14.HeaderImage = null; gridColumnDescriptor14.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor14.HeaderText = "Ship Country"; gridColumnDescriptor14.MappingName = "ShipCountry"; gridColumnDescriptor14.SerializedImageArray = ""; this.gridGroupingControl1.TableDescriptor.Columns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor[] { gridColumnDescriptor1, gridColumnDescriptor2, gridColumnDescriptor3, gridColumnDescriptor4, gridColumnDescriptor5, gridColumnDescriptor6, gridColumnDescriptor7, gridColumnDescriptor8, gridColumnDescriptor9, gridColumnDescriptor10, gridColumnDescriptor11, gridColumnDescriptor12, gridColumnDescriptor13, gridColumnDescriptor14 }); this.gridGroupingControl1.TableDescriptor.TableOptions.ColumnHeaderRowHeight = 30; this.gridGroupingControl1.TableDescriptor.TableOptions.RecordRowHeight = 22; // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = "SELECT OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, Shi" + "pVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, Ship" + "Country FROM Orders"; this.sqlSelectCommand2.Connection = this.sqlConnection2; // // sqlConnection2 // this.sqlConnection2.ConnectionString = "Network Address=66.135.59.108,49489;initial catalog=NORTHWIND;password=Sync_sampl" + "es;persist security info=True;user id=sa;packet size=4096;Pooling=true"; this.sqlConnection2.FireInfoMessageEventOnUserErrors = false; // // sqlInsertCommand2 // this.sqlInsertCommand2.Connection = this.sqlConnection2; this.sqlInsertCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@CustomerID", System.Data.SqlDbType.NVarChar, 5, "CustomerID"), new System.Data.SqlClient.SqlParameter("@EmployeeID", System.Data.SqlDbType.Int, 4, "EmployeeID"), new System.Data.SqlClient.SqlParameter("@OrderDate", System.Data.SqlDbType.DateTime, 8, "OrderDate"), new System.Data.SqlClient.SqlParameter("@RequiredDate", System.Data.SqlDbType.DateTime, 8, "RequiredDate"), new System.Data.SqlClient.SqlParameter("@ShippedDate", System.Data.SqlDbType.DateTime, 8, "ShippedDate"), new System.Data.SqlClient.SqlParameter("@ShipVia", System.Data.SqlDbType.Int, 4, "ShipVia"), new System.Data.SqlClient.SqlParameter("@Freight", System.Data.SqlDbType.Money, 8, "Freight"), new System.Data.SqlClient.SqlParameter("@ShipName", System.Data.SqlDbType.NVarChar, 40, "ShipName"), new System.Data.SqlClient.SqlParameter("@ShipAddress", System.Data.SqlDbType.NVarChar, 60, "ShipAddress"), new System.Data.SqlClient.SqlParameter("@ShipCity", System.Data.SqlDbType.NVarChar, 15, "ShipCity"), new System.Data.SqlClient.SqlParameter("@ShipRegion", System.Data.SqlDbType.NVarChar, 15, "ShipRegion"), new System.Data.SqlClient.SqlParameter("@ShipPostalCode", System.Data.SqlDbType.NVarChar, 10, "ShipPostalCode"), new System.Data.SqlClient.SqlParameter("@ShipCountry", System.Data.SqlDbType.NVarChar, 15, "ShipCountry") }); // // sqlUpdateCommand2 // this.sqlUpdateCommand2.Connection = this.sqlConnection2; this.sqlUpdateCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@CustomerID", System.Data.SqlDbType.NVarChar, 5, "CustomerID"), new System.Data.SqlClient.SqlParameter("@EmployeeID", System.Data.SqlDbType.Int, 4, "EmployeeID"), new System.Data.SqlClient.SqlParameter("@OrderDate", System.Data.SqlDbType.DateTime, 8, "OrderDate"), new System.Data.SqlClient.SqlParameter("@RequiredDate", System.Data.SqlDbType.DateTime, 8, "RequiredDate"), new System.Data.SqlClient.SqlParameter("@ShippedDate", System.Data.SqlDbType.DateTime, 8, "ShippedDate"), new System.Data.SqlClient.SqlParameter("@ShipVia", System.Data.SqlDbType.Int, 4, "ShipVia"), new System.Data.SqlClient.SqlParameter("@Freight", System.Data.SqlDbType.Money, 8, "Freight"), new System.Data.SqlClient.SqlParameter("@ShipName", System.Data.SqlDbType.NVarChar, 40, "ShipName"), new System.Data.SqlClient.SqlParameter("@ShipAddress", System.Data.SqlDbType.NVarChar, 60, "ShipAddress"), new System.Data.SqlClient.SqlParameter("@ShipCity", System.Data.SqlDbType.NVarChar, 15, "ShipCity"), new System.Data.SqlClient.SqlParameter("@ShipRegion", System.Data.SqlDbType.NVarChar, 15, "ShipRegion"), new System.Data.SqlClient.SqlParameter("@ShipPostalCode", System.Data.SqlDbType.NVarChar, 10, "ShipPostalCode"), new System.Data.SqlClient.SqlParameter("@ShipCountry", System.Data.SqlDbType.NVarChar, 15, "ShipCountry"), new System.Data.SqlClient.SqlParameter("@Original_OrderID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "OrderID", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_CustomerID", System.Data.SqlDbType.NVarChar, 5, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "CustomerID", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_EmployeeID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "EmployeeID", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Freight", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Freight", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_OrderDate", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "OrderDate", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_RequiredDate", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RequiredDate", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ShipAddress", System.Data.SqlDbType.NVarChar, 60, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ShipAddress", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ShipCity", System.Data.SqlDbType.NVarChar, 15, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ShipCity", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ShipCountry", System.Data.SqlDbType.NVarChar, 15, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ShipCountry", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ShipName", System.Data.SqlDbType.NVarChar, 40, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ShipName", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ShipPostalCode", System.Data.SqlDbType.NVarChar, 10, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ShipPostalCode", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ShipRegion", System.Data.SqlDbType.NVarChar, 15, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ShipRegion", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ShipVia", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ShipVia", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ShippedDate", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ShippedDate", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@OrderID", System.Data.SqlDbType.Int, 4, "OrderID") }); // // sqlDeleteCommand2 // this.sqlDeleteCommand2.Connection = this.sqlConnection2; this.sqlDeleteCommand2.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Original_OrderID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "OrderID", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_CustomerID", System.Data.SqlDbType.NVarChar, 5, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "CustomerID", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_EmployeeID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "EmployeeID", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_Freight", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "Freight", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_OrderDate", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "OrderDate", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_RequiredDate", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "RequiredDate", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ShipAddress", System.Data.SqlDbType.NVarChar, 60, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ShipAddress", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ShipCity", System.Data.SqlDbType.NVarChar, 15, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ShipCity", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ShipCountry", System.Data.SqlDbType.NVarChar, 15, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ShipCountry", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ShipName", System.Data.SqlDbType.NVarChar, 40, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ShipName", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ShipPostalCode", System.Data.SqlDbType.NVarChar, 10, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ShipPostalCode", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ShipRegion", System.Data.SqlDbType.NVarChar, 15, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ShipRegion", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ShipVia", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ShipVia", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_ShippedDate", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ShippedDate", System.Data.DataRowVersion.Original, null) }); // // sqlDataAdapterOrders // this.sqlDataAdapterOrders.DeleteCommand = this.sqlDeleteCommand2; this.sqlDataAdapterOrders.InsertCommand = this.sqlInsertCommand2; this.sqlDataAdapterOrders.SelectCommand = this.sqlSelectCommand2; this.sqlDataAdapterOrders.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Orders", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("OrderID", "OrderID"), new System.Data.Common.DataColumnMapping("CustomerID", "CustomerID"), new System.Data.Common.DataColumnMapping("EmployeeID", "EmployeeID"), new System.Data.Common.DataColumnMapping("OrderDate", "OrderDate"), new System.Data.Common.DataColumnMapping("RequiredDate", "RequiredDate"), new System.Data.Common.DataColumnMapping("ShippedDate", "ShippedDate"), new System.Data.Common.DataColumnMapping("ShipVia", "ShipVia"), new System.Data.Common.DataColumnMapping("Freight", "Freight"), new System.Data.Common.DataColumnMapping("ShipName", "ShipName"), new System.Data.Common.DataColumnMapping("ShipAddress", "ShipAddress"), new System.Data.Common.DataColumnMapping("ShipCity", "ShipCity"), new System.Data.Common.DataColumnMapping("ShipRegion", "ShipRegion"), new System.Data.Common.DataColumnMapping("ShipPostalCode", "ShipPostalCode"), new System.Data.Common.DataColumnMapping("ShipCountry", "ShipCountry") }) }); this.sqlDataAdapterOrders.UpdateCommand = this.sqlUpdateCommand2; // // propertyGrid1 // this.propertyGrid1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Right))); this.propertyGrid1.BackColor = System.Drawing.Color.White; this.propertyGrid1.CommandsBackColor = System.Drawing.Color.White; this.propertyGrid1.CommandsDisabledLinkColor = System.Drawing.Color.White; this.propertyGrid1.HelpBackColor = System.Drawing.Color.White; this.propertyGrid1.LineColor = System.Drawing.Color.White; this.propertyGrid1.Location = new System.Drawing.Point(749, 14); this.propertyGrid1.Name = "propertyGrid1"; this.propertyGrid1.SelectedObject = this.gridGroupingControl1; this.propertyGrid1.Size = new System.Drawing.Size(252, 629); this.propertyGrid1.TabIndex = 12; // // panel2 // this.panel2.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Right))); this.panel2.BackColor = System.Drawing.Color.LightGray; this.panel2.Location = new System.Drawing.Point(742, 22); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(1, 609); this.panel2.TabIndex = 13; // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.ClientSize = new System.Drawing.Size(1012, 656); this.Controls.Add(this.panel2); this.Controls.Add(this.propertyGrid1); this.Controls.Add(this.gridGroupingControl1); this.MinimumSize = new System.Drawing.Size(800, 400); this.Name = "Form1"; this.Text = "Sort by Summary"; ((System.ComponentModel.ISupportInitialize)(this.northwindDataSet1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor2 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor3 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor4 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor5 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor6 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor7 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridRelationDescriptor gridRelationDescriptor1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridRelationDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor8 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor9 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor10 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor11 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor12 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor13 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderRowDescriptor gridStackedHeaderRowDescriptor1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderRowDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderDescriptor gridStackedHeaderDescriptor1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderDescriptor gridStackedHeaderDescriptor2 = new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderDescriptor gridStackedHeaderDescriptor3 = new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderDescriptor gridStackedHeaderDescriptor4 = new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderDescriptor gridStackedHeaderDescriptor5 = new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderDescriptor(); this.gridGroupingControl1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl(); this.dataset11 = new GroupingEvents.Dataset1(); this.contextMenu1 = new System.Windows.Forms.ContextMenu(); this.menuItem1 = new System.Windows.Forms.MenuItem(); this.panel1 = new System.Windows.Forms.Panel(); this.button1 = new Syncfusion.Windows.Forms.ButtonAdv(); this.label1 = new System.Windows.Forms.Label(); this.label2 = new System.Windows.Forms.Label(); this.listView1 = new System.Windows.Forms.ListView(); this.columnHeader1 = ((System.Windows.Forms.ColumnHeader)(new System.Windows.Forms.ColumnHeader())); this.columnHeader2 = ((System.Windows.Forms.ColumnHeader)(new System.Windows.Forms.ColumnHeader())); this.freezeCaptioncheckBoxAdv = new Syncfusion.Windows.Forms.Tools.CheckBoxAdv(); ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dataset11)).BeginInit(); this.panel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.freezeCaptioncheckBoxAdv)).BeginInit(); this.SuspendLayout(); // // gridGroupingControl1 // this.gridGroupingControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.gridGroupingControl1.BackColor = System.Drawing.SystemColors.Window; this.gridGroupingControl1.ChildGroupOptions.ShowAddNewRecordBeforeDetails = false; this.gridGroupingControl1.DataMember = "Employees"; this.gridGroupingControl1.DataSource = this.dataset11; this.gridGroupingControl1.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.gridGroupingControl1.FreezeCaption = false; this.gridGroupingControl1.Location = new System.Drawing.Point(2, 0); this.gridGroupingControl1.Name = "gridGroupingControl1"; this.gridGroupingControl1.NestedTableGroupOptions.ShowAddNewRecordBeforeDetails = false; this.gridGroupingControl1.ShowGroupDropArea = true; this.gridGroupingControl1.Size = new System.Drawing.Size(883, 355); this.gridGroupingControl1.TabIndex = 0; gridColumnDescriptor1.HeaderImage = null; gridColumnDescriptor1.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor1.HeaderText = "Employee ID"; gridColumnDescriptor1.MappingName = "EmployeeID"; gridColumnDescriptor1.SerializedImageArray = ""; gridColumnDescriptor2.HeaderImage = null; gridColumnDescriptor2.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor2.HeaderText = "First Name"; gridColumnDescriptor2.MappingName = "FirstName"; gridColumnDescriptor2.SerializedImageArray = ""; gridColumnDescriptor3.HeaderImage = null; gridColumnDescriptor3.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor3.HeaderText = "Last Name"; gridColumnDescriptor3.MappingName = "LastName"; gridColumnDescriptor3.SerializedImageArray = ""; gridColumnDescriptor4.HeaderImage = null; gridColumnDescriptor4.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor4.MappingName = "Title"; gridColumnDescriptor4.SerializedImageArray = ""; gridColumnDescriptor5.HeaderImage = null; gridColumnDescriptor5.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor5.MappingName = "Address"; gridColumnDescriptor5.SerializedImageArray = ""; gridColumnDescriptor6.HeaderImage = null; gridColumnDescriptor6.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor6.MappingName = "City"; gridColumnDescriptor6.SerializedImageArray = ""; gridColumnDescriptor7.HeaderImage = null; gridColumnDescriptor7.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor7.MappingName = "Country"; gridColumnDescriptor7.SerializedImageArray = ""; this.gridGroupingControl1.TableDescriptor.Columns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor[] { gridColumnDescriptor1, gridColumnDescriptor2, gridColumnDescriptor3, gridColumnDescriptor4, gridColumnDescriptor5, gridColumnDescriptor6, gridColumnDescriptor7 }); gridColumnDescriptor8.HeaderImage = null; gridColumnDescriptor8.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor8.HeaderText = "Customer ID"; gridColumnDescriptor8.MappingName = "CustomerID"; gridColumnDescriptor8.SerializedImageArray = ""; gridColumnDescriptor9.HeaderImage = null; gridColumnDescriptor9.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor9.HeaderText = "Order Date"; gridColumnDescriptor9.MappingName = "OrderDate"; gridColumnDescriptor9.SerializedImageArray = ""; gridColumnDescriptor10.HeaderImage = null; gridColumnDescriptor10.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor10.HeaderText = "Order ID"; gridColumnDescriptor10.MappingName = "OrderID"; gridColumnDescriptor10.SerializedImageArray = ""; gridColumnDescriptor11.HeaderImage = null; gridColumnDescriptor11.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor11.HeaderText = "Ship Address"; gridColumnDescriptor11.MappingName = "ShipAddress"; gridColumnDescriptor11.SerializedImageArray = ""; gridColumnDescriptor12.HeaderImage = null; gridColumnDescriptor12.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor12.HeaderText = "Ship Name"; gridColumnDescriptor12.MappingName = "ShipName"; gridColumnDescriptor12.SerializedImageArray = ""; gridColumnDescriptor13.HeaderImage = null; gridColumnDescriptor13.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor13.HeaderText = "Shipped Date"; gridColumnDescriptor13.MappingName = "ShippedDate"; gridColumnDescriptor13.SerializedImageArray = ""; gridRelationDescriptor1.ChildTableDescriptor.Columns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor[] { gridColumnDescriptor8, gridColumnDescriptor9, gridColumnDescriptor10, gridColumnDescriptor11, gridColumnDescriptor12, gridColumnDescriptor13 }); gridRelationDescriptor1.ChildTableDescriptor.StackedHeaderRows.Add(new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderRowDescriptor("Row 1", new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderDescriptor("Header 1", new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("CustomerID"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("OrderDate"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("OrderID"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("ShipAddress"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("ShipName"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("ShippedDate") }) })); gridRelationDescriptor1.MappingName = "EmployeesOrders"; this.gridGroupingControl1.TableDescriptor.Relations.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridRelationDescriptor[] { gridRelationDescriptor1 }); gridStackedHeaderRowDescriptor1.Appearance.StackedHeaderCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.White); gridStackedHeaderDescriptor1.Appearance.StackedHeaderCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(128)))), ((int)(((byte)(0)))))); gridStackedHeaderDescriptor1.Name = "Header 1"; gridStackedHeaderDescriptor1.VisibleColumns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("EmployeeID"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("FirstName"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("LastName") }); gridStackedHeaderDescriptor2.Appearance.StackedHeaderCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))))); gridStackedHeaderDescriptor2.Name = "Header 2"; gridStackedHeaderDescriptor2.VisibleColumns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("Title"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("Address") }); gridStackedHeaderDescriptor3.Appearance.StackedHeaderCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.Blue); gridStackedHeaderDescriptor3.Name = "Header 3"; gridStackedHeaderDescriptor3.VisibleColumns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("City"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("Country"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("TitleOfCourtesy"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("BirthDate"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("HireDate") }); gridStackedHeaderDescriptor4.Appearance.StackedHeaderCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(128)))))); gridStackedHeaderDescriptor4.Name = "Header 4"; gridStackedHeaderDescriptor4.VisibleColumns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("Region"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("PostalCode"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("HomePhone") }); gridStackedHeaderDescriptor5.Appearance.StackedHeaderCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(255)))))); gridStackedHeaderDescriptor5.Name = "Header 5"; gridStackedHeaderDescriptor5.VisibleColumns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("Extension"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("Photo"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("SmallPhoto"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("Notes"), new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderVisibleColumnDescriptor("ReportsTo") }); gridStackedHeaderRowDescriptor1.Headers.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridStackedHeaderDescriptor[] { gridStackedHeaderDescriptor1, gridStackedHeaderDescriptor2, gridStackedHeaderDescriptor3, gridStackedHeaderDescriptor4, gridStackedHeaderDescriptor5 }); gridStackedHeaderRowDescriptor1.Name = "Row 1"; this.gridGroupingControl1.TableDescriptor.StackedHeaderRows.Add(gridStackedHeaderRowDescriptor1); this.gridGroupingControl1.TableDescriptor.TableOptions.CaptionRowHeight = (int)DpiAware.LogicalToDeviceUnits(25.0f); this.gridGroupingControl1.TableDescriptor.TableOptions.ColumnHeaderRowHeight = (int)DpiAware.LogicalToDeviceUnits(30.0f); this.gridGroupingControl1.TableDescriptor.TableOptions.RecordRowHeight = (int)DpiAware.LogicalToDeviceUnits(22.0f); this.gridGroupingControl1.TableDescriptor.VisibleColumns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("EmployeeID"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("FirstName"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("LastName"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("Title"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("Address"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("City"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("Country"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("TitleOfCourtesy"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("BirthDate"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("HireDate"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("Region"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("PostalCode"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("HomePhone"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("Extension"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("Photo"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("SmallPhoto"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("Notes"), new Syncfusion.Windows.Forms.Grid.Grouping.GridVisibleColumnDescriptor("ReportsTo") }); this.gridGroupingControl1.Text = "y"; this.gridGroupingControl1.TopLevelGroupOptions.ShowAddNewRecordBeforeDetails = false; this.gridGroupingControl1.VersionInfo = "4.301.0.0"; // // dataset11 // this.dataset11.DataSetName = "Dataset1"; this.dataset11.Locale = new System.Globalization.CultureInfo("en-US"); this.dataset11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // contextMenu1 // this.contextMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] { this.menuItem1 }); // // menuItem1 // this.menuItem1.Enabled = false; this.menuItem1.Index = 0; this.menuItem1.Text = "Clear Window"; this.menuItem1.Click += new System.EventHandler(this.menuItem1_Click); // // panel1 // this.panel1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.panel1.Controls.Add(this.gridGroupingControl1); this.panel1.Location = new System.Drawing.Point(28, 23); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(888, 355); this.panel1.TabIndex = 6; // // button1 // this.button1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.button1.Appearance = Syncfusion.Windows.Forms.ButtonAppearance.Metro; this.button1.FlatStyle = FlatStyle.Flat; this.button1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(22)))), ((int)(((byte)(165)))), ((int)(((byte)(220))))); this.button1.BeforeTouchSize = new System.Drawing.Size(128, 24); this.button1.BorderStyleAdv = Syncfusion.Windows.Forms.ButtonAdvBorderStyle.RaisedInner; this.button1.Font = new System.Drawing.Font("Segoe UI", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.button1.ForeColor = System.Drawing.Color.White; this.button1.IsBackStageButton = false; this.button1.Location = new System.Drawing.Point(790, 394); this.button1.Name = "button1"; this.button1.Size = new System.Drawing.Size(128, 24); this.button1.TabIndex = 12; this.button1.Text = "Trace Events"; this.button1.Click += new System.EventHandler(this.button1_Click_1); // // label1 // this.label1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left))); this.label1.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.label1.ForeColor = System.Drawing.Color.DimGray; this.label1.Location = new System.Drawing.Point(25, 402); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(80, 16); this.label1.TabIndex = 7; this.label1.Text = "Event Tracer:"; // // label2 // this.label2.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left))); this.label2.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.label2.ForeColor = System.Drawing.Color.DimGray; this.label2.Location = new System.Drawing.Point(93, 402); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(218, 16); this.label2.TabIndex = 8; this.label2.Text = "(Right click to clear the output window)"; // // listView1 // this.listView1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.listView1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; this.listView1.Columns.AddRange(new System.Windows.Forms.ColumnHeader[] { this.columnHeader1, this.columnHeader2 }); this.listView1.ContextMenu = this.contextMenu1; this.listView1.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.listView1.ForeColor = System.Drawing.Color.DimGray; this.listView1.Location = new System.Drawing.Point(25, 428); this.listView1.Name = "listView1"; this.listView1.Size = new System.Drawing.Size(893, 201); this.listView1.TabIndex = 9; this.listView1.TabStop = false; this.listView1.UseCompatibleStateImageBehavior = false; this.listView1.View = System.Windows.Forms.View.Details; // // columnHeader1 // this.columnHeader1.Text = "Event"; this.columnHeader1.Width = 186; // // columnHeader2 // this.columnHeader2.Text = "Details"; this.columnHeader2.Width = 759; // // freezeCaptioncheckBoxAdv // this.freezeCaptioncheckBoxAdv.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.freezeCaptioncheckBoxAdv.BeforeTouchSize = new System.Drawing.Size(150, 21); this.freezeCaptioncheckBoxAdv.BorderColor = System.Drawing.Color.FromArgb(((int)(((byte)(27)))), ((int)(((byte)(161)))), ((int)(((byte)(226))))); this.freezeCaptioncheckBoxAdv.Location = new System.Drawing.Point(618, 396); this.freezeCaptioncheckBoxAdv.MetroColor = System.Drawing.Color.FromArgb(((int)(((byte)(27)))), ((int)(((byte)(161)))), ((int)(((byte)(226))))); this.freezeCaptioncheckBoxAdv.Name = "freezeCaptioncheckBoxAdv"; this.freezeCaptioncheckBoxAdv.Size = new System.Drawing.Size(150, 21); this.freezeCaptioncheckBoxAdv.TabIndex = 11; this.freezeCaptioncheckBoxAdv.Text = "Freeze Caption"; this.freezeCaptioncheckBoxAdv.ThemesEnabled = true; this.freezeCaptioncheckBoxAdv.CheckStateChanged += new System.EventHandler(this.freezeCaptioncheckBoxAdv_CheckStateChanged); // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(940, 656); this.Controls.Add(this.freezeCaptioncheckBoxAdv); this.Controls.Add(this.button1); this.Controls.Add(this.listView1); this.Controls.Add(this.label2); this.Controls.Add(this.label1); this.Controls.Add(this.panel1); this.MinimumSize = new System.Drawing.Size(800, 600); this.Name = "Form1"; this.Text = "Grouping Events"; ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dataset11)).EndInit(); this.panel1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.freezeCaptioncheckBoxAdv)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// CustomSummary sample Customizations /// </summary> private void SampleCustomization() { // Setup a integrated summary GridSummaryColumnDescriptor sd0 = new GridSummaryColumnDescriptor(); //sd0.Name = "QuantityAvg"; sd0.DataMember = "Quantity"; sd0.DisplayColumn = "Quantity"; sd0.Format = "{Average:#.00}"; sd0.SummaryType = SummaryType.DoubleAggregate; this.gridGroupingControl1.TableDescriptor.SummaryRows.Add(new GridSummaryRowDescriptor("Row 0", "Average", sd0)); // Setup custom summaries this.gridGroupingControl1.QueryCustomSummary += new GridQueryCustomSummaryEventHandler(gridGroupingControl1_QueryCustomSummary); GridSummaryColumnDescriptor sd1 = new GridSummaryColumnDescriptor(); sd1.Name = "QuantityTotal"; sd1.DataMember = "Quantity"; sd1.DisplayColumn = "Quantity"; sd1.Format = "{Total}"; sd1.SummaryType = SummaryType.Custom; this.gridGroupingControl1.TableDescriptor.SummaryRows.Add(new GridSummaryRowDescriptor("Row 1", "Total", sd1)); GridSummaryColumnDescriptor sd2 = new GridSummaryColumnDescriptor(); sd2.Name = "QuantityDistinctCount"; sd2.DataMember = "Quantity"; sd2.DisplayColumn = "Quantity"; sd2.Format = "{Count}"; sd2.SummaryType = SummaryType.Custom; this.gridGroupingControl1.TableDescriptor.SummaryRows.Add(new GridSummaryRowDescriptor("Row 2", "DistinctCount", sd2)); GridSummaryColumnDescriptor sd3 = new GridSummaryColumnDescriptor(); sd3.Name = "QuantityMedian"; sd3.DataMember = "Quantity"; sd3.DisplayColumn = "Quantity"; sd3.Format = "{Median}"; sd3.SummaryType = SummaryType.Custom; this.gridGroupingControl1.TableDescriptor.SummaryRows.Add(new GridSummaryRowDescriptor("Row 3", "Statistic Median", sd3)); // Setup running totals by displaying the value of a custom counter in an unbound field FieldDescriptor unboundField = new FieldDescriptor("QuantityCount", "", false, ""); unboundField.ReadOnly = false; this.gridGroupingControl1.TableDescriptor.UnboundFields.Add(unboundField); // Routine that queries for the value this.gridGroupingControl1.TableDescriptor.QueryValue += new FieldValueEventHandler(unboundField_QueryValue); this.gridGroupingControl1.TableDescriptor.SaveValue += new FieldValueEventHandler(unboundField_SaveValue); FieldDescriptor unboundField2 = new FieldDescriptor("QuantityCount2", "", false, ""); this.gridGroupingControl1.TableDescriptor.UnboundFields.Add(unboundField2); this.gridGroupingControl1.TableDescriptor.Columns.IsModified = true; Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor2 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); gridColumnDescriptor1.MappingName = "OrderID"; this.gridGroupingControl1.TableDescriptor.Columns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor[] { gridColumnDescriptor1, new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor("ProductID"), new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor("UnitPrice"), new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor("Quantity"), }); foreach (GridColumnDescriptor col in this.gridGroupingControl1.TableDescriptor.Columns) { Regex rex = new Regex(@"\p{Lu}"); int index = rex.Match(col.MappingName.Substring(1)).Index; string name = ""; while (index > 0) { name += col.MappingName.Substring(0, index + 1) + " "; string secondName = col.MappingName.Substring(index + 1); index = rex.Match(secondName.Substring(1)).Index; while (index > 0) { name += secondName.Substring(0, index + 1) + " "; index = rex.Match(col.MappingName.Substring(name.Replace(" ", "").Length).Substring(1)).Index; } } name += col.MappingName.Substring(name.Replace(" ", "").Length); col.HeaderText = name; } GridColumnDescriptor columnDescriptor = new GridColumnDescriptor(unboundField); columnDescriptor.HeaderText = "Quantity Count"; columnDescriptor.Appearance.AnyRecordFieldCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((System.Byte)(255)), ((System.Byte)(245)), ((System.Byte)(227)))); this.gridGroupingControl1.TableDescriptor.Columns.Add(columnDescriptor); GridColumnDescriptor columnDescriptor2 = new GridColumnDescriptor(unboundField2); columnDescriptor2.HeaderText = "Quantity Count 2"; columnDescriptor2.Appearance.AnyRecordFieldCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((System.Byte)(255)), ((System.Byte)(245)), ((System.Byte)(227)))); this.gridGroupingControl1.TableDescriptor.Columns.Add(columnDescriptor2); // Setup custom counter this.gridGroupingControl1.Table.QueryCustomCount += new CustomCountEventHandler(Table_QueryCustomCount); this.gridGroupingControl1.CurrentRecordContextChange += new CurrentRecordContextChangeEventHandler(gridGroupingControl1_CurrentRecordContextChange); // Assign data source this.gridGroupingControl1.DataMember = null; this.gridGroupingControl1.DataSource = this.dataSet11.Order_Details; quantityFieldDescriptor = this.gridGroupingControl1.TableDescriptor.Fields["Quantity"]; // Add a filter so that we can check out difference between VisibleCustomCount (only records that meet criteria are counted) // and CustomCount (all records are counted) this.gridGroupingControl1.TableDescriptor.RecordFilters.Add("[UnitPrice] > 20"); this.gridGroupingControl1.FilterRuntimeProperties = true; this.gridGroupingControl1.TableControlCellClick += new GridTableControlCellClickEventHandler(gridGroupingControl1_TableControlCellClick); this.gridGroupingControl1.TableDescriptor.Columns["QuantityCount"].AllowGroupByColumn = false; this.gridGroupingControl1.TableDescriptor.Columns["QuantityCount2"].AllowGroupByColumn = false; //Hook-up the QueryColWidth event to set the Column width. this.gridGroupingControl1.TableModel.QueryColWidth += new GridRowColSizeEventHandler(TableModel_QueryColWidth); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor2 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor3 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor4 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor5 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor6 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor7 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor8 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor9 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor10 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor11 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor12 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor13 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor gridColumnSetDescriptor1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor gridColumnSetDescriptor2 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor gridColumnSetDescriptor3 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor gridColumnSetDescriptor4 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor gridColumnSetDescriptor5 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor gridColumnSetDescriptor6 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor gridColumnSetDescriptor7 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor(); this.dataSet11 = new EmployeeView.DataSet1(); this.gridGroupingControl1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl(); this.panel1 = new System.Windows.Forms.Panel(); this.buttonAdv5 = new Syncfusion.Windows.Forms.ButtonAdv(); this.buttonAdv4 = new Syncfusion.Windows.Forms.ButtonAdv(); this.buttonAdv3 = new Syncfusion.Windows.Forms.ButtonAdv(); this.buttonAdv2 = new Syncfusion.Windows.Forms.ButtonAdv(); this.buttonAdv1 = new Syncfusion.Windows.Forms.ButtonAdv(); ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).BeginInit(); this.panel1.SuspendLayout(); this.SuspendLayout(); // // dataSet11 // this.dataSet11.DataSetName = "DataSet1"; this.dataSet11.Locale = new System.Globalization.CultureInfo("en-US"); this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // gridGroupingControl1 // this.gridGroupingControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.gridGroupingControl1.Appearance.AlternateRecordFieldCell.BaseStyle = ""; this.gridGroupingControl1.Appearance.AlternateRecordFieldCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(201)))), ((int)(((byte)(219)))))); this.gridGroupingControl1.Appearance.RecordPreviewCell.BaseStyle = ""; this.gridGroupingControl1.Appearance.RecordPreviewCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(237)))), ((int)(((byte)(240)))), ((int)(((byte)(246)))))); this.gridGroupingControl1.Appearance.RecordPreviewRowHeaderCell.BaseStyle = ""; this.gridGroupingControl1.Appearance.RecordPreviewRowHeaderCell.CellType = "Static"; this.gridGroupingControl1.Appearance.RecordPreviewRowHeaderCell.Enabled = false; this.gridGroupingControl1.BackColor = System.Drawing.SystemColors.Window; this.gridGroupingControl1.ChildGroupOptions.ShowAddNewRecordAfterDetails = true; this.gridGroupingControl1.ChildGroupOptions.ShowAddNewRecordBeforeDetails = false; this.gridGroupingControl1.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.gridGroupingControl1.FreezeCaption = false; this.gridGroupingControl1.GridOfficeScrollBars = Syncfusion.Windows.Forms.OfficeScrollBars.Metro; this.gridGroupingControl1.GridVisualStyles = Syncfusion.Windows.Forms.GridVisualStyles.Metro; this.gridGroupingControl1.Location = new System.Drawing.Point(21, 8); this.gridGroupingControl1.Name = "gridGroupingControl1"; this.gridGroupingControl1.Size = new System.Drawing.Size(802, 634); this.gridGroupingControl1.TabIndex = 1; this.gridGroupingControl1.TableDescriptor.AllowNew = false; this.gridGroupingControl1.TableDescriptor.Appearance.AnyCell.Font.Facename = "Segoe UI"; this.gridGroupingControl1.TableDescriptor.Appearance.AnyCell.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(138)))), ((int)(((byte)(138)))), ((int)(((byte)(138))))); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.Borders.Bottom = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.Borders.Right = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(235)))), ((int)(((byte)(235)))), ((int)(((byte)(235)))))); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(138)))), ((int)(((byte)(138)))), ((int)(((byte)(138))))); this.gridGroupingControl1.TableDescriptor.Appearance.AnyRecordFieldCell.Borders.Bottom = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnyRecordFieldCell.Borders.Right = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnySummaryCell.Borders.Right = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(208)))), ((int)(((byte)(208)))), ((int)(((byte)(208))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnySummaryCell.Borders.Top = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(208)))), ((int)(((byte)(208)))), ((int)(((byte)(208))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnySummaryCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(208)))), ((int)(((byte)(208)))), ((int)(((byte)(208)))))); this.gridGroupingControl1.TableDescriptor.Appearance.ColumnHeaderCell.Font.Bold = true; this.gridGroupingControl1.TableDescriptor.Appearance.GroupCaptionCell.CellType = "ColumnHeader"; gridColumnDescriptor1.HeaderImage = null; gridColumnDescriptor1.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor1.HeaderText = "ID"; gridColumnDescriptor1.MappingName = "EmployeeID"; gridColumnDescriptor1.SerializedImageArray = ""; gridColumnDescriptor1.Width = 60; gridColumnDescriptor2.HeaderImage = null; gridColumnDescriptor2.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor2.MappingName = "FirstName"; gridColumnDescriptor2.SerializedImageArray = ""; gridColumnDescriptor2.Width = 115; gridColumnDescriptor3.HeaderImage = null; gridColumnDescriptor3.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor3.MappingName = "LastName"; gridColumnDescriptor3.SerializedImageArray = ""; gridColumnDescriptor4.HeaderImage = null; gridColumnDescriptor4.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor4.MappingName = "Address"; gridColumnDescriptor4.SerializedImageArray = ""; gridColumnDescriptor4.Width = 118; gridColumnDescriptor5.HeaderImage = null; gridColumnDescriptor5.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor5.MappingName = "City"; gridColumnDescriptor5.SerializedImageArray = ""; gridColumnDescriptor5.Width = 83; gridColumnDescriptor6.HeaderImage = null; gridColumnDescriptor6.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor6.MappingName = "PostalCode"; gridColumnDescriptor6.SerializedImageArray = ""; gridColumnDescriptor7.HeaderImage = null; gridColumnDescriptor7.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor7.MappingName = "Region"; gridColumnDescriptor7.SerializedImageArray = ""; gridColumnDescriptor7.Width = 80; gridColumnDescriptor8.HeaderImage = null; gridColumnDescriptor8.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor8.MappingName = "Country"; gridColumnDescriptor8.SerializedImageArray = ""; gridColumnDescriptor8.Width = 80; gridColumnDescriptor9.HeaderImage = null; gridColumnDescriptor9.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor9.MappingName = "BirthDate"; gridColumnDescriptor9.SerializedImageArray = ""; gridColumnDescriptor10.HeaderImage = null; gridColumnDescriptor10.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor10.MappingName = "Photo"; gridColumnDescriptor10.SerializedImageArray = ""; gridColumnDescriptor11.HeaderImage = null; gridColumnDescriptor11.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor11.MappingName = "ReportsTo"; gridColumnDescriptor11.SerializedImageArray = ""; gridColumnDescriptor12.HeaderImage = null; gridColumnDescriptor12.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor12.MappingName = "Title"; gridColumnDescriptor12.SerializedImageArray = ""; gridColumnDescriptor12.Width = 144; gridColumnDescriptor13.HeaderImage = null; gridColumnDescriptor13.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor13.MappingName = "TitleOfCourtesy"; gridColumnDescriptor13.SerializedImageArray = ""; gridColumnDescriptor13.Width = 133; this.gridGroupingControl1.TableDescriptor.Columns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor[] { gridColumnDescriptor1, gridColumnDescriptor2, gridColumnDescriptor3, gridColumnDescriptor4, gridColumnDescriptor5, gridColumnDescriptor6, gridColumnDescriptor7, gridColumnDescriptor8, gridColumnDescriptor9, gridColumnDescriptor10, gridColumnDescriptor11, gridColumnDescriptor12, gridColumnDescriptor13 }); gridColumnSetDescriptor1.ColumnSpans.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("EmployeeID", "R0C0:R1C0") }); gridColumnSetDescriptor1.Name = "ColumnSetId"; gridColumnSetDescriptor2.ColumnSpans.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("Photo", "R0C0:R1C0") }); gridColumnSetDescriptor2.Name = "ColumnSetPhoto"; gridColumnSetDescriptor3.ColumnSpans.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("FirstName", "R0C0"), new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("LastName", "R1C0") }); gridColumnSetDescriptor3.Name = "ColumnSetName"; gridColumnSetDescriptor4.ColumnSpans.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("Address", "R0C0:R0C1"), new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("City", "R1C0"), new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("PostalCode", "R1C1") }); gridColumnSetDescriptor4.Name = "ColumnSetAddress"; gridColumnSetDescriptor5.ColumnSpans.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("Region", "R0C0"), new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("Country", "R1C0") }); gridColumnSetDescriptor5.Name = "ColumnSetRegionCountry"; gridColumnSetDescriptor6.ColumnSpans.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("Title", "R0C0"), new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("TitleOfCourtesy", "R1C0") }); gridColumnSetDescriptor6.Name = "ColumnSetTitle"; gridColumnSetDescriptor7.ColumnSpans.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("BirthDate", "R0C0"), new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("ReportsTo", "R1C0") }); gridColumnSetDescriptor7.Name = "ColumnSetBirth"; this.gridGroupingControl1.TableDescriptor.ColumnSets.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor[] { gridColumnSetDescriptor1, gridColumnSetDescriptor2, gridColumnSetDescriptor3, gridColumnSetDescriptor4, gridColumnSetDescriptor5, gridColumnSetDescriptor6, gridColumnSetDescriptor7 }); this.gridGroupingControl1.TableDescriptor.TableOptions.ColumnHeaderRowHeight = 25; this.gridGroupingControl1.TableDescriptor.TableOptions.RecordRowHeight = 20; this.gridGroupingControl1.TableOptions.RecordPreviewRowHeight = 60; this.gridGroupingControl1.TableOptions.RecordRowHeight = 30; this.gridGroupingControl1.TableOptions.ShowRecordPreviewRow = true; this.gridGroupingControl1.Text = "gridGroupingControl1"; this.gridGroupingControl1.TopLevelGroupOptions.ShowAddNewRecordAfterDetails = false; this.gridGroupingControl1.TopLevelGroupOptions.ShowAddNewRecordBeforeDetails = false; this.gridGroupingControl1.TopLevelGroupOptions.ShowCaption = true; // // panel1 // this.panel1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Right))); this.panel1.Controls.Add(this.buttonAdv5); this.panel1.Controls.Add(this.buttonAdv4); this.panel1.Controls.Add(this.buttonAdv3); this.panel1.Controls.Add(this.buttonAdv2); this.panel1.Controls.Add(this.buttonAdv1); this.panel1.Font = new System.Drawing.Font("Segoe UI", 8.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.panel1.Location = new System.Drawing.Point(829, 8); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(187, 635); this.panel1.TabIndex = 2; // // buttonAdv5 // this.buttonAdv5.Appearance = Syncfusion.Windows.Forms.ButtonAppearance.Metro; this.buttonAdv5.FlatStyle = FlatStyle.Flat; this.buttonAdv5.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(22)))), ((int)(((byte)(165)))), ((int)(((byte)(220))))); this.buttonAdv5.BeforeTouchSize = new System.Drawing.Size(151, 40); this.buttonAdv5.BorderStyleAdv = Syncfusion.Windows.Forms.ButtonAdvBorderStyle.RaisedInner; this.buttonAdv5.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.buttonAdv5.ForeColor = System.Drawing.Color.White; this.buttonAdv5.IsBackStageButton = false; this.buttonAdv5.Location = new System.Drawing.Point(16, 215); this.buttonAdv5.Name = "buttonAdv5"; this.buttonAdv5.Size = new System.Drawing.Size(151, 40); this.buttonAdv5.TabIndex = 6; this.buttonAdv5.Text = "Edit custom styles"; this.buttonAdv5.Click += new System.EventHandler(this.buttonAdv5_Click); // // buttonAdv4 // this.buttonAdv4.Appearance = Syncfusion.Windows.Forms.ButtonAppearance.Metro; this.buttonAdv4.FlatStyle = FlatStyle.Flat; this.buttonAdv4.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(22)))), ((int)(((byte)(165)))), ((int)(((byte)(220))))); this.buttonAdv4.BeforeTouchSize = new System.Drawing.Size(151, 40); this.buttonAdv4.BorderStyleAdv = Syncfusion.Windows.Forms.ButtonAdvBorderStyle.RaisedInner; this.buttonAdv4.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.buttonAdv4.ForeColor = System.Drawing.Color.White; this.buttonAdv4.IsBackStageButton = false; this.buttonAdv4.Location = new System.Drawing.Point(16, 165); this.buttonAdv4.Name = "buttonAdv4"; this.buttonAdv4.Size = new System.Drawing.Size(151, 40); this.buttonAdv4.TabIndex = 5; this.buttonAdv4.Text = "Restore all from xml"; this.buttonAdv4.Click += new System.EventHandler(this.buttonAdv4_Click); // // buttonAdv3 // this.buttonAdv3.Appearance = Syncfusion.Windows.Forms.ButtonAppearance.Metro; this.buttonAdv3.FlatStyle = FlatStyle.Flat; this.buttonAdv3.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(22)))), ((int)(((byte)(165)))), ((int)(((byte)(220))))); this.buttonAdv3.BeforeTouchSize = new System.Drawing.Size(151, 40); this.buttonAdv3.BorderStyleAdv = Syncfusion.Windows.Forms.ButtonAdvBorderStyle.RaisedInner; this.buttonAdv3.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.buttonAdv3.ForeColor = System.Drawing.Color.White; this.buttonAdv3.IsBackStageButton = false; this.buttonAdv3.Location = new System.Drawing.Point(16, 115); this.buttonAdv3.Name = "buttonAdv3"; this.buttonAdv3.Size = new System.Drawing.Size(151, 40); this.buttonAdv3.TabIndex = 4; this.buttonAdv3.Text = "Clear all"; this.buttonAdv3.Click += new System.EventHandler(this.buttonAdv3_Click); // // buttonAdv2 // this.buttonAdv2.Appearance = Syncfusion.Windows.Forms.ButtonAppearance.Metro; this.buttonAdv2.FlatStyle = FlatStyle.Flat; this.buttonAdv2.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(22)))), ((int)(((byte)(165)))), ((int)(((byte)(220))))); this.buttonAdv2.BeforeTouchSize = new System.Drawing.Size(151, 40); this.buttonAdv2.BorderStyleAdv = Syncfusion.Windows.Forms.ButtonAdvBorderStyle.RaisedInner; this.buttonAdv2.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.buttonAdv2.ForeColor = System.Drawing.Color.White; this.buttonAdv2.IsBackStageButton = false; this.buttonAdv2.Location = new System.Drawing.Point(16, 65); this.buttonAdv2.Name = "buttonAdv2"; this.buttonAdv2.Size = new System.Drawing.Size(151, 40); this.buttonAdv2.TabIndex = 3; this.buttonAdv2.Text = "Save all to xml"; this.buttonAdv2.Click += new System.EventHandler(this.buttonAdv2_Click); // // buttonAdv1 // this.buttonAdv1.Appearance = Syncfusion.Windows.Forms.ButtonAppearance.Metro; this.buttonAdv1.FlatStyle = FlatStyle.Flat; this.buttonAdv1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(22)))), ((int)(((byte)(165)))), ((int)(((byte)(220))))); this.buttonAdv1.BeforeTouchSize = new System.Drawing.Size(151, 40); this.buttonAdv1.BorderStyleAdv = Syncfusion.Windows.Forms.ButtonAdvBorderStyle.RaisedInner; this.buttonAdv1.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.buttonAdv1.ForeColor = System.Drawing.Color.White; this.buttonAdv1.IsBackStageButton = false; this.buttonAdv1.Location = new System.Drawing.Point(16, 15); this.buttonAdv1.Name = "buttonAdv1"; this.buttonAdv1.Size = new System.Drawing.Size(151, 40); this.buttonAdv1.TabIndex = 2; this.buttonAdv1.Text = "Initialize with custom styles"; this.buttonAdv1.Click += new System.EventHandler(this.buttonAdv1_Click); // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(1012, 653); this.Controls.Add(this.panel1); this.Controls.Add(this.gridGroupingControl1); this.MinimumSize = new System.Drawing.Size(800, 400); this.Name = "Form1"; this.Text = "Employee View "; ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).EndInit(); this.panel1.ResumeLayout(false); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1)); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor2 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor3 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor4 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); this.dataSet11 = new XMLSerialization.DataSet1(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlConnection1 = new System.Data.SqlClient.SqlConnection(); this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter(); this.reset = new Syncfusion.Windows.Forms.ButtonAdv(); this.btnLoadXmlSchema = new Syncfusion.Windows.Forms.ButtonAdv(); this.btnSaveXmlSchema = new Syncfusion.Windows.Forms.ButtonAdv(); this.gridGroupingControl1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl(); this.propertyGrid1 = new System.Windows.Forms.PropertyGrid(); ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).BeginInit(); this.SuspendLayout(); // // dataSet11 // this.dataSet11.DataSetName = "DataSet1"; this.dataSet11.Locale = new System.Globalization.CultureInfo("en-US"); this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT CategoryID, CategoryName, Description, Picture FROM Categories"; this.sqlSelectCommand1.Connection = this.sqlConnection1; // // sqlConnection1 // this.sqlConnection1.ConnectionString = "data source=(local)\\NETSDK;initial catalog=Northwind;integrated security=SSPI;per" + "sist security info=True;workstation id=localhost;packet size=4096"; this.sqlConnection1.FireInfoMessageEventOnUserErrors = false; // // sqlInsertCommand1 // this.sqlInsertCommand1.CommandText = resources.GetString("sqlInsertCommand1.CommandText"); this.sqlInsertCommand1.Connection = this.sqlConnection1; this.sqlInsertCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@CategoryName", System.Data.SqlDbType.NVarChar, 15, "CategoryName"), new System.Data.SqlClient.SqlParameter("@Description", System.Data.SqlDbType.NVarChar, 1073741823, "Description"), new System.Data.SqlClient.SqlParameter("@Picture", System.Data.SqlDbType.VarBinary, 2147483647, "Picture") }); // // sqlUpdateCommand1 // this.sqlUpdateCommand1.CommandText = resources.GetString("sqlUpdateCommand1.CommandText"); this.sqlUpdateCommand1.Connection = this.sqlConnection1; this.sqlUpdateCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@CategoryName", System.Data.SqlDbType.NVarChar, 15, "CategoryName"), new System.Data.SqlClient.SqlParameter("@Description", System.Data.SqlDbType.NVarChar, 1073741823, "Description"), new System.Data.SqlClient.SqlParameter("@Picture", System.Data.SqlDbType.VarBinary, 2147483647, "Picture"), new System.Data.SqlClient.SqlParameter("@Original_CategoryID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "CategoryID", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_CategoryName", System.Data.SqlDbType.NVarChar, 15, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "CategoryName", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@CategoryID", System.Data.SqlDbType.Int, 4, "CategoryID") }); // // sqlDeleteCommand1 // this.sqlDeleteCommand1.CommandText = "DELETE FROM Categories WHERE (CategoryID = @Original_CategoryID) AND (CategoryNam" + "e = @Original_CategoryName)"; this.sqlDeleteCommand1.Connection = this.sqlConnection1; this.sqlDeleteCommand1.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@Original_CategoryID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "CategoryID", System.Data.DataRowVersion.Original, null), new System.Data.SqlClient.SqlParameter("@Original_CategoryName", System.Data.SqlDbType.NVarChar, 15, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "CategoryName", System.Data.DataRowVersion.Original, null) }); // // sqlDataAdapter1 // this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand1; this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1; this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1; this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Categories", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("CategoryID", "CategoryID"), new System.Data.Common.DataColumnMapping("CategoryName", "CategoryName"), new System.Data.Common.DataColumnMapping("Description", "Description"), new System.Data.Common.DataColumnMapping("Picture", "Picture") }) }); this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1; // // reset // this.reset.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left))); this.reset.Appearance = Syncfusion.Windows.Forms.ButtonAppearance.Metro; this.reset.FlatStyle = FlatStyle.Flat; this.reset.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(22)))), ((int)(((byte)(165)))), ((int)(((byte)(220))))); this.reset.BeforeTouchSize = new System.Drawing.Size(130, 28); this.reset.BorderStyleAdv = Syncfusion.Windows.Forms.ButtonAdvBorderStyle.RaisedInner; this.reset.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.reset.ForeColor = System.Drawing.Color.White; this.reset.IsBackStageButton = false; this.reset.Location = new System.Drawing.Point(340, 615); this.reset.Name = "reset"; this.reset.Size = new System.Drawing.Size(130, 28); this.reset.TabIndex = 12; this.reset.Text = "Reset Schema"; this.reset.Click += new System.EventHandler(this.reset_Click); // // btnLoadXmlSchema // this.btnLoadXmlSchema.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left))); this.btnLoadXmlSchema.Appearance = Syncfusion.Windows.Forms.ButtonAppearance.Metro; this.btnLoadXmlSchema.FlatStyle = FlatStyle.Flat; this.btnLoadXmlSchema.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(22)))), ((int)(((byte)(165)))), ((int)(((byte)(220))))); this.btnLoadXmlSchema.BeforeTouchSize = new System.Drawing.Size(130, 28); this.btnLoadXmlSchema.BorderStyleAdv = Syncfusion.Windows.Forms.ButtonAdvBorderStyle.RaisedInner; this.btnLoadXmlSchema.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.btnLoadXmlSchema.ForeColor = System.Drawing.Color.White; this.btnLoadXmlSchema.IsBackStageButton = false; this.btnLoadXmlSchema.Location = new System.Drawing.Point(199, 615); this.btnLoadXmlSchema.Name = "btnLoadXmlSchema"; this.btnLoadXmlSchema.Size = new System.Drawing.Size(130, 28); this.btnLoadXmlSchema.TabIndex = 11; this.btnLoadXmlSchema.Text = "Load Xml Schema"; this.btnLoadXmlSchema.Click += new System.EventHandler(this.btnLoadXmlSchema_Click); // // btnSaveXmlSchema // this.btnSaveXmlSchema.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left))); this.btnSaveXmlSchema.Appearance = Syncfusion.Windows.Forms.ButtonAppearance.Metro; this.btnSaveXmlSchema.FlatStyle = FlatStyle.Flat; this.btnSaveXmlSchema.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(22)))), ((int)(((byte)(165)))), ((int)(((byte)(220))))); this.btnSaveXmlSchema.BeforeTouchSize = new System.Drawing.Size(130, 28); this.btnSaveXmlSchema.BorderStyleAdv = Syncfusion.Windows.Forms.ButtonAdvBorderStyle.RaisedInner; this.btnSaveXmlSchema.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.btnSaveXmlSchema.ForeColor = System.Drawing.Color.White; this.btnSaveXmlSchema.IsBackStageButton = false; this.btnSaveXmlSchema.Location = new System.Drawing.Point(60, 615); this.btnSaveXmlSchema.Name = "btnSaveXmlSchema"; this.btnSaveXmlSchema.Size = new System.Drawing.Size(130, 28); this.btnSaveXmlSchema.TabIndex = 10; this.btnSaveXmlSchema.Text = "Save Xml Schema"; this.btnSaveXmlSchema.Click += new System.EventHandler(this.btnSaveXmlSchema_Click); // // gridGroupingControl1 // this.gridGroupingControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.gridGroupingControl1.BackColor = System.Drawing.SystemColors.Window; this.gridGroupingControl1.DataSource = this.dataSet11.Categories; this.gridGroupingControl1.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.gridGroupingControl1.FreezeCaption = false; this.gridGroupingControl1.Location = new System.Drawing.Point(15, 16); this.gridGroupingControl1.Name = "gridGroupingControl1"; this.gridGroupingControl1.Size = new System.Drawing.Size(697, 589); this.gridGroupingControl1.TabIndex = 9; gridColumnDescriptor1.HeaderImage = null; gridColumnDescriptor1.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor1.MappingName = "CategoryID"; gridColumnDescriptor1.SerializedImageArray = ""; gridColumnDescriptor1.Width = 80; gridColumnDescriptor2.HeaderImage = null; gridColumnDescriptor2.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor2.MappingName = "CategoryName"; gridColumnDescriptor2.SerializedImageArray = ""; gridColumnDescriptor3.HeaderImage = null; gridColumnDescriptor3.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor3.MappingName = "Description"; gridColumnDescriptor3.SerializedImageArray = ""; gridColumnDescriptor3.Width = 250; gridColumnDescriptor4.HeaderImage = null; gridColumnDescriptor4.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor4.MappingName = "Picture"; gridColumnDescriptor4.SerializedImageArray = ""; this.gridGroupingControl1.TableDescriptor.Columns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor[] { gridColumnDescriptor1, gridColumnDescriptor2, gridColumnDescriptor3, gridColumnDescriptor4 }); this.gridGroupingControl1.TableOptions.RecordRowHeight = 57; this.gridGroupingControl1.Text = "gridGroupingControl1"; // // propertyGrid1 // this.propertyGrid1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Right))); this.propertyGrid1.BackColor = System.Drawing.Color.White; this.propertyGrid1.CommandsBackColor = System.Drawing.Color.White; this.propertyGrid1.CommandsDisabledLinkColor = System.Drawing.Color.White; this.propertyGrid1.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.propertyGrid1.HelpBackColor = System.Drawing.Color.White; this.propertyGrid1.LineColor = System.Drawing.Color.White; this.propertyGrid1.Location = new System.Drawing.Point(720, 16); this.propertyGrid1.Name = "propertyGrid1"; this.propertyGrid1.Size = new System.Drawing.Size(276, 589); this.propertyGrid1.TabIndex = 13; // // Form1 // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.ClientSize = new System.Drawing.Size(1012, 653); this.Controls.Add(this.propertyGrid1); this.Controls.Add(this.reset); this.Controls.Add(this.btnLoadXmlSchema); this.Controls.Add(this.btnSaveXmlSchema); this.Controls.Add(this.gridGroupingControl1); this.MinimumSize = new System.Drawing.Size(800, 400); this.Name = "Form1"; this.Text = "XML Serialization"; ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).EndInit(); this.ResumeLayout(false); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor14 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor15 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor16 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor17 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor18 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor19 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor20 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor21 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor22 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor23 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor24 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor25 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor26 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor gridColumnSetDescriptor8 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor gridColumnSetDescriptor9 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor gridColumnSetDescriptor10 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor gridColumnSetDescriptor11 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor gridColumnSetDescriptor12 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor gridColumnSetDescriptor13 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor(); Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor gridColumnSetDescriptor14 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor(); this.dataSet11 = new EmployeeView.DataSet1(); this.gridGroupingControl1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl(); this.propertyGrid1 = new System.Windows.Forms.PropertyGrid(); ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).BeginInit(); this.SuspendLayout(); // // dataSet11 // this.dataSet11.DataSetName = "DataSet1"; this.dataSet11.Locale = new System.Globalization.CultureInfo("en-US"); this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // gridGroupingControl1 // this.gridGroupingControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.gridGroupingControl1.Appearance.AlternateRecordFieldCell.BaseStyle = ""; this.gridGroupingControl1.Appearance.AlternateRecordFieldCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(201)))), ((int)(((byte)(219)))))); this.gridGroupingControl1.Appearance.RecordPreviewCell.BaseStyle = ""; this.gridGroupingControl1.Appearance.RecordPreviewCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(237)))), ((int)(((byte)(240)))), ((int)(((byte)(246)))))); this.gridGroupingControl1.Appearance.RecordPreviewRowHeaderCell.BaseStyle = ""; this.gridGroupingControl1.Appearance.RecordPreviewRowHeaderCell.CellType = "Static"; this.gridGroupingControl1.Appearance.RecordPreviewRowHeaderCell.Enabled = false; this.gridGroupingControl1.BackColor = System.Drawing.SystemColors.Window; this.gridGroupingControl1.ChildGroupOptions.ShowAddNewRecordAfterDetails = true; this.gridGroupingControl1.ChildGroupOptions.ShowAddNewRecordBeforeDetails = false; this.gridGroupingControl1.DataSource = this.dataSet11.Employees; this.gridGroupingControl1.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.gridGroupingControl1.FreezeCaption = false; this.gridGroupingControl1.GridOfficeScrollBars = Syncfusion.Windows.Forms.OfficeScrollBars.Metro; this.gridGroupingControl1.GridVisualStyles = Syncfusion.Windows.Forms.GridVisualStyles.Metro; this.gridGroupingControl1.Location = new System.Drawing.Point(13, 15); this.gridGroupingControl1.Name = "gridGroupingControl1"; this.gridGroupingControl1.Size = new System.Drawing.Size(685, 620); this.gridGroupingControl1.TabIndex = 0; this.gridGroupingControl1.TableDescriptor.AllowNew = false; this.gridGroupingControl1.TableDescriptor.Appearance.AnyCell.Font.Facename = "Segoe UI"; this.gridGroupingControl1.TableDescriptor.Appearance.AnyCell.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(138)))), ((int)(((byte)(138)))), ((int)(((byte)(138))))); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.Borders.Bottom = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.Borders.Right = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(235)))), ((int)(((byte)(235)))), ((int)(((byte)(235)))))); this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.TextColor = System.Drawing.Color.FromArgb(((int)(((byte)(138)))), ((int)(((byte)(138)))), ((int)(((byte)(138))))); this.gridGroupingControl1.TableDescriptor.Appearance.AnyRecordFieldCell.Borders.Bottom = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnyRecordFieldCell.Borders.Right = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnySummaryCell.Borders.Right = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(208)))), ((int)(((byte)(208)))), ((int)(((byte)(208))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnySummaryCell.Borders.Top = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(208)))), ((int)(((byte)(208)))), ((int)(((byte)(208))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin); this.gridGroupingControl1.TableDescriptor.Appearance.AnySummaryCell.Interior = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(208)))), ((int)(((byte)(208)))), ((int)(((byte)(208)))))); this.gridGroupingControl1.TableDescriptor.Appearance.ColumnHeaderCell.Font.Bold = true; this.gridGroupingControl1.TableDescriptor.Appearance.GroupCaptionCell.CellType = "ColumnHeader"; gridColumnDescriptor14.HeaderImage = null; gridColumnDescriptor14.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor14.HeaderText = "ID"; gridColumnDescriptor14.MappingName = "EmployeeID"; gridColumnDescriptor14.SerializedImageArray = ""; gridColumnDescriptor14.Width = 60; gridColumnDescriptor15.HeaderImage = null; gridColumnDescriptor15.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor15.MappingName = "FirstName"; gridColumnDescriptor15.SerializedImageArray = ""; gridColumnDescriptor15.Width = 115; gridColumnDescriptor16.HeaderImage = null; gridColumnDescriptor16.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor16.MappingName = "LastName"; gridColumnDescriptor16.SerializedImageArray = ""; gridColumnDescriptor17.HeaderImage = null; gridColumnDescriptor17.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor17.MappingName = "Address"; gridColumnDescriptor17.SerializedImageArray = ""; gridColumnDescriptor17.Width = 118; gridColumnDescriptor18.HeaderImage = null; gridColumnDescriptor18.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor18.MappingName = "City"; gridColumnDescriptor18.SerializedImageArray = ""; gridColumnDescriptor18.Width = 83; gridColumnDescriptor19.HeaderImage = null; gridColumnDescriptor19.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor19.MappingName = "PostalCode"; gridColumnDescriptor19.SerializedImageArray = ""; gridColumnDescriptor20.HeaderImage = null; gridColumnDescriptor20.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor20.MappingName = "Region"; gridColumnDescriptor20.SerializedImageArray = ""; gridColumnDescriptor20.Width = 80; gridColumnDescriptor21.HeaderImage = null; gridColumnDescriptor21.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor21.MappingName = "Country"; gridColumnDescriptor21.SerializedImageArray = ""; gridColumnDescriptor21.Width = 80; gridColumnDescriptor22.HeaderImage = null; gridColumnDescriptor22.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor22.MappingName = "BirthDate"; gridColumnDescriptor22.SerializedImageArray = ""; gridColumnDescriptor23.HeaderImage = null; gridColumnDescriptor23.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor23.MappingName = "Photo"; gridColumnDescriptor23.SerializedImageArray = ""; gridColumnDescriptor24.HeaderImage = null; gridColumnDescriptor24.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor24.MappingName = "ReportsTo"; gridColumnDescriptor24.SerializedImageArray = ""; gridColumnDescriptor25.HeaderImage = null; gridColumnDescriptor25.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor25.MappingName = "Title"; gridColumnDescriptor25.SerializedImageArray = ""; gridColumnDescriptor25.Width = 144; gridColumnDescriptor26.HeaderImage = null; gridColumnDescriptor26.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left; gridColumnDescriptor26.MappingName = "TitleOfCourtesy"; gridColumnDescriptor26.SerializedImageArray = ""; gridColumnDescriptor26.Width = 133; this.gridGroupingControl1.TableDescriptor.Columns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor[] { gridColumnDescriptor14, gridColumnDescriptor15, gridColumnDescriptor16, gridColumnDescriptor17, gridColumnDescriptor18, gridColumnDescriptor19, gridColumnDescriptor20, gridColumnDescriptor21, gridColumnDescriptor22, gridColumnDescriptor23, gridColumnDescriptor24, gridColumnDescriptor25, gridColumnDescriptor26 }); gridColumnSetDescriptor8.ColumnSpans.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("EmployeeID", "R0C0:R1C0") }); gridColumnSetDescriptor8.Name = "ColumnSetId"; gridColumnSetDescriptor9.ColumnSpans.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("Photo", "R0C0:R1C0") }); gridColumnSetDescriptor9.Name = "ColumnSetPhoto"; gridColumnSetDescriptor10.ColumnSpans.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("FirstName", "R0C0"), new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("LastName", "R1C0") }); gridColumnSetDescriptor10.Name = "ColumnSetName"; gridColumnSetDescriptor11.ColumnSpans.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("Address", "R0C0:R0C1"), new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("City", "R1C0"), new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("PostalCode", "R1C1") }); gridColumnSetDescriptor11.Name = "ColumnSetAddress"; gridColumnSetDescriptor12.ColumnSpans.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("Region", "R0C0"), new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("Country", "R1C0") }); gridColumnSetDescriptor12.Name = "ColumnSetRegionCountry"; gridColumnSetDescriptor13.ColumnSpans.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("Title", "R0C0"), new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("TitleOfCourtesy", "R1C0") }); gridColumnSetDescriptor13.Name = "ColumnSetTitle"; gridColumnSetDescriptor14.ColumnSpans.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor[] { new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("BirthDate", "R0C0"), new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSpanDescriptor("ReportsTo", "R1C0") }); gridColumnSetDescriptor14.Name = "ColumnSetBirth"; this.gridGroupingControl1.TableDescriptor.ColumnSets.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnSetDescriptor[] { gridColumnSetDescriptor8, gridColumnSetDescriptor9, gridColumnSetDescriptor10, gridColumnSetDescriptor11, gridColumnSetDescriptor12, gridColumnSetDescriptor13, gridColumnSetDescriptor14 }); this.gridGroupingControl1.TableDescriptor.TableOptions.ColumnHeaderRowHeight = 25; this.gridGroupingControl1.TableDescriptor.TableOptions.RecordRowHeight = 20; this.gridGroupingControl1.TableOptions.RecordPreviewRowHeight = 60; this.gridGroupingControl1.TableOptions.RecordRowHeight = 30; this.gridGroupingControl1.TableOptions.ShowRecordPreviewRow = true; this.gridGroupingControl1.Text = "gridGroupingControl1"; this.gridGroupingControl1.TopLevelGroupOptions.ShowAddNewRecordAfterDetails = false; this.gridGroupingControl1.TopLevelGroupOptions.ShowAddNewRecordBeforeDetails = false; this.gridGroupingControl1.TopLevelGroupOptions.ShowCaption = true; this.gridGroupingControl1.QueryCellStyleInfo += new Syncfusion.Windows.Forms.Grid.Grouping.GridTableCellStyleInfoEventHandler(this.gridGroupingControl1_QueryCellStyleInfo); // // propertyGrid1 // this.propertyGrid1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Right))); this.propertyGrid1.BackColor = System.Drawing.Color.White; this.propertyGrid1.CommandsBackColor = System.Drawing.Color.White; this.propertyGrid1.CommandsDisabledLinkColor = System.Drawing.Color.White; this.propertyGrid1.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.propertyGrid1.HelpBackColor = System.Drawing.Color.White; this.propertyGrid1.LineColor = System.Drawing.Color.White; this.propertyGrid1.Location = new System.Drawing.Point(704, 15); this.propertyGrid1.Name = "propertyGrid1"; this.propertyGrid1.Size = new System.Drawing.Size(292, 620); this.propertyGrid1.TabIndex = 9; // // Form1 // this.ClientSize = new System.Drawing.Size(1012, 656); this.MinimumSize = new System.Drawing.Size(850, 500); this.Controls.Add(this.propertyGrid1); this.Controls.Add(this.gridGroupingControl1); this.Name = "Form1"; this.Text = "Record Customization"; ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).EndInit(); this.ResumeLayout(false); }