/// <summary> /// Required Method for sample level customization. /// </summary> void SampleCustomization() { this.gridGroupingControl1.TopLevelGroupOptions.ShowFilterBar = true; this.gridGroupingControl1.NestedTableGroupOptions.ShowFilterBar = true; this.gridGroupingControl1.ChildGroupOptions.ShowFilterBar = true; //Enable the filter for each columns for (int i = 0; i < gridGroupingControl1.TableDescriptor.Columns.Count; i++) { gridGroupingControl1.TableDescriptor.Columns[i].AllowFilter = true; } GridTableDescriptor childDesc = gridGroupingControl1.GetTableDescriptor("Orders"); for (int j = 0; j < childDesc.Columns.Count; j++) { childDesc.Columns[j].AllowFilter = true; } //Enable dynamic filter. this.gridGroupingControl1.TableModel.EnableLegacyStyle = false; filter.WireGrid(gridGroupingControl1); 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; } }
/// <summary> /// GridGrouping control getting started customization. /// </summary> private void GridSettings() { #region "Data Source" String commandstring1 = "select * from Customers"; String commandstring2 = "select * from Orders"; this.dataSet11 = new EnhancedVisualStyleInGGCDemo_2005.DataSet1(); this.dataSet11.DataSetName = "DataSet1"; this.dataSet11.Locale = new System.Globalization.CultureInfo("en-US"); this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; SqlCeDataAdapter da1 = new SqlCeDataAdapter(commandstring1, connString); SqlCeDataAdapter da2 = new SqlCeDataAdapter(commandstring2, connString); da1.Fill(dataSet11, "Customers"); da1.Fill(dataSet11, "Orders"); //used to set multiextended selection mode in gridgrouping control. this.gridGroupingControl1.TableOptions.ListBoxSelectionMode = SelectionMode.MultiExtended; this.gridGroupingControl1.TableControl.DpiAware = true; //used to set GridCaptionRowHeight. this.gridGroupingControl1.Table.DefaultCaptionRowHeight = (int)DpiAware.LogicalToDeviceUnits(25.0f); this.gridGroupingControl1.Table.DefaultColumnHeaderRowHeight = (int)DpiAware.LogicalToDeviceUnits(30.0f); this.gridGroupingControl1.Table.DefaultRecordRowHeight = (int)DpiAware.LogicalToDeviceUnits(22.0f); this.MetroColor = System.Drawing.Color.Transparent; this.gridGroupingControl1.DataSource = this.dataSet11.Customers; this.gridGroupingControl1.DataSource = this.dataSet11.Tables["Customers"]; this.gridGroupingControl1.AddGroupDropArea("Orders"); #endregion //Enable the filter for each columns for (int i = 0; i < gridGroupingControl1.TableDescriptor.Columns.Count; i++) { gridGroupingControl1.TableDescriptor.Columns[i].AllowFilter = true; } GridTableDescriptor childDesc = gridGroupingControl1.GetTableDescriptor("Orders"); for (int j = 0; j < childDesc.Columns.Count; j++) { childDesc.Columns[j].AllowFilter = true; } this.gridGroupingControl1.TableModel.EnableLegacyStyle = false; this.gridGroupingControl1.GridVisualStyles = GridVisualStyles.Metro; //Enable dynamic filter. filter.WireGrid(gridGroupingControl1); this.gridGroupingControl1.TopLevelGroupOptions.ShowAddNewRecordBeforeDetails = false; this.gridGroupingControl1.TopLevelGroupOptions.ShowCaption = false; this.gridGroupingControl1.NestedTableGroupOptions.ShowAddNewRecordBeforeDetails = false; this.gridGroupingControl1.TopLevelGroupOptions.ShowFilterBar = true; this.gridGroupingControl1.NestedTableGroupOptions.ShowFilterBar = true; this.gridGroupingControl1.ChildGroupOptions.ShowFilterBar = true; this.gridGroupingControl1.TableDescriptor.Columns["CompanyName"].HeaderText = "Company Name"; this.gridGroupingControl1.TableDescriptor.Columns["ContactName"].HeaderText = "Contact Name"; this.gridGroupingControl1.TableDescriptor.Columns["ContactTitle"].HeaderText = "Contact Title"; this.gridGroupingControl1.TableDescriptor.Columns["PostalCode"].HeaderText = "Postal Code"; 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.GetTableDescriptor("Orders").Columns["EmployeeID"].HeaderText = "Employee ID"; }