/// <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
}
