/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.gridGroupingControl = new GridGroupingControl();
this.panel = new Panel();
((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl)).BeginInit();
this.panel.SuspendLayout();
this.SuspendLayout();
//
// gridGroupingControl
//
this.gridGroupingControl.Anchor = ((AnchorStyles)((((AnchorStyles.Top | AnchorStyles.Bottom)
| AnchorStyles.Left)
| AnchorStyles.Right)));
this.gridGroupingControl.BackColor = Color.White;
this.gridGroupingControl.BrowseOnly = true;
this.gridGroupingControl.ForeColor = Color.Black;
this.gridGroupingControl.Location = new Point(0, 0);
this.gridGroupingControl.MinimumSize = new Size(584, 376);
this.gridGroupingControl.Name = "gridGroupingControl";
this.gridGroupingControl.ShowCurrentCellBorderBehavior = GridShowCurrentCellBorder.HideAlways;
this.gridGroupingControl.ShowRowHeaders = false;
this.gridGroupingControl.Size = new Size(779, 431);
this.gridGroupingControl.TabIndex = 1;
this.gridGroupingControl.TableDescriptor.AllowEdit = false;
this.gridGroupingControl.Text = "GridGroupingControl";
this.gridGroupingControl.TopLevelGroupOptions.ShowAddNewRecordBeforeDetails = false;
this.gridGroupingControl.TopLevelGroupOptions.ShowCaption = false;
this.gridGroupingControl.UseRightToLeftCompatibleTextBox = true;
this.gridGroupingControl.VersionInfo = "15.2460.0.46";
//
// panel
//
this.panel.Anchor = ((AnchorStyles)((((AnchorStyles.Top | AnchorStyles.Bottom)
| AnchorStyles.Left)
| AnchorStyles.Right)));
this.panel.BackColor = Color.White;
this.panel.BorderStyle = BorderStyle.FixedSingle;
this.panel.Controls.Add(this.gridGroupingControl);
this.panel.ForeColor = Color.DarkGray;
this.panel.Location = new Point(12, 0);
this.panel.MinimumSize = new Size(584, 376);
this.panel.Name = "panel";
this.panel.Size = new Size(781, 431);
this.panel.TabIndex = 0;
//
// GridView Layout
//
this.AutoScaleDimensions = new SizeF(6F, 13F);
this.AutoScaleMode = AutoScaleMode.Font;
this.ClientSize = new Size(805, 443);
this.Controls.Add(this.panel);
this.Font = new Font("Segoe UI", 8.25F, FontStyle.Regular, GraphicsUnit.Point, ((byte)(0)));
this.MinimumSize = new Size(600, 500);
this.Name = "GridView";
this.StartPosition = FormStartPosition.CenterParent;
this.Text = string.Empty;
((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl)).EndInit();
this.panel.ResumeLayout(false);
this.ResumeLayout(false);
}
/// <summary>
/// The GridPrinter constructor. Initializes the GridPrinter object with passed values.
/// </summary>
/// <param name="tblName"> The name of the table to print. </param>
/// <param name="grid"> The grid displaying the database contents. </param>
/// <param name="database"> The data object containing the database values. </param>
/// <param name="ev"> The print event from a PrintPage event. </param>
public GridPrinter(string tblName, ref GridGroupingControl grid, ref DataSet database, PrintPageEventArgs ev)
{
databaseGrid = grid;
tableName = tblName;
e = ev;
db = database;
}
/// <summary>
/// GridGrouping control getting started customization.
/// </summary>
private void GridSettings()
{
this.gridGroupingControl1 = new GridGroupingControl();
this.gridGroupingControl1.BorderStyle = BorderStyle.None;
this.gridGroupingControl1.Location = new Point(10, 10);
this.gridGroupingControl1.Size = new Size(755, 307);
this.gridGroupingControl1.Dock = DockStyle.Fill;
this.panel1.Controls.Add(this.gridGroupingControl1);
this.gridGroupingControl1.GridVisualStyles = GridVisualStyles.Metro;
this.gridGroupingControl1.TopLevelGroupOptions.ShowAddNewRecordBeforeDetails = false;
this.gridGroupingControl1.ShowGroupDropArea = true;
this.gridGroupingControl1.IsDynamicData = true;
//For setting filetr for columns
foreach (GridColumnDescriptor col in this.gridGroupingControl1.TableDescriptor.Columns)
{
col.AllowFilter = true;
}
this.comboBoxAdv1.Text = "Expando Object";
//used to set multiextended selection mode in gridgrouping control.
this.gridGroupingControl1.TableOptions.ListBoxSelectionMode = SelectionMode.MultiExtended;
//used to set GridCaptionRowHeight.
this.gridGroupingControl1.Table.DefaultCaptionRowHeight = 25;
this.gridGroupingControl1.Table.DefaultColumnHeaderRowHeight = 30;
this.gridGroupingControl1.Table.DefaultRecordRowHeight = 22;
this.gridGroupingControl1.AllowProportionalColumnSizing = true;
//Navigate to other control using tabkey navigation
this.gridGroupingControl1.WantTabKey = false;
}
/// <summary>
/// Adds tree node support to a GridGroupingControl whose datasource is a DataTable with
/// a self-reference.
/// </summary>
/// <param name="grid">The GridGroupingControl.</param>
/// <param name="dataSource">The DataTable with a column that references to primary key values for the same DataTable. This means there is a field that refers to another DataRow in the same DataTable.</param>
/// <param name="selfReferenceColumn">The is the name of the column that refers to the primary key value that identifies another DataRow in the DataTabale.</param>
/// <param name="idColumn">The primary key column for the DataTable.</param>
/// <param name="nodeColumn">The name of the column that should appear in the +/- expansion cell.</param>
/// <returns>An accessor object (generally for internal use) that maps rowindexes to tree node objects.</returns>
public SelfReferenceDataSourceAccessor WireSelfReferenceGrid(GridGroupingControl grid, DataTable dataSource, string selfReferenceColumn, string idColumn, string nodeColumn)
{
this.rowIndexer = new NodeArray(dataSource.DefaultView);
this.grid = grid;
this.grid.TopLevelGroupOptions.ShowAddNewRecordBeforeDetails = false;
this.grid.TopLevelGroupOptions.ShowCaption = false;
this.selfReferenceProperty = selfReferenceColumn;
this.idProperty = idColumn;
this.nodeProperty = nodeColumn;
this.accessor = new SelfReferenceDataSourceAccessor(dataSource, selfReferenceColumn, idColumn);
this.grid.DataSource = this.rowIndexer;// accessor.GetRootDataView();
WireGrid(grid, accessor.GetRootDataView(), accessor);
//make sure nodeColumn is the first one...
GridColumnDescriptor gbc = grid.TableDescriptor.Columns[nodeColumn];
if (gbc == null)
{
throw new Exception(string.Format("{0} is missing from the grid.", nodeColumn));
}
int loc = grid.TableDescriptor.Columns.IndexOf(gbc);
if (loc != 0)
{
grid.TableDescriptor.Columns.Move(loc, 0);
}
foreach (GridColumnDescriptor cd in grid.TableDescriptor.Columns)
{
cd.AllowSort = false;
}
return(accessor);
}
/// <summary>
/// Does some low level initializations. Generally, you should use the WireSelfReferenceGrid method which, in turn, will
/// call WireGrid.
/// </summary>
/// <param name="grid">The GridDataBoundGrid</param>
/// <param name="parentList">The parentList</param>
/// <param name="dataSource">The dataSource that serves as an ITreeGridDataSource.</param>
public void WireGrid(GridGroupingControl grid, IList parentList, ITreeGridDataSource dataSource)
{
this.grid = grid;
this.grid.TableControl.BeginUpdate();
//used by renderer to access rowindexer
this.grid.TableControl.Model.TableStyle.Tag = this;
this.dataSource = dataSource;
if (!this.grid.TableControl.Model.CellModels.ContainsKey("GridTreeCell"))
{
this.grid.TableControl.Model.CellModels.Add("GridTreeCell", new GridDataBoundTreeCellModel(this.grid.TableControl.Model, this));
}
this.grid.TableDescriptor.Columns[nodeProperty].Appearance.AnyRecordFieldCell.CellType = "GridTreeCell";
WireTreeLineEvents();
rowIndexer.Clear();
PopulateIndexer(0, parentList, 0);
this.grid.TableControl.Model.ResetVolatileData();
this.grid.TableControl.Model.ColWidths.ResizeToFit(GridRangeInfo.Col(2));
this.grid.TableControl.EndUpdate();
this.grid.TableControl.Refresh();
}
public GroupingGridPropertyDialog(GridGroupingControl grid)
{
InitializeComponent();
try
{
System.Drawing.Icon ico = new System.Drawing.Icon(GetIconFile(@"Common\Images\Grid\Icon\sfgrid.ico"));
this.Icon = ico;
}
catch
{}
this.grid = grid;
this.grid.FilterRuntimeProperties = true;
propertyGrid.SelectedObject = grid;
if (propertyGrid != null)
{
this.pgMenu = new PropertyGridContextMenu(this.propertyGrid);
}
this.grid.PropertyChanged += new DescriptorPropertyChangedEventHandler(grid_PropertyChanged);
this.grid.TableDescriptor.PropertyChanged += new DescriptorPropertyChangedEventHandler(TableDescriptor_PropertyChanged);
this.grid.Engine.SourceListChanged += new EventHandler(Engine_SourceListChanged);
Application.Idle += new EventHandler(Application_Idle);
}
/// <summary>
/// Optimizing the Grid performance to redue its memory usage.
/// </summary>
/// <param name="grid"></param>
void OptimizeGridSettings(GridGroupingControl grid)
{
grid.CounterLogic = EngineCounters.YAmount;
grid.AllowedOptimizations = EngineOptimizations.DisableCounters | EngineOptimizations.RecordsAsDisplayElements;
grid.UseDefaultsForFasterDrawing = true; // GDI interop drawing, FirstNRecords Summaries
grid.InvalidateAllWhenListChanged = false; // only paint modified cells
//grid.InsertRemoveBehavior = GridListChangedInsertRemoveBehavior.ScrollWithImmediateUpdate;
grid.UpdateDisplayFrequency = 50; // update every number of ms (speciy 0 if Update should occur manually, 1 if immediately)
//grid.TableControl.EnableDoubleBufferSurface(); // reduce flickering
grid.BlinkTime = 700;
// Instruct grouping control not to access datasource through
// CurrencyManager API and instead access list diretly. When set to
// false you wil howver loose support for built-in CurrencyManager
// synchronization.
grid.BindToCurrencyManager = false;
if (typeof(object).AssemblyQualifiedName.IndexOf("Version=1") == -1)
{
// .NET 2.0 gets very slow when subscribing to ListChanged event on the
// DataTable.DefaultView. The following setting allows the engine to wrap
// datatable with a Syncfusion.Collections.DataTableList to work around
// this bottleneck.
//
// .NET 1.0 and 1.1 are just fine with using DataTable.DefaultView
//
grid.AllowSwapDataViewWithDataTableList = true;
}
}
// QueryCellInfo even is hooked to set the values.
private void gridGroupingControl1_QueryCellStyleInfo(object sender, Syncfusion.Windows.Forms.Grid.Grouping.GridTableCellStyleInfoEventArgs e)
{
switch (e.TableCellIdentity.TableCellType)
{
case GridTableCellType.RecordPreviewCell:
{
GridGroupingControl groupingControl = (GridGroupingControl)sender;
GridTable table = groupingControl.Table;
GridRecord record = e.TableCellIdentity.DisplayElement.ParentRecord as GridRecord;
if (record != null)
{
e.Style.CellValue = record.GetValue("Notes").ToString();
}
else
{
e.Style.CellValue = "No Notes.";
}
break;
}
}
StringBuilder sb = new StringBuilder();
sb.Append(e.TableCellIdentity.Info);
if (e.Style != null)
{
sb.AppendFormat("\r\nCellType = {0}", e.Style.CellType);
sb.AppendFormat(", CellValueType = {0}", e.Style.CellValueType);
sb.AppendFormat(", nFormat = \"{0}\"", e.Style.Format);
sb.AppendFormat(", CellValue = \"{0}\"", e.Style.CellValue);
sb.AppendFormat(", ImageSizeMode = \"{0}\"", e.Style.ImageSizeMode);
}
e.Style.CellTipText = sb.ToString();
}
/// <summary>
/// Wires the paging helper with GridGroupingControl.
/// </summary>
/// <param name="groupingGrid">GridGroupingControl</param>
/// <param name="table">DataTable</param>
public async void Wire(GridGroupingControl groupingGrid, HqlDataReader dr)
{
_grid = groupingGrid;
Reader = dr;
ResultSet = await dr.FetchResultAsync();
InitializePager();
}
public Form1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
if (DpiAware.GetCurrentDpi() > 96)
{
this.CaptionBarHeight = (int)DpiAware.LogicalToDeviceUnits(this.CaptionBarHeight);
}
gridGroupingControl1 = new GridGroupingControl();
// now assign the datasource
gridGroupingControl1.DataSource = table;
SampleCustomization();
GridSettings();
Console.WriteLine(GridPropertyTypeDefaultStyleCollection.Default["System.Boolean"].Style);
// enable/disable UITYpeEditors for boolean cells only and show checkbox instead.
bool displayCheckBoxForBooleanFields = false;
if (displayCheckBoxForBooleanFields)
{
GridPropertyTypeDefaultStyle booleanDefault = this.gridGroupingControl1.Engine.PropertyTypeDefaultStyles["System.Boolean"];
booleanDefault.AllowDropDown = false;
}
#region Sample code to get the row and column index
// Sample code to get the row and column index in the grid for a column (works also
// if column sets with multiple rows are specified).
bool useOldCodeToGetCellInfo = false;
if (useOldCodeToGetCellInfo)
{
GridColumnDescriptor cd = this.gridGroupingControl1.TableDescriptor.Columns["Boolean"];
int relativeRowIndex, colIndex;
this.gridGroupingControl1.TableDescriptor.ColumnToRowColIndex(cd.MappingName, out relativeRowIndex, out colIndex);
Record r = this.gridGroupingControl1.Table.Records[0];
int recordRowIndex = this.gridGroupingControl1.Table.DisplayElements.IndexOf(r);
int rowIndex = recordRowIndex + relativeRowIndex;
GridTableCellStyleInfo style = this.gridGroupingControl1.Table.GetTableCellStyle(rowIndex, colIndex + this.gridGroupingControl1.TableDescriptor.GetColumnIndentCount());
Console.WriteLine(style.TableCellIdentity.ToString());
Console.WriteLine(style.ToString());
}
else
{
// Newer code using new GetTableCellStyle overloads after version 3.0.0.16
Record r = this.gridGroupingControl1.Table.Records[0];
GridTableCellStyleInfo style = this.gridGroupingControl1.Table.GetTableCellStyle(r, "Boolean");
Console.WriteLine(style.TableCellIdentity.ToString());
Console.WriteLine(style.ToString());
}
#endregion
}
/// <summary>
/// Wires the paging helper with GridGroupingControl.
/// </summary>
/// <param name="groupingGrid">GridGroupingControl</param>
/// <param name="table">DataTable</param>
public async void Wire(GridGroupingControl groupingGrid, String tableName, HBaseConnection con, Panel loaderPic)
{
commonLoaderPic = loaderPic;
_grid = groupingGrid;
this.tableName = tableName;
this.con = con;
ResultSet = await HBaseOperation.ScanTableAsync(tableName, con);
InitializePager();
}
public GridAdapter(GridGroupingControl grid)
{
if (grid == null)
{
throw new ArgumentNullException("grid");
}
_grid = grid;
SetDefaults();
AttachEvents();
}
public void ApplyTo(Form1 form)
{
bool currentCustomEngine = form.gridGroupingControl1.Engine is GroupingEngine;
// Create a new GridGroupingControl with new engine
form.Controls.Remove(form.gridGroupingControl1);
if (this.useCustomEngine)
{
form.gridGroupingControl1 = new GridGroupingControl(new GroupingEngine());
}
else
{
form.gridGroupingControl1 = new GridGroupingControl();
}
form.gridGroupingControl1.BackColor = System.Drawing.SystemColors.Window;
form.gridGroupingControl1.Dock = System.Windows.Forms.DockStyle.Fill;
form.gridGroupingControl1.ClientSize = new Size(380, 300);
form.gridGroupingControl1.Location = new Point(20, 18);
form.gridGroupingControl1.Name = "gridGroupingControl1";
form.gridGroupingControl1.TabIndex = 0;
form.gridGroupingControl1.VersionInfo = "3.2.0.0";
form.gridGroupingControl1.IntelliMousePanning = true;
//form.Controls.Add(form.gridGroupingControl1);
form.Controls["panel2"].Controls.Add(form.gridGroupingControl1);
GridGroupingControl grid = form.gridGroupingControl1;
grid.DataSource = null;
grid.Engine = schema; // will call Engine.InitializeFrom in setter.
switch (this.dataSourceType)
{
case DataSourceType.None:
grid.DataSource = null;
break;
case DataSourceType.FlatVirtualList:
grid.DataSource = new TestEngineOptimizations.VirtualList(this.recordCount);
break;
case DataSourceType.FlatDataView:
{
grid.DataSource = GetDataTable(100, this.recordCount);
break;
}
}
grid.ShowGroupDropArea = this.allowGrouping;
grid.VerticalThumbTrack = this.AllowThumbtracking;
}
private void gridGroupingControl1_QueryCellStyleInfo(object sender, GridTableCellStyleInfoEventArgs e)
{
GridGroupingControl groupingControl = (GridGroupingControl)sender;
Element el = e.TableCellIdentity.DisplayElement;
e.Style.CellTipText = el.GetType().Name + (el.ParentElement != null ? " (Parent: " + el.ParentElement.GetType().Name + ")" : "");
if (el is ExtraSection)
{
if (e.Style.TableCellIdentity.ColIndex == 0)
{
// Row Header
e.Style.CellType = ((GridTableDescriptor)el.ParentTableDescriptor).Appearance.RecordRowHeaderCell.CellType;
if (el == el.ParentTable.CurrentElement)
{
e.Style.Text = "#";
}
}
else if (e.Style.TableCellIdentity.ColIndex <= el.GroupLevel)
{
// Group Indent
e.Style.BackColor = Color.FromArgb(218, 229, 245);
}
else if (e.Style.TableCellIdentity.ColIndex <= extraSectionCoverCols + el.ParentTableDescriptor.GroupedColumns.Count)
{
// Covered area (see TableModel_QueryCoveredRange above)
e.Style.BackColor = Color.FromArgb(192, 201, 219);
e.Style.CellValue = "ExtraSection (" + el.ParentGroup.Name + ")";
}
else if (e.Style.TableCellIdentity.ColIndex > 3)
{
e.Style.BackColor = Color.FromArgb(252, 172, 38);
// you can get the column as follows:
GridTable table = (GridTable)el.ParentTable;
GridTableDescriptor td = e.TableCellIdentity.Table.TableDescriptor;
GridColumnDescriptor column = td.RecordRowColumns[0, e.Style.TableCellIdentity.ColIndex - el.ParentTableDescriptor.GroupedColumns.Count - 1];
e.Style.CellValue = column.Name;
// Using that column you could try and identify the summary that should be displayed in this cell.
if (column.MappingName == "Freight")
{
// Calling this method to demonstrate different alternatives to get to the summary text
e.Style.Text = GetSummaryText(el.ParentGroup, "SummaryRow 1", "FreightAverage");
// Easier is to simple call built-in routine:
e.Style.Text = GridEngine.GetSummaryText(el.ParentGroup, "SummaryRow 1", "FreightAverage");
}
}
}
}
/// <summary>
/// Disconnects this TreeHelper from its GridDataBoundGrid.
/// </summary>
public void UnwireGrid()
{
if (this.grid.TableControl != null)
{
this.grid.TableControl.BeginUpdate();
this.grid.TableControl.Model.TableStyle.Tag = null;
UnwireTreeLineEvents();
this.grid.TableControl.Model.ColWidths.ResizeToFit(GridRangeInfo.Col(TREECOLUMN));
this.grid.TableControl.EndUpdate();
this.grid.TableControl.Refresh();
this.grid = null;
}
}
public GridFindReplaceDialog(GridGroupingControl groupinggrid, string themeStyle)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
//System.Drawing.Icon ico = new System.Drawing.Icon(GetIconFile(@"Common\Images\Grid\Icon\sficon.ico"));
//this.Icon = ico;
grid = groupinggrid;
frDialog = new GridFindReplaceDialogSink(grid.TableControl);
options = GridFindTextOptions.None;
this.comboBox1.SelectedIndex = 0;
grid.QueryCellStyleInfo += new GridTableCellStyleInfoEventHandler(grid_QueryCellStyleInfo);
this.Icon = new System.Drawing.Icon(GetIconFile(@"Common\Images\Grid\Icon\sficon.ico"));
}
public TableResetForm(ref GridGroupingControl dbGrid, ref DataSet db)
{
InitializeComponent();
databaseGrid = dbGrid;
database = db;
// Set a default value for the tableComboBox
tableComboBox.SelectedIndex = 0;
// Set message box colors to purple.
MessageBoxAdv.MetroColorTable.BorderColor = System.Drawing.Color.Purple;
MessageBoxAdv.MetroColorTable.YesButtonBackColor = System.Drawing.Color.Purple;
MessageBoxAdv.MetroColorTable.NoButtonBackColor = System.Drawing.Color.Purple;
MessageBoxAdv.MetroColorTable.OKButtonBackColor = System.Drawing.Color.Purple;
}
//Used to setup the cell-specific formatting information
private void gridGroupingControl1_QueryCellStyleInfo(object sender, Syncfusion.Windows.Forms.Grid.Grouping.GridTableCellStyleInfoEventArgs e)
{
switch (e.TableCellIdentity.TableCellType)
{
case GridTableCellType.RecordPreviewCell:
{
GridGroupingControl groupingControl = (GridGroupingControl)sender;
GridTable table = groupingControl.Table;
GridRecord record = (GridRecord)e.TableCellIdentity.DisplayElement.ParentRecord;
e.Style.CellValue = record.GetValue("Notes").ToString();
break;
}
case GridTableCellType.AlternateRecordFieldCell:
case GridTableCellType.AddNewRecordFieldCell:
case GridTableCellType.RecordFieldCell:
{
GridTable table = e.TableCellIdentity.Table;
string tableName = table.TableDescriptor.Name;
GridRecord record = (GridRecord)e.TableCellIdentity.DisplayElement.ParentRecord;
object recordkey = record.PrimaryKeys[0];
string fieldName = e.TableCellIdentity.Column.MappingName;
GridStyleInfo style = GetCellStyle(tableName, recordkey, fieldName);
if (style != null)
{
e.Style.ModifyStyle(style, Syncfusion.Styles.StyleModifyType.Override);
}
break;
}
}
StringBuilder sb = new StringBuilder();
sb.Append(e.TableCellIdentity.Info);
if (e.Style != null)
{
sb.AppendFormat("\r\nCellType = {0}", e.Style.CellType);
sb.AppendFormat(", CellValueType = {0}", e.Style.CellValueType);
sb.AppendFormat(", nFormat = \"{0}\"", e.Style.Format);
sb.AppendFormat(", CellValue = \"{0}\"", e.Style.CellValue);
sb.AppendFormat(", ImageSizeMode = \"{0}\"", e.Style.ImageSizeMode);
}
e.Style.CellTipText = sb.ToString();
}
public GroupingGridPropertyDialog(GridGroupingControl grid)
{
InitializeComponent();
this.grid = grid;
this.grid.FilterRuntimeProperties = true;
propertyGrid.SelectedObject = grid;
if (propertyGrid != null)
{
this.pgMenu = new PropertyGridContextMenu(this.propertyGrid);
}
this.grid.PropertyChanged += new DescriptorPropertyChangedEventHandler(grid_PropertyChanged);
this.grid.TableDescriptor.PropertyChanged += new DescriptorPropertyChangedEventHandler(TableDescriptor_PropertyChanged);
this.grid.Engine.SourceListChanged += new EventHandler(Engine_SourceListChanged);
Application.Idle += new EventHandler(Application_Idle);
}
public CurrentView(ContactsPaneForm frm)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
cform = frm;
groupingGrid = frm.Grid;
SetFieldsLabel();
SetGroupByLabel();
SetSortLabel();
SetFilterLabel();
//
// TODO: Add any constructor code after InitializeComponent call
//
}
/// <summary>
/// The GridPrinter constructor. Initializes the GridPrinter object with passed values.
/// </summary>
/// <param name="tblName"> The name of the table to print. </param>
/// <param name="grid"> The grid displaying the database contents. </param>
/// <param name="database"> The data set containing the database values. </param>
/// <param name="ev"> The print event from a PrintPage event. </param>
public GridPrinter(string tblName, ref GridGroupingControl grid, ref DataSet database)
{
databaseGrid = grid;
tableName = tblName;
db = database;
// Set printing formatting.
format.Alignment = StringAlignment.Center;
format.LineAlignment = StringAlignment.Center;
format.Trimming = StringTrimming.EllipsisCharacter;
// Set the fonts and the logo on the report.
FontFamily fontFamily = new FontFamily("Microsoft Sans Serif");
drawFont = new Font(fontFamily, 8.25f, FontStyle.Regular, GraphicsUnit.Point);
headerFont = new Font(fontFamily, 8.25f, FontStyle.Bold);
colHeaderFont = new Font(fontFamily, 8.75f, FontStyle.Regular);
logo = new Bitmap(Properties.Resources.fecLogo);
}
public Form1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
if (DpiAware.GetCurrentDpi() > 96)
{
this.CaptionBarHeight = (int)DpiAware.LogicalToDeviceUnits(this.CaptionBarHeight);
}
//
// TODO: Add any constructor code after InitializeComponent call
//
configurations = new ConfigCollection();
configurations.Add(new Config("Reset Datasource"));
configurations.Add(new Config("Flat Virtual List, 30 million records, Virtual Mode"));
configurations.Add(new Config("Flat Virtual List, VirtualMode"));
configurations.Add(new Config("Flat Virtual List, No Optimizations"));
configurations.Add(new Config("Flat Virtual List, Using Custom Engine"));
configurations.Add(new Config("Flat Virtual List, Sorted"));
configurations.Add(new Config("Flat Virtual List, Grouped"));
configurations.Add(new Config("Flat Virtual List, Grouped, VerticalPixelScroll"));
configurations.Add(new Config("Flat DataView, VirtualMode, Pass-Through sorting enabled."));
configurations.Add(new Config("Flat DataView, VirtualMode, Pass-Through sorting disabled."));
configurations.Add(new Config("Flat DataView, Summaries."));
configurations.Add(new Config("Flat DataView, Grouped."));
//// configurations.Add(new Config());
InitializeSelectMenu();
gridGroupingControl1 = new GridGroupingControl();
Config con = new Config("Flat Virtual List, 30 million records, Virtual Mode");
con.ApplyTo(this);
GridSettings();
Log = new ListboxTextWriter(this.listBox1);
}
public FormatColumnsDialog(GridGroupingControl grid)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
this.groupingGrid = grid;
descColl = new GridColumnDescriptorCollection();
for (int i = 1; i < this.groupingGrid.TableDescriptor.VisibleColumns.Count; i++)
{
GridVisibleColumnDescriptor col = this.groupingGrid.TableDescriptor.VisibleColumns[i];
if (col != null)
{
this.comboBox1.Items.Add(col.Name);
}
}
this.listBox1.SelectedIndexChanged += new EventHandler(listBox1_SelectedIndexChanged);
this.colorPickerButton1.ColorSelected += new EventHandler(colorPickerButton1_ColorSelected);
this.colorPickerButton2.ColorSelected += new EventHandler(colorPickerButton2_ColorSelected);
//
// TODO: Add any constructor code after InitializeComponent call
//
}
public FilterDialog(GridGroupingControl grid)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
groupingGrid = grid;
for (int i = 0; i < this.groupingGrid.TableDescriptor.VisibleColumns.Count; i++)
{
GridVisibleColumnDescriptor col = this.groupingGrid.TableDescriptor.VisibleColumns[i];
if (col != null)
{
this.comboBox1.Items.Add(col.Name);
}
}
if (this.groupingGrid.TableDescriptor.RecordFilters.Count > 0)
{
foreach (RecordFilterDescriptor filter in groupingGrid.TableDescriptor.RecordFilters)
{
if (filter != null)
{
foreach (FilterCondition cond in filter.Conditions)
{
listBox1.Items.Add(cond.FilterDescriptor.FieldDescriptor.Name + " " + cond.CompareOperator.ToString() + " " + cond.CompareValue.ToString());
}
}
}
}
this.comboBox1.SelectedIndexChanged += new EventHandler(comboBox1_SelectedIndexChanged);
this.listBox1.SelectedIndexChanged += new EventHandler(listBox1_SelectedIndexChanged);
this.txtValue.TextChanged += new EventHandler(txtValue_TextChanged);
//
// TODO: Add any constructor code after InitializeComponent call
//
}
/// <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();
this.label1 = new System.Windows.Forms.Label();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.checkBox1 = new Syncfusion.Windows.Forms.Tools.CheckBoxAdv();
this.button3 = new Syncfusion.Windows.Forms.ButtonAdv();
this.button1 = new Syncfusion.Windows.Forms.ButtonAdv();
this.button2 = new Syncfusion.Windows.Forms.ButtonAdv();
this.button6 = new Syncfusion.Windows.Forms.ButtonAdv();
this.button4 = new Syncfusion.Windows.Forms.ButtonAdv();
this.button5 = new Syncfusion.Windows.Forms.ButtonAdv();
this.button7 = new Syncfusion.Windows.Forms.ButtonAdv();
this.Output = new System.Windows.Forms.ListBox();
this.gridGroupingControl1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl();
this.groupBox1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.checkBox1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).BeginInit();
this.SuspendLayout();
//
// label1
//
this.label1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.label1.Font = new System.Drawing.Font("Segoe UI", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label1.ForeColor = System.Drawing.Color.DimGray;
this.label1.Location = new System.Drawing.Point(10, 457);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(540, 16);
this.label1.TabIndex = 11;
this.label1.Text = "Event Log";
//
// groupBox1
//
this.groupBox1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Right)));
this.groupBox1.BackColor = System.Drawing.Color.Transparent;
this.groupBox1.Controls.Add(this.checkBox1);
this.groupBox1.Controls.Add(this.button3);
this.groupBox1.Controls.Add(this.button1);
this.groupBox1.Controls.Add(this.button2);
this.groupBox1.Controls.Add(this.button6);
this.groupBox1.Controls.Add(this.button4);
this.groupBox1.Controls.Add(this.button5);
this.groupBox1.Controls.Add(this.button7);
this.groupBox1.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.groupBox1.ForeColor = System.Drawing.Color.DimGray;
this.groupBox1.Location = new System.Drawing.Point(806, 12);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(194, 635);
this.groupBox1.TabIndex = 13;
this.groupBox1.TabStop = false;
this.groupBox1.Text = "Select Events";
//
// checkBox1
//
this.checkBox1.Anchor = System.Windows.Forms.AnchorStyles.Top;
this.checkBox1.BeforeTouchSize = new System.Drawing.Size(150, 21);
this.checkBox1.DrawFocusRectangle = false;
this.checkBox1.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.checkBox1.Location = new System.Drawing.Point(49, 331);
this.checkBox1.MetroColor = System.Drawing.Color.FromArgb(((int)(((byte)(27)))), ((int)(((byte)(161)))), ((int)(((byte)(226)))));
this.checkBox1.Name = "checkBox1";
this.checkBox1.Size = new System.Drawing.Size(115, 17);
this.checkBox1.Style = Syncfusion.Windows.Forms.Tools.CheckBoxAdvStyle.Metro;
this.checkBox1.DrawFocusRectangle = true;
this.checkBox1.TabIndex = 9;
this.checkBox1.Text = "Disable Tracing";
this.checkBox1.ThemesEnabled = false;
this.checkBox1.CheckStateChanged += new System.EventHandler(this.checkBox1_CheckedChanged);
//
// button3
//
this.button3.Anchor = System.Windows.Forms.AnchorStyles.Top;
this.button3.Appearance = Syncfusion.Windows.Forms.ButtonAppearance.Metro;
this.button3.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.button3.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(22)))), ((int)(((byte)(165)))), ((int)(((byte)(220)))));
this.button3.BeforeTouchSize = new System.Drawing.Size(130, 25);
this.button3.BorderStyleAdv = Syncfusion.Windows.Forms.ButtonAdvBorderStyle.RaisedInner;
this.button3.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button3.ForeColor = System.Drawing.Color.White;
this.button3.IsBackStageButton = false;
this.button3.Location = new System.Drawing.Point(23, 51);
this.button3.Name = "button3";
this.button3.Size = new System.Drawing.Size(150, 25);
this.button3.TabIndex = 1;
this.button3.Text = "Trace Grid Events";
this.button3.Click += new System.EventHandler(this.button3_Click);
//
// button1
//
this.button1.Anchor = System.Windows.Forms.AnchorStyles.Top;
this.button1.Appearance = Syncfusion.Windows.Forms.ButtonAppearance.Metro;
this.button1.FlatStyle = System.Windows.Forms.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(130, 25);
this.button1.BorderStyleAdv = Syncfusion.Windows.Forms.ButtonAdvBorderStyle.RaisedInner;
this.button1.Font = new System.Drawing.Font("Segoe UI", 8.25F, 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(23, 91);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(150, 25);
this.button1.TabIndex = 2;
this.button1.Text = "Trace Cell Events";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// button2
//
this.button2.Anchor = System.Windows.Forms.AnchorStyles.Top;
this.button2.Appearance = Syncfusion.Windows.Forms.ButtonAppearance.Metro;
this.button2.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.button2.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(22)))), ((int)(((byte)(165)))), ((int)(((byte)(220)))));
this.button2.BeforeTouchSize = new System.Drawing.Size(130, 25);
this.button2.BorderStyleAdv = Syncfusion.Windows.Forms.ButtonAdvBorderStyle.RaisedInner;
this.button2.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button2.ForeColor = System.Drawing.Color.White;
this.button2.IsBackStageButton = false;
this.button2.Location = new System.Drawing.Point(23, 131);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(150, 25);
this.button2.TabIndex = 3;
this.button2.Text = "Trace CurrentCell Events";
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// button6
//
this.button6.Anchor = System.Windows.Forms.AnchorStyles.Top;
this.button6.Appearance = Syncfusion.Windows.Forms.ButtonAppearance.Metro;
this.button6.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.button6.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(22)))), ((int)(((byte)(165)))), ((int)(((byte)(220)))));
this.button6.BeforeTouchSize = new System.Drawing.Size(130, 25);
this.button6.BorderStyleAdv = Syncfusion.Windows.Forms.ButtonAdvBorderStyle.RaisedInner;
this.button6.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button6.ForeColor = System.Drawing.Color.White;
this.button6.IsBackStageButton = false;
this.button6.Location = new System.Drawing.Point(23, 248);
this.button6.Name = "button6";
this.button6.Size = new System.Drawing.Size(150, 25);
this.button6.TabIndex = 7;
this.button6.Text = "Trace TableStyle Events";
this.button6.Click += new System.EventHandler(this.button6_Click);
//
// button4
//
this.button4.Anchor = System.Windows.Forms.AnchorStyles.Top;
this.button4.Appearance = Syncfusion.Windows.Forms.ButtonAppearance.Metro;
this.button4.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.button4.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(22)))), ((int)(((byte)(165)))), ((int)(((byte)(220)))));
this.button4.BeforeTouchSize = new System.Drawing.Size(130, 25);
this.button4.BorderStyleAdv = Syncfusion.Windows.Forms.ButtonAdvBorderStyle.RaisedInner;
this.button4.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button4.ForeColor = System.Drawing.Color.White;
this.button4.IsBackStageButton = false;
this.button4.Location = new System.Drawing.Point(23, 171);
this.button4.Name = "button4";
this.button4.Size = new System.Drawing.Size(150, 25);
this.button4.TabIndex = 5;
this.button4.Text = "Trace Key Events";
this.button4.Click += new System.EventHandler(this.button4_Click);
//
// button5
//
this.button5.Anchor = System.Windows.Forms.AnchorStyles.Top;
this.button5.Appearance = Syncfusion.Windows.Forms.ButtonAppearance.Metro;
this.button5.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.button5.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(22)))), ((int)(((byte)(165)))), ((int)(((byte)(220)))));
this.button5.BeforeTouchSize = new System.Drawing.Size(130, 25);
this.button5.BorderStyleAdv = Syncfusion.Windows.Forms.ButtonAdvBorderStyle.RaisedInner;
this.button5.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button5.ForeColor = System.Drawing.Color.White;
this.button5.IsBackStageButton = false;
this.button5.Location = new System.Drawing.Point(23, 211);
this.button5.Name = "button5";
this.button5.Size = new System.Drawing.Size(150, 25);
this.button5.TabIndex = 6;
this.button5.Text = "Trace Mouse Events";
this.button5.Click += new System.EventHandler(this.button5_Click);
//
// button7
//
this.button7.Anchor = System.Windows.Forms.AnchorStyles.Top;
this.button7.Appearance = Syncfusion.Windows.Forms.ButtonAppearance.Metro;
this.button7.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.button7.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(22)))), ((int)(((byte)(165)))), ((int)(((byte)(220)))));
this.button7.BeforeTouchSize = new System.Drawing.Size(130, 25);
this.button7.BorderStyleAdv = Syncfusion.Windows.Forms.ButtonAdvBorderStyle.RaisedInner;
this.button7.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button7.ForeColor = System.Drawing.Color.White;
this.button7.IsBackStageButton = false;
this.button7.Location = new System.Drawing.Point(23, 282);
this.button7.Name = "button7";
this.button7.Size = new System.Drawing.Size(150, 25);
this.button7.TabIndex = 8;
this.button7.Text = "Clear Output Window";
this.button7.Click += new System.EventHandler(this.button7_Click);
//
// Output
//
this.Output.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.Output.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
this.Output.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.Output.ForeColor = System.Drawing.Color.DimGray;
this.Output.Location = new System.Drawing.Point(11, 476);
this.Output.Name = "Output";
this.Output.Size = new System.Drawing.Size(775, 171);
this.Output.TabIndex = 14;
this.Output.TabStop = 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.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(11, 12);
this.gridGroupingControl1.Name = "gridGroupingControl1";
this.gridGroupingControl1.Size = new System.Drawing.Size(775, 438);
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";
this.gridGroupingControl1.TableDescriptor.TableOptions.ColumnHeaderRowHeight = 25;
this.gridGroupingControl1.TableDescriptor.TableOptions.RecordRowHeight = 25;
this.gridGroupingControl1.Text = "gridGroupingControl1";
this.gridGroupingControl1.VersionInfo = "4.301.0.0";
//
// Form1
//
this.ClientSize = new System.Drawing.Size(1012, 656);
this.MinimumSize = new System.Drawing.Size(850, 570);
this.Controls.Add(this.gridGroupingControl1);
this.Controls.Add(this.Output);
this.Controls.Add(this.groupBox1);
this.Controls.Add(this.label1);
this.Name = "Form1";
this.Text = "Table Control Events";
this.groupBox1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.checkBox1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).EndInit();
this.ResumeLayout(false);
}
public Form1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
// Setup the grid
gridGroupingControl1 = new GridGroupingControl();
gridGroupingControl1.VerticalThumbTrack = true;
gridGroupingControl1.HorizontalThumbTrack = true;
gridGroupingControl1.TableOptions.VerticalPixelScroll = true;
gridGroupingControl1.Dock = DockStyle.Fill;
this.panel2.Controls.Add(gridGroupingControl1);
gridGroupingControl1.TableOptions.ListBoxSelectionMode = SelectionMode.MultiExtended;
OptimizeGrid();
gridGroupingControl1.AllowSwapDataViewWithDataTableList = false; // we want to use "InsertAt" logice with .NET 2.0 ...
// Setup datatable with random data
InitializeDataTable();
gridGroupingControl1.DataSource = table;
// Highlight up and downticks
gridGroupingControl1.BlinkTime = 700; // in ms
for (int i = 1; i <= 20; i++)
{
gridGroupingControl1.TableDescriptor.Columns[i.ToString()].AllowBlink = true;
}
gridGroupingControl1.Engine.AddBaseStylesForBlinking();
gridGroupingControl1.BaseStyles[GridEngine.BlinkIncreased].StyleInfo.TextColor = Color.White;
gridGroupingControl1.BaseStyles[GridEngine.BlinkReduced].StyleInfo.TextColor = Color.White;
gridGroupingControl1.Engine.BaseStyles.Add("CustomStyle");
gridGroupingControl1.BaseStyles["CustomStyle"].StyleInfo.TextColor = Color.Black;
gridGroupingControl1.BaseStyles["CustomStyle"].StyleInfo.BackColor = Color.White;
this.gridGroupingControl1.TableControlPrepareViewStyleInfo += new GridTableControlPrepareViewStyleInfoEventHandler(gridGroupingControl1_TableControlPrepareViewStyleInfo);
gridGroupingControl1.TableDescriptor.Columns[0].MaxLength = 8;
gridGroupingControl1.TableDescriptor.Columns[5].MaxLength = 6;
gridGroupingControl1.TableDescriptor.Columns[9].MaxLength = 5;
gridGroupingControl1.TableDescriptor.Columns[14].MaxLength = 6;
gridGroupingControl1.TableDescriptor.Columns["1"].MaxLength = 8;
// Sort by column "1"
gridGroupingControl1.TableDescriptor.SortedColumns.Add("1");
//Optional: Filter records
//gridGroupingControl1.TableDescriptor.RecordFilters.Add("[2] > 88");
Console.WriteLine(gridGroupingControl1.TableDescriptor.Columns["1"].MaxLength);
this.textBoxFilter.Text = "[2] > 88";
this.gridGroupingControl1.PropertyChanged += new DescriptorPropertyChangedEventHandler(gridGroupingControl1_PropertyChanged);
this.gridGroupingControl1.ShowGroupDropArea = true;
// Timer
SetupTimer();
this.gridGroupingControl1.TableOptions.GridVisualStyles = Syncfusion.Windows.Forms.GridVisualStyles.Office2007Blue;
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;
gridGroupingControl1.Appearance.AnyCell.Font.Facename = "Segoe UI";
this.BackColor = Color.White;
this.propertyGrid1.BackColor = Color.White;
}
/// <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);
}
private void buttonRawValuationsExtract_Click(object sender, EventArgs e)
{
try
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "Files(*.XLS)|*.XLS";
saveFileDialog.AddExtension = true;
saveFileDialog.DefaultExt = ".XLS";
saveFileDialog.FileName = "MarkIt Raw Valuation Extract as of " + dtpMarketDate.Value.ToString("yyyy-MM-dd");
DataSet dsRawPrices =
MarketDataLogReportData.GetMarkItRawData(
Convert.ToDateTime(dtpMarketDate.Value.ToShortDateString()), null);
GridGroupingControl gridMarketRawValTemp=new GridGroupingControl();
gridMarketRawValTemp.TableDescriptor.AllowNew = false;
gridMarketRawValTemp.DataSource = dsRawPrices.Tables[0];
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
if (saveFileDialog.FileName.ToString() != "")
{
GroupingGridExcelConverterControl converterControl = new GroupingGridExcelConverterControl();
converterControl.GroupingGridToExcel(gridMarketRawValTemp,
saveFileDialog.FileName, Syncfusion.GridExcelConverter.ConverterOptions.Default);
MessageBox.Show("Successfully extracted MarkIt valuations!");
}
}
}
catch (Exception ex)
{
log.Error("Error in buttonRawValuationsExtract_Click:{0}", ex);
MessageBox.Show("Error happened when processing Valuations Extract!\n"+ex,"",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
}
/// <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();
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.panel1 = new System.Windows.Forms.Panel();
this.startTimerButton = new Syncfusion.Windows.Forms.ButtonAdv();
this.chartControl1 = new Syncfusion.Windows.Forms.Chart.ChartControl();
this.checkBox1 = new Syncfusion.Windows.Forms.Tools.CheckBoxAdv();
this.checkBoxAdv1 = new Syncfusion.Windows.Forms.Tools.CheckBoxAdv();
this.panel2 = new System.Windows.Forms.Panel();
((System.ComponentModel.ISupportInitialize)(this.northwindDataSet1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).BeginInit();
this.panel1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.checkBox1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.checkBoxAdv1)).BeginInit();
this.panel2.SuspendLayout();
this.SuspendLayout();
//
// northwindDataSet1
//
this.northwindDataSet1.DataSetName = "DataSet1";
this.northwindDataSet1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// gridGroupingControl1
//
this.gridGroupingControl1.BackColor = System.Drawing.SystemColors.Window;
this.gridGroupingControl1.DataSource = this.northwindDataSet1.Orders;
this.gridGroupingControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.gridGroupingControl1.FreezeCaption = false;
this.gridGroupingControl1.GridOfficeScrollBars = Syncfusion.Windows.Forms.OfficeScrollBars.Metro;
this.gridGroupingControl1.Location = new System.Drawing.Point(0, 0);
this.gridGroupingControl1.Name = "gridGroupingControl1";
this.gridGroupingControl1.Size = new System.Drawing.Size(545, 445);
this.gridGroupingControl1.TabIndex = 0;
//
// 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;
//
// 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(22, 22);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(545, 445);
this.panel1.TabIndex = 4;
//
// startTimerButton
//
this.startTimerButton.Appearance = Syncfusion.Windows.Forms.ButtonAppearance.Metro;
this.startTimerButton.FlatStyle = FlatStyle.Flat;
this.startTimerButton.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(22)))), ((int)(((byte)(165)))), ((int)(((byte)(220)))));
this.startTimerButton.BeforeTouchSize = new System.Drawing.Size(75, 19);
this.startTimerButton.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.startTimerButton.ForeColor = System.Drawing.Color.White;
this.startTimerButton.IsBackStageButton = false;
this.startTimerButton.Location = new System.Drawing.Point(20, 10);
this.startTimerButton.Name = "startTimerButton";
this.startTimerButton.Size = new System.Drawing.Size(75, 19);
this.startTimerButton.TabIndex = 3;
this.startTimerButton.Text = "Start Timer";
//
// chartControl1
//
this.chartControl1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Right)));
this.chartControl1.ChartArea.CursorLocation = new System.Drawing.Point(0, 0);
this.chartControl1.ChartArea.CursorReDraw = false;
this.chartControl1.DataSourceName = "";
this.chartControl1.IsWindowLess = false;
//
//
//
this.chartControl1.Legend.Location = new System.Drawing.Point(423, 75);
this.chartControl1.Localize = null;
this.chartControl1.Location = new System.Drawing.Point(590, 60);
this.chartControl1.Name = "chartControl1";
this.chartControl1.PrimaryXAxis.Crossing = double.NaN;
this.chartControl1.PrimaryXAxis.Margin = true;
this.chartControl1.PrimaryYAxis.Crossing = double.NaN;
this.chartControl1.PrimaryYAxis.Margin = true;
this.chartControl1.Size = new System.Drawing.Size(532, 407);
this.chartControl1.Skins = Syncfusion.Windows.Forms.Chart.Skins.Metro;
this.chartControl1.SpacingBetweenPoints = 15F;
this.chartControl1.TabIndex = 5;
this.chartControl1.Text = "Real Time Update";
//
//
//
this.chartControl1.Title.Name = "Default";
this.chartControl1.Titles.Add(this.chartControl1.Title);
//
// checkBox1
//
this.checkBox1.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.checkBox1.BeforeTouchSize = new System.Drawing.Size(151, 38);
this.checkBox1.Checked = true;
this.checkBox1.CheckState = System.Windows.Forms.CheckState.Checked;
this.checkBox1.DrawFocusRectangle = false;
this.checkBox1.Font = new System.Drawing.Font("Segoe UI", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.checkBox1.Location = new System.Drawing.Point(112, 4);
this.checkBox1.MetroColor = System.Drawing.Color.FromArgb(((int)(((byte)(17)))), ((int)(((byte)(158)))), ((int)(((byte)(218)))));
this.checkBox1.Name = "checkBox1";
this.checkBox1.Size = new System.Drawing.Size(151, 38);
this.checkBox1.Style = Syncfusion.Windows.Forms.Tools.CheckBoxAdvStyle.Metro;
this.checkBox1.DrawFocusRectangle = true;
this.checkBox1.TabIndex = 6;
this.checkBox1.Text = "Enable RealTime Update";
this.checkBox1.ThemesEnabled = false;
this.checkBox1.CheckStateChanged += new System.EventHandler(this.checkBox1_CheckStateChanged);
//
// checkBoxAdv1
//
this.checkBoxAdv1.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.checkBoxAdv1.BeforeTouchSize = new System.Drawing.Size(133, 35);
this.checkBoxAdv1.Checked = true;
this.checkBoxAdv1.CheckState = System.Windows.Forms.CheckState.Checked;
this.checkBoxAdv1.DrawFocusRectangle = false;
this.checkBoxAdv1.Font = new System.Drawing.Font("Segoe UI", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.checkBoxAdv1.Location = new System.Drawing.Point(291, 4);
this.checkBoxAdv1.MetroColor = System.Drawing.Color.FromArgb(((int)(((byte)(17)))), ((int)(((byte)(158)))), ((int)(((byte)(218)))));
this.checkBoxAdv1.Name = "checkBoxAdv1";
this.checkBoxAdv1.Size = new System.Drawing.Size(133, 35);
this.checkBoxAdv1.Style = Syncfusion.Windows.Forms.Tools.CheckBoxAdvStyle.Metro;
this.checkBoxAdv1.DrawFocusRectangle = true;
this.checkBoxAdv1.TabIndex = 7;
this.checkBoxAdv1.Text = "Selection/Actual View";
this.checkBoxAdv1.ThemesEnabled = false;
this.checkBoxAdv1.CheckStateChanged += new System.EventHandler(this.checkBoxAdv1_CheckStateChanged);
//
// panel2
//
this.panel2.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.panel2.Controls.Add(this.checkBoxAdv1);
this.panel2.Controls.Add(this.startTimerButton);
this.panel2.Controls.Add(this.checkBox1);
this.panel2.Location = new System.Drawing.Point(590, 12);
this.panel2.Name = "panel2";
this.panel2.Size = new System.Drawing.Size(427, 50);
this.panel2.TabIndex = 9;
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.ClientSize = new System.Drawing.Size(1134, 496);
this.Controls.Add(this.panel2);
this.Controls.Add(this.chartControl1);
this.Controls.Add(this.panel1);
this.MinimumSize = new System.Drawing.Size(1000, 553);
this.Name = "Form1";
this.Text = "Grid Vs Chart";
((System.ComponentModel.ISupportInitialize)(this.northwindDataSet1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).EndInit();
this.panel1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.checkBox1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.checkBoxAdv1)).EndInit();
this.panel2.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();
this.gridGroupingControl1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl();
this.panel1 = new System.Windows.Forms.Panel();
this.groupBox2 = new System.Windows.Forms.GroupBox();
this.button2 = new Syncfusion.Windows.Forms.ButtonAdv();
this.radioButton1 = new Syncfusion.Windows.Forms.Tools.RadioButtonAdv();
this.radioButton2 = new Syncfusion.Windows.Forms.Tools.RadioButtonAdv();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.checkBox2 = new Syncfusion.Windows.Forms.Tools.CheckBoxAdv();
this.checkBox3 = new Syncfusion.Windows.Forms.Tools.CheckBoxAdv();
this.checkBox1 = new Syncfusion.Windows.Forms.Tools.CheckBoxAdv();
this.panel2 = new System.Windows.Forms.Panel();
this.colorDialog1 = new System.Windows.Forms.ColorDialog();
((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).BeginInit();
this.panel1.SuspendLayout();
this.groupBox2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.radioButton1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.radioButton2)).BeginInit();
this.groupBox1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.checkBox2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.checkBox3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.checkBox1)).BeginInit();
this.SuspendLayout();
//
// gridGroupingControl1
//
this.gridGroupingControl1.AlphaBlendSelectionColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(94)))), ((int)(((byte)(171)))), ((int)(((byte)(222)))));
this.gridGroupingControl1.BackColor = System.Drawing.SystemColors.Window;
this.gridGroupingControl1.Dock = System.Windows.Forms.DockStyle.Fill;
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(0, 0);
this.gridGroupingControl1.Name = "gridGroupingControl1";
this.gridGroupingControl1.Size = new System.Drawing.Size(1513, 1008);
this.gridGroupingControl1.TabIndex = 10;
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";
this.gridGroupingControl1.TableDescriptor.TableOptions.ColumnHeaderRowHeight = (int)DpiAware.LogicalToDeviceUnits(25);
this.gridGroupingControl1.TableDescriptor.TableOptions.RecordRowHeight = (int)DpiAware.LogicalToDeviceUnits(20);
this.gridGroupingControl1.TableOptions.AllowDragColumns = false;
this.gridGroupingControl1.Text = "gridGroupingControl1";
this.gridGroupingControl1.VersionInfo = "6.102.0.34";
//
// panel1
//
this.panel1.Dock = DockStyle.Right;
this.panel1.Controls.Add(this.groupBox2);
this.panel1.Controls.Add(this.groupBox1);
this.panel1.ForeColor = System.Drawing.Color.DimGray;
this.panel1.Location = new System.Drawing.Point(827, 12);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(300, 300);
this.panel1.TabIndex = 17;
//
// panel2
//
this.panel2.Controls.Add(this.gridGroupingControl1);
this.panel2.Dock = System.Windows.Forms.DockStyle.Fill;
this.panel2.Location = new System.Drawing.Point(0, 0);
this.panel2.Margin = new System.Windows.Forms.Padding(4, 5, 4, 5);
this.panel2.Name = "panel2";
this.panel2.Size = new System.Drawing.Size(1214, 1010);
this.panel2.TabIndex = 0;
//
// groupBox2
//
this.groupBox2.Controls.Add(this.button2);
this.groupBox2.Controls.Add(this.radioButton1);
this.groupBox2.Controls.Add(this.radioButton2);
this.groupBox2.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.groupBox2.Location = new System.Drawing.Point(22, 291);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(230, 240);
this.groupBox2.TabIndex = 19;
this.groupBox2.TabStop = false;
this.groupBox2.Text = "Control Settings";
//
// button2
//
this.button2.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right)));
this.button2.Appearance = Syncfusion.Windows.Forms.ButtonAppearance.Metro;
this.button2.FlatStyle = FlatStyle.Flat;
this.button2.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(27)))), ((int)(((byte)(161)))), ((int)(((byte)(226)))));
this.button2.BeforeTouchSize = new System.Drawing.Size(126, 27);
this.button2.BorderStyleAdv = Syncfusion.Windows.Forms.ButtonAdvBorderStyle.RaisedInner;
this.button2.Font = new System.Drawing.Font("Segoe UI", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button2.ForeColor = System.Drawing.Color.White;
this.button2.IsBackStageButton = false;
this.button2.Location = new System.Drawing.Point(16, 165);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(189, 42);
this.button2.TabIndex = 22;
this.button2.Text = "Clear Sort";
this.button2.Click += new System.EventHandler(this.button3_Click);
//
// radioButton1
//
this.radioButton1.BeforeTouchSize = new System.Drawing.Size(146, 37);
this.radioButton1.ImageCheckBoxSize = new System.Drawing.Size(19, 19);
this.radioButton1.Location = new System.Drawing.Point(18, 65);
this.radioButton1.MetroColor = System.Drawing.Color.FromArgb(((int)(((byte)(27)))), ((int)(((byte)(161)))), ((int)(((byte)(226)))));
this.radioButton1.Name = "radioButton1";
this.radioButton1.Size = new System.Drawing.Size(146, 37);
this.radioButton1.Style = Syncfusion.Windows.Forms.Tools.RadioButtonAdvStyle.Metro;
this.radioButton1.DrawFocusRectangle = true;
this.radioButton1.TabIndex = 19;
this.radioButton1.Text = "Expand All";
this.radioButton1.ThemesEnabled = false;
this.radioButton1.CheckChanged += new System.EventHandler(this.button1_Click);
//
// radioButton2
//
this.radioButton2.BeforeTouchSize = new System.Drawing.Size(132, 31);
this.radioButton2.ImageCheckBoxSize = new System.Drawing.Size(19, 19);
this.radioButton2.Location = new System.Drawing.Point(18, 111);
this.radioButton2.MetroColor = System.Drawing.Color.FromArgb(((int)(((byte)(27)))), ((int)(((byte)(161)))), ((int)(((byte)(226)))));
this.radioButton2.Name = "radioButton2";
this.radioButton2.Size = new System.Drawing.Size(132, 31);
this.radioButton2.Style = Syncfusion.Windows.Forms.Tools.RadioButtonAdvStyle.Metro;
this.radioButton2.DrawFocusRectangle = true;
this.radioButton2.TabIndex = 20;
this.radioButton2.Text = "Collapse All";
this.radioButton2.ThemesEnabled = false;
this.radioButton2.CheckChanged += new System.EventHandler(this.button2_Click);
//
// groupBox1
//
this.groupBox1.Controls.Add(this.checkBox2);
this.groupBox1.Controls.Add(this.checkBox3);
this.groupBox1.Controls.Add(this.checkBox1);
this.groupBox1.Font = new System.Drawing.Font("Segoe UI", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.groupBox1.Location = new System.Drawing.Point(22, 23);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(230, 223);
this.groupBox1.TabIndex = 12;
this.groupBox1.TabStop = false;
this.groupBox1.Text = "TreeCell Settings";
//
// checkBox2
//
this.checkBox2.BeforeTouchSize = new System.Drawing.Size(204, 26);
this.checkBox2.ImageCheckBoxSize = new System.Drawing.Size(19, 19);
this.checkBox2.Location = new System.Drawing.Point(20, 60);
this.checkBox2.MetroColor = System.Drawing.Color.FromArgb(((int)(((byte)(27)))), ((int)(((byte)(161)))), ((int)(((byte)(226)))));
this.checkBox2.Name = "checkBox2";
this.checkBox2.Size = new System.Drawing.Size(204, 26);
this.checkBox2.Style = Syncfusion.Windows.Forms.Tools.CheckBoxAdvStyle.Metro;
this.checkBox2.DrawFocusRectangle = true;
this.checkBox2.TabIndex = 14;
this.checkBox2.Text = "Show TreeCell Borders";
this.checkBox2.ThemesEnabled = false;
this.checkBox2.CheckStateChanged += new System.EventHandler(this.checkBox2_CheckedChanged);
//
// checkBox3
//
this.checkBox3.BeforeTouchSize = new System.Drawing.Size(154, 26);
this.checkBox3.ImageCheckBoxSize = new System.Drawing.Size(19, 19);
this.checkBox3.Location = new System.Drawing.Point(20, 102);
this.checkBox3.Margin = new System.Windows.Forms.Padding(4, 5, 4, 5);
this.checkBox3.MetroColor = System.Drawing.Color.FromArgb(((int)(((byte)(27)))), ((int)(((byte)(161)))), ((int)(((byte)(226)))));
this.checkBox3.Name = "checkBox3";
this.checkBox3.Size = new System.Drawing.Size(154, 26);
this.checkBox3.Style = Syncfusion.Windows.Forms.Tools.CheckBoxAdvStyle.Metro;
this.checkBox3.DrawFocusRectangle = true;
this.checkBox3.TabIndex = 15;
this.checkBox3.Text = "Hide Tree Lines";
this.checkBox3.ThemesEnabled = false;
this.checkBox3.CheckStateChanged += new System.EventHandler(this.checkBox3_CheckedChanged);
//
// checkBox1
//
this.checkBox1.BeforeTouchSize = new System.Drawing.Size(144, 26);
this.checkBox1.ImageCheckBoxSize = new System.Drawing.Size(19, 19);
this.checkBox1.Location = new System.Drawing.Point(20, 145);
this.checkBox1.Margin = new System.Windows.Forms.Padding(4, 5, 4, 5);
this.checkBox1.MetroColor = System.Drawing.Color.FromArgb(((int)(((byte)(27)))), ((int)(((byte)(161)))), ((int)(((byte)(226)))));
this.checkBox1.Name = "checkBox1";
this.checkBox1.Size = new System.Drawing.Size(144, 26);
this.checkBox1.Style = Syncfusion.Windows.Forms.Tools.CheckBoxAdvStyle.Metro;
this.checkBox1.DrawFocusRectangle = true;
this.checkBox1.TabIndex = 16;
this.checkBox1.Text = "Color Levels...";
this.checkBox1.ThemesEnabled = false;
this.checkBox1.CheckStateChanged += new System.EventHandler(this.checkBox1_CheckedChanged);
//
// SelfReferenceForm
//
this.AutoScaleDimensions = new System.Drawing.SizeF(9F, 20F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(1513, 1008);
this.Controls.Add(this.panel2);
this.Controls.Add(this.panel1);
this.Margin = new System.Windows.Forms.Padding(4, 5, 4, 5);
this.MinimumSize = new System.Drawing.Size(1189, 739);
this.Name = "SelfReferenceForm";
this.Text = "Self Referential Grid ";
this.Load += new System.EventHandler(this.SelfReferenceForm_Load);
((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).EndInit();
this.panel1.ResumeLayout(false);
this.groupBox2.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.radioButton1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.radioButton2)).EndInit();
this.groupBox1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.checkBox2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.checkBox3)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.checkBox1)).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(ContactsPaneForm));
this.gridGroupingControl1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl();
this.parentBarItem1 = new Syncfusion.Windows.Forms.Tools.XPMenus.ParentBarItem();
this.barItem1 = new Syncfusion.Windows.Forms.Tools.XPMenus.BarItem();
this.imageList1 = new System.Windows.Forms.ImageList(this.components);
this.barItem3 = new Syncfusion.Windows.Forms.Tools.XPMenus.BarItem();
this.barItem5 = new Syncfusion.Windows.Forms.Tools.XPMenus.BarItem();
this.barItem6 = new Syncfusion.Windows.Forms.Tools.XPMenus.BarItem();
this.barItem7 = new Syncfusion.Windows.Forms.Tools.XPMenus.BarItem();
this.barItem4 = new Syncfusion.Windows.Forms.Tools.XPMenus.BarItem();
this.barItem2 = new Syncfusion.Windows.Forms.Tools.XPMenus.BarItem();
this.barItem8 = new Syncfusion.Windows.Forms.Tools.XPMenus.BarItem();
this.popupMenu1 = new Syncfusion.Windows.Forms.Tools.XPMenus.PopupMenu(this.components);
this.parentBarItem2 = new Syncfusion.Windows.Forms.Tools.XPMenus.ParentBarItem();
this.popupMenusManager1 = new Syncfusion.Windows.Forms.Tools.XPMenus.PopupMenusManager(this.components);
((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).BeginInit();
this.SuspendLayout();
//
// gridGroupingControl1
//
this.gridGroupingControl1.BackColor = System.Drawing.SystemColors.Window;
this.gridGroupingControl1.BorderStyle = System.Windows.Forms.BorderStyle.None;
this.gridGroupingControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.gridGroupingControl1.Location = new System.Drawing.Point(0, 0);
this.gridGroupingControl1.Name = "gridGroupingControl1";
this.gridGroupingControl1.Size = new System.Drawing.Size(392, 256);
this.gridGroupingControl1.TabIndex = 0;
this.gridGroupingControl1.TableOptions.ListBoxSelectionCurrentCellOptions = Syncfusion.Windows.Forms.Grid.Grouping.GridListBoxSelectionCurrentCellOptions.HideCurrentCell;
this.gridGroupingControl1.Text = "gridGroupingControl1";
this.gridGroupingControl1.VersionInfo = "4.401.0.50";
this.popupMenusManager1.SetXPContextMenu(this.gridGroupingControl1, this.popupMenu1);
//
// parentBarItem1
//
this.parentBarItem1.CategoryIndex = -1;
this.parentBarItem1.ID = "";
this.parentBarItem1.Items.AddRange(new Syncfusion.Windows.Forms.Tools.XPMenus.BarItem[] {
this.barItem1,
this.barItem3,
this.barItem5,
this.barItem6,
this.barItem7,
this.barItem4,
this.barItem2,
this.barItem8
});
this.parentBarItem1.Office2007Theme = Syncfusion.Windows.Forms.Office2007Theme.Blue;
this.parentBarItem1.SeparatorIndices.AddRange(new int[] {
1,
6,
7
});
this.parentBarItem1.ShowMnemonicUnderlinesAlways = true;
this.parentBarItem1.Style = Syncfusion.Windows.Forms.VisualStyle.Office2007Outlook;
//
// barItem1
//
this.barItem1.CategoryIndex = -1;
this.barItem1.ID = "New Contact";
this.barItem1.ImageIndex = 0;
this.barItem1.ImageList = this.imageList1;
this.barItem1.ShowMnemonicUnderlinesAlways = true;
this.barItem1.Text = "New Contact";
this.barItem1.Click += new System.EventHandler(this.barItem1_Click);
//
// imageList1
//
this.imageList1.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imageList1.ImageStream")));
this.imageList1.TransparentColor = System.Drawing.Color.Transparent;
this.imageList1.Images.SetKeyName(0, "");
this.imageList1.Images.SetKeyName(1, "");
this.imageList1.Images.SetKeyName(2, "");
this.imageList1.Images.SetKeyName(3, "");
this.imageList1.Images.SetKeyName(4, "");
this.imageList1.Images.SetKeyName(5, "");
//
// barItem3
//
this.barItem3.CategoryIndex = -1;
this.barItem3.ID = "Group By";
this.barItem3.Text = "Group By";
this.barItem3.Click += new System.EventHandler(this.barItem3_Click);
//
// barItem5
//
this.barItem5.CategoryIndex = -1;
this.barItem5.ID = "Group By Box";
this.barItem5.ImageIndex = 3;
this.barItem5.ImageList = this.imageList1;
this.barItem5.Text = "Group By Box";
this.barItem5.Click += new System.EventHandler(this.barItem5_Click);
//
// barItem6
//
this.barItem6.CategoryIndex = -1;
this.barItem6.ID = "Sort";
this.barItem6.ImageIndex = 4;
this.barItem6.ImageList = this.imageList1;
this.barItem6.Text = "Sort";
this.barItem6.Click += new System.EventHandler(this.barItem6_Click);
//
// barItem7
//
this.barItem7.CategoryIndex = -1;
this.barItem7.ID = "Filter";
this.barItem7.ImageIndex = 5;
this.barItem7.ImageList = this.imageList1;
this.barItem7.Text = "Filter";
this.barItem7.Click += new System.EventHandler(this.barItem7_Click);
//
// barItem4
//
this.barItem4.CategoryIndex = -1;
this.barItem4.ID = "Field Chooser";
this.barItem4.ImageIndex = 2;
this.barItem4.ImageList = this.imageList1;
this.barItem4.Text = "Field Chooser";
this.barItem4.Click += new System.EventHandler(this.barItem4_Click);
//
// barItem2
//
this.barItem2.CategoryIndex = -1;
this.barItem2.ID = "Delete";
this.barItem2.ImageIndex = 1;
this.barItem2.ImageList = this.imageList1;
this.barItem2.ShowMnemonicUnderlinesAlways = true;
this.barItem2.Text = "Delete";
this.barItem2.Click += new System.EventHandler(this.barItem2_Click);
//
// barItem8
//
this.barItem8.CategoryIndex = -1;
this.barItem8.ID = "Customize Current View...";
this.barItem8.Text = "Customize Current View...";
this.barItem8.Click += new System.EventHandler(this.barItem8_Click);
//
// popupMenu1
//
this.popupMenu1.ParentBarItem = this.parentBarItem1;
//
// parentBarItem2
//
this.parentBarItem2.CategoryIndex = -1;
this.parentBarItem2.ID = "";
this.parentBarItem2.Office2007Theme = Syncfusion.Windows.Forms.Office2007Theme.Blue;
//
// ContactsPaneForm
//
this.Controls.Add(this.gridGroupingControl1);
this.Name = "ContactsPaneForm";
this.Size = new System.Drawing.Size(392, 256);
((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).EndInit();
this.ResumeLayout(false);
}
