/// <summary> /// GridGrouping control getting started customization. /// </summary> private void GridSettings() { this.eventTracer1 = new ComboboxCells.EventTracer(); //used to set multiextended selection mode in gridgrouping control. this.gridGroupingControl1.TableOptions.ListBoxSelectionMode = SelectionMode.MultiExtended; // Header Text this.gridGroupingControl1.TableDescriptor.Columns["EmployeeID"].HeaderText = "Employee ID"; this.gridGroupingControl1.TableDescriptor.Columns["LastName"].HeaderText = "Last Name"; this.gridGroupingControl1.TableDescriptor.Columns["FirstName"].HeaderText = "First Name"; this.gridGroupingControl1.TableDescriptor.Columns["TitleOfCourtesy"].HeaderText = "Title Of Courtesy"; this.gridGroupingControl1.TableDescriptor.Columns["BirthDate"].HeaderText = "Birth Date"; this.gridGroupingControl1.TableDescriptor.Columns["HireDate"].HeaderText = "Hire Date"; this.gridGroupingControl1.TableDescriptor.Columns["HomePhone"].HeaderText = "Home Phone"; this.gridGroupingControl1.TableDescriptor.Columns["ReportsTo"].HeaderText = "Reports To"; this.gridGroupingControl1.TableDescriptor.Columns["PostalCode"].HeaderText = "Postal Code"; this.gridGroupingControl1.TableDescriptor.Columns["PhotoPath"].HeaderText = "Photo Path"; this.gridGroupingControl1.TableDescriptor.Columns["SmallPhoto"].HeaderText = "Small Photo"; this.gridGroupingControl1.GetTableDescriptor("Orders").Columns["ShipVia"].HeaderText = "Ship Via"; this.gridGroupingControl1.GetTableDescriptor("Orders").Columns["ShipRegion"].HeaderText = "Ship Region"; this.gridGroupingControl1.GetTableDescriptor("Orders").Columns["ShipPostalCode"].HeaderText = "Ship Postal Code"; this.gridGroupingControl1.GetTableDescriptor("Orders").Columns["ShippedDate"].HeaderText = "Shipped Date"; this.gridGroupingControl1.GetTableDescriptor("Orders").Columns["ShipName"].HeaderText = "Ship Name"; this.gridGroupingControl1.GetTableDescriptor("Orders").Columns["ShipCountry"].HeaderText = "Ship Country"; this.gridGroupingControl1.GetTableDescriptor("Orders").Columns["ShipCity"].HeaderText = "Ship City"; this.gridGroupingControl1.GetTableDescriptor("Orders").Columns["ShipAddress"].HeaderText = "Ship Address"; this.gridGroupingControl1.GetTableDescriptor("Orders").Columns["RequiredDate"].HeaderText = "Required Date"; this.gridGroupingControl1.GetTableDescriptor("Orders").Columns["OrderID"].HeaderText = "Order ID"; this.gridGroupingControl1.GetTableDescriptor("Orders").Columns["OrderDate"].HeaderText = "Order Date"; this.gridGroupingControl1.ShowGroupDropArea = true; this.gridGroupingControl1.TableOptions.GridLineBorder = new Syncfusion.Windows.Forms.Grid.GridBorder(GridBorderStyle.Solid, Color.FromArgb(208, 215, 229), GridBorderWeight.Thin); this.gridGroupingControl1.TopLevelGroupOptions.ShowAddNewRecordBeforeDetails = false; this.gridGroupingControl1.TopLevelGroupOptions.ShowCaption = false; eventTracer1.output.ControllerOptions = GridControllerOptions.All & (~GridControllerOptions.OleDataSource); eventTracer1.output.ResetVolatileData(); eventTracer1.output.ColWidths[1] = 200; eventTracer1.output.ColWidths[2] = 1000; eventTracer1.output.GridVisualStyles = GridVisualStyles.Metro; eventTracer1.output.DefaultGridBorderStyle = GridBorderStyle.None; eventTracer1.output.Properties.GridLineColor = Color.FromArgb(208, 215, 229); GridStyleInfo style = eventTracer1.output.BaseStylesMap["Header"].StyleInfo; style.TextColor = Color.MidnightBlue; style.Font.Facename = "Verdana"; eventTracer1.output.RowHeights[0] = 0; eventTracer1.output.ColWidths[0] = 0; eventTracer1.output.RowCount = 0; eventTracer1.output.ColCount = 2; eventTracer1.output.ListBoxSelectionMode = SelectionMode.One; //used to set GridCaptionRowHeight. this.gridGroupingControl1.Table.DefaultCaptionRowHeight = 25; this.gridGroupingControl1.Table.DefaultColumnHeaderRowHeight = 30; this.gridGroupingControl1.Table.DefaultRecordRowHeight = 22; eventTracer1.output.QueryCellInfo += new GridQueryCellInfoEventHandler(Output_QueryCellInfo); eventTracer1.output.CurrentCellStartEditing += new CancelEventHandler(Output_CurrentCellStartEditing); this.gridGroupingControl1.TableOptions.GridVisualStyles = Syncfusion.Windows.Forms.GridVisualStyles.Metro; //Navigate to other control using tabkey navigation this.gridGroupingControl1.WantTabKey = false; #region // // panel2 // this.panel2.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.panel2.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; this.panel2.Controls.Add(this.eventTracer1); this.panel2.Location = new System.Drawing.Point(1, 500); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(854, 148); this.panel2.TabIndex = 8; // // eventTracer1 // this.eventTracer1.Dock = System.Windows.Forms.DockStyle.Fill; this.eventTracer1.Enabled = false; this.eventTracer1.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.eventTracer1.ForeColor = System.Drawing.Color.DimGray; this.eventTracer1.Location = new System.Drawing.Point(0, 0); this.eventTracer1.Name = "eventTracer1"; this.eventTracer1.Size = new System.Drawing.Size(852, 146); this.eventTracer1.TabIndex = 12; tracer = new Tracer(this.gridGroupingControl1.Engine, eventTracer1); this.Controls.Add(this.panel2); #endregion }
/// <summary> /// GridGrouping control getting started customization. /// </summary> private void GridSettings() { #region "Data Source" String commandstring1 = "select * from Employees"; String commandstring2 = "select * from Orders"; SqlCeDataAdapter da1 = new SqlCeDataAdapter(commandstring1, connString); SqlCeDataAdapter da2 = new SqlCeDataAdapter(commandstring2, connString); try { da1.Fill(dataset11, "Employees"); da2.Fill(dataset11, "Orders"); } catch (SqlException ex) { ShowErrorMessage(ex); } #endregion //used to set multiextended selection mode in gridgrouping control. this.gridGroupingControl1.TableOptions.ListBoxSelectionMode = SelectionMode.MultiExtended; this.gridGroupingControl1.ShowGroupDropArea = true; this.gridGroupingControl1.TableOptions.GridLineBorder = new Syncfusion.Windows.Forms.Grid.GridBorder(GridBorderStyle.Solid, Color.FromArgb(208, 215, 229), GridBorderWeight.Thin); this.gridGroupingControl1.TopLevelGroupOptions.ShowAddNewRecordBeforeDetails = false; this.gridGroupingControl1.TopLevelGroupOptions.ShowCaption = false; this.eventTracer1 = new ComboboxCells.EventTracer(); // // eventTracer1 // this.eventTracer1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.eventTracer1.Enabled = false; this.eventTracer1.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.eventTracer1.ForeColor = System.Drawing.Color.DimGray; this.eventTracer1.Location = new System.Drawing.Point(10, 32); this.eventTracer1.Name = "eventTracer1"; this.eventTracer1.Size = new System.Drawing.Size(824, 166); this.eventTracer1.TabIndex = 13; this.panel2.Controls.Add(this.eventTracer1); eventTracer1.output.ControllerOptions = GridControllerOptions.All & (~GridControllerOptions.OleDataSource); eventTracer1.output.ResetVolatileData(); eventTracer1.output.ColWidths[1] = 200; eventTracer1.output.ColWidths[2] = 1000; eventTracer1.output.GridVisualStyles = GridVisualStyles.Metro; eventTracer1.output.DefaultGridBorderStyle = GridBorderStyle.None; eventTracer1.output.Properties.GridLineColor = Color.FromArgb(208, 215, 229); GridStyleInfo style = eventTracer1.output.BaseStylesMap["Header"].StyleInfo; eventTracer1.output.RowHeights[0] = 0; eventTracer1.output.ColWidths[0] = 0; eventTracer1.output.RowCount = 0; eventTracer1.output.ColCount = 2; eventTracer1.output.ListBoxSelectionMode = SelectionMode.One; eventTracer1.output.QueryCellInfo += new GridQueryCellInfoEventHandler(Output_QueryCellInfo); eventTracer1.output.CurrentCellStartEditing += new CancelEventHandler(Output_CurrentCellStartEditing); tracer = new Tracer(this.gridGroupingControl1.Engine, eventTracer1); this.gridGroupingControl1.GridVisualStyles = GridVisualStyles.Metro; //used to set GridCaptionRowHeight. this.gridGroupingControl1.Table.DefaultCaptionRowHeight = 25; this.gridGroupingControl1.Table.DefaultColumnHeaderRowHeight = 30; this.gridGroupingControl1.Table.DefaultRecordRowHeight = 22; //Navigate to other control using tabkey navigation this.gridGroupingControl1.WantTabKey = false; #region HeaderText 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; } #endregion }