コード例 #1
0
        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor1  = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor();
            Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor2  = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor();
            Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor3  = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor();
            Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor4  = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor();
            Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor5  = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor();
            Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor6  = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor();
            Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor7  = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor();
            Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor8  = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor();
            Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor9  = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor();
            Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor10 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor();
            Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor11 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor();
            Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor12 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor();
            Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor13 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor();
            Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor gridColumnDescriptor14 = new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor();
            this.gridGroupingControl1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl();
            this.dataSet11            = new SummaryTutorial.DataSet1();
            ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
            this.SuspendLayout();
            //
            // gridGroupingControl1
            //
            this.gridGroupingControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
                                                                                      | System.Windows.Forms.AnchorStyles.Left)
                                                                                     | System.Windows.Forms.AnchorStyles.Right)));
            this.gridGroupingControl1.BackColor            = System.Drawing.SystemColors.Window;
            this.gridGroupingControl1.DataSource           = this.dataSet11.Orders;
            this.gridGroupingControl1.FreezeCaption        = false;
            this.gridGroupingControl1.GridOfficeScrollBars = Syncfusion.Windows.Forms.OfficeScrollBars.Metro;
            this.gridGroupingControl1.GridVisualStyles     = Syncfusion.Windows.Forms.GridVisualStyles.Metro;
            this.gridGroupingControl1.Location             = new System.Drawing.Point(3, 0);
            this.gridGroupingControl1.Name     = "gridGroupingControl1";
            this.gridGroupingControl1.Size     = new System.Drawing.Size(1007, 655);
            this.gridGroupingControl1.TabIndex = 0;
            this.gridGroupingControl1.TableDescriptor.AllowNew = false;
            this.gridGroupingControl1.TableDescriptor.Appearance.AnyCell.Font.Facename             = "Segoe UI";
            this.gridGroupingControl1.TableDescriptor.Appearance.AnyCell.TextColor                 = System.Drawing.Color.FromArgb(((int)(((byte)(138)))), ((int)(((byte)(138)))), ((int)(((byte)(138)))));
            this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.Borders.Bottom       = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin);
            this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.Borders.Right        = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin);
            this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.Interior             = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(235)))), ((int)(((byte)(235)))), ((int)(((byte)(235))))));
            this.gridGroupingControl1.TableDescriptor.Appearance.AnyGroupCell.TextColor            = System.Drawing.Color.FromArgb(((int)(((byte)(138)))), ((int)(((byte)(138)))), ((int)(((byte)(138)))));
            this.gridGroupingControl1.TableDescriptor.Appearance.AnyRecordFieldCell.Borders.Bottom = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin);
            this.gridGroupingControl1.TableDescriptor.Appearance.AnyRecordFieldCell.Borders.Right  = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(234)))), ((int)(((byte)(234)))), ((int)(((byte)(234))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin);
            this.gridGroupingControl1.TableDescriptor.Appearance.AnySummaryCell.Borders.Right      = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(208)))), ((int)(((byte)(208)))), ((int)(((byte)(208))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin);
            this.gridGroupingControl1.TableDescriptor.Appearance.AnySummaryCell.Borders.Top        = new Syncfusion.Windows.Forms.Grid.GridBorder(Syncfusion.Windows.Forms.Grid.GridBorderStyle.Solid, System.Drawing.Color.FromArgb(((int)(((byte)(208)))), ((int)(((byte)(208)))), ((int)(((byte)(208))))), Syncfusion.Windows.Forms.Grid.GridBorderWeight.ExtraThin);
            this.gridGroupingControl1.TableDescriptor.Appearance.AnySummaryCell.Interior           = new Syncfusion.Drawing.BrushInfo(System.Drawing.Color.FromArgb(((int)(((byte)(208)))), ((int)(((byte)(208)))), ((int)(((byte)(208))))));
            this.gridGroupingControl1.TableDescriptor.Appearance.ColumnHeaderCell.Font.Bold        = true;
            this.gridGroupingControl1.TableDescriptor.Appearance.GroupCaptionCell.CellType         = "ColumnHeader";
            gridColumnDescriptor1.HeaderImage           = null;
            gridColumnDescriptor1.HeaderImageAlignment  = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left;
            gridColumnDescriptor1.MappingName           = "CustomerID";
            gridColumnDescriptor1.SerializedImageArray  = "";
            gridColumnDescriptor2.HeaderImage           = null;
            gridColumnDescriptor2.HeaderImageAlignment  = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left;
            gridColumnDescriptor2.MappingName           = "EmployeeID";
            gridColumnDescriptor2.SerializedImageArray  = "";
            gridColumnDescriptor3.HeaderImage           = null;
            gridColumnDescriptor3.HeaderImageAlignment  = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left;
            gridColumnDescriptor3.MappingName           = "Freight";
            gridColumnDescriptor3.SerializedImageArray  = "";
            gridColumnDescriptor4.HeaderImage           = null;
            gridColumnDescriptor4.HeaderImageAlignment  = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left;
            gridColumnDescriptor4.HeaderText            = "Order Date";
            gridColumnDescriptor4.MappingName           = "OrderDate";
            gridColumnDescriptor4.SerializedImageArray  = "";
            gridColumnDescriptor5.HeaderImage           = null;
            gridColumnDescriptor5.HeaderImageAlignment  = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left;
            gridColumnDescriptor5.MappingName           = "OrderID";
            gridColumnDescriptor5.SerializedImageArray  = "";
            gridColumnDescriptor6.HeaderImage           = null;
            gridColumnDescriptor6.HeaderImageAlignment  = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left;
            gridColumnDescriptor6.HeaderText            = "Required Date";
            gridColumnDescriptor6.MappingName           = "RequiredDate";
            gridColumnDescriptor6.SerializedImageArray  = "";
            gridColumnDescriptor7.HeaderImage           = null;
            gridColumnDescriptor7.HeaderImageAlignment  = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left;
            gridColumnDescriptor7.HeaderText            = "Ship Address";
            gridColumnDescriptor7.MappingName           = "ShipAddress";
            gridColumnDescriptor7.SerializedImageArray  = "";
            gridColumnDescriptor8.HeaderImage           = null;
            gridColumnDescriptor8.HeaderImageAlignment  = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left;
            gridColumnDescriptor8.HeaderText            = "Ship City";
            gridColumnDescriptor8.MappingName           = "ShipCity";
            gridColumnDescriptor8.SerializedImageArray  = "";
            gridColumnDescriptor9.HeaderImage           = null;
            gridColumnDescriptor9.HeaderImageAlignment  = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left;
            gridColumnDescriptor9.HeaderText            = "Ship Country";
            gridColumnDescriptor9.MappingName           = "ShipCountry";
            gridColumnDescriptor9.SerializedImageArray  = "";
            gridColumnDescriptor10.HeaderImage          = null;
            gridColumnDescriptor10.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left;
            gridColumnDescriptor10.HeaderText           = "Ship Name";
            gridColumnDescriptor10.MappingName          = "ShipName";
            gridColumnDescriptor10.SerializedImageArray = "";
            gridColumnDescriptor11.HeaderImage          = null;
            gridColumnDescriptor11.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left;
            gridColumnDescriptor11.HeaderText           = "Shipped Date";
            gridColumnDescriptor11.MappingName          = "ShippedDate";
            gridColumnDescriptor11.SerializedImageArray = "";
            gridColumnDescriptor12.HeaderImage          = null;
            gridColumnDescriptor12.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left;
            gridColumnDescriptor12.HeaderText           = "Ship Postal Code";
            gridColumnDescriptor12.MappingName          = "ShipPostalCode";
            gridColumnDescriptor12.SerializedImageArray = "";
            gridColumnDescriptor13.HeaderImage          = null;
            gridColumnDescriptor13.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left;
            gridColumnDescriptor13.HeaderText           = "Ship Region";
            gridColumnDescriptor13.MappingName          = "ShipRegion";
            gridColumnDescriptor13.SerializedImageArray = "";
            gridColumnDescriptor14.HeaderImage          = null;
            gridColumnDescriptor14.HeaderImageAlignment = Syncfusion.Windows.Forms.Grid.Grouping.HeaderImageAlignment.Left;
            gridColumnDescriptor14.HeaderText           = "Ship Via";
            gridColumnDescriptor14.MappingName          = "ShipVia";
            gridColumnDescriptor14.SerializedImageArray = "";
            this.gridGroupingControl1.TableDescriptor.Columns.AddRange(new Syncfusion.Windows.Forms.Grid.Grouping.GridColumnDescriptor[] {
                gridColumnDescriptor1,
                gridColumnDescriptor2,
                gridColumnDescriptor3,
                gridColumnDescriptor4,
                gridColumnDescriptor5,
                gridColumnDescriptor6,
                gridColumnDescriptor7,
                gridColumnDescriptor8,
                gridColumnDescriptor9,
                gridColumnDescriptor10,
                gridColumnDescriptor11,
                gridColumnDescriptor12,
                gridColumnDescriptor13,
                gridColumnDescriptor14
            });
            this.gridGroupingControl1.TableDescriptor.TableOptions.ColumnHeaderRowHeight = 32;
            this.gridGroupingControl1.TableDescriptor.TableOptions.RecordRowHeight       = 22;
            this.gridGroupingControl1.Text = "gridGroupingControl1";
            //
            // dataSet11
            //
            this.dataSet11.DataSetName             = "DataSet1";
            this.dataSet11.Locale                  = new System.Globalization.CultureInfo("en-US");
            this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
            //
            // Form1
            //

            this.MinimumSize = new System.Drawing.Size(800, 400);
            this.ClientSize  = new System.Drawing.Size(1012, 656);
            this.Controls.Add(this.gridGroupingControl1);
            this.Name = "Form1";
            this.Text = "Group Summary ";
            ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
            this.ResumeLayout(false);
        }
コード例 #2
0
ファイル: Form1.cs プロジェクト: zuozhu315/winforms-demos
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     this.gridGroupingControl1 = new Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl();
     this.dataSet11            = new SummaryTutorial.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.propertyGrid1        = new System.Windows.Forms.PropertyGrid();
     ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
     this.SuspendLayout();
     //
     // gridGroupingControl1
     //
     this.gridGroupingControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
                                                                               | System.Windows.Forms.AnchorStyles.Left)
                                                                              | System.Windows.Forms.AnchorStyles.Right)));
     this.gridGroupingControl1.BackColor            = System.Drawing.SystemColors.Window;
     this.gridGroupingControl1.DataSource           = this.dataSet11.Statistics;
     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, 2);
     this.gridGroupingControl1.Name = "gridGroupingControl1";
     this.gridGroupingControl1.ShowGroupDropArea = true;
     this.gridGroupingControl1.Size     = new System.Drawing.Size(748, 636);
     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           = 30;
     this.gridGroupingControl1.TableDescriptor.TableOptions.RecordRowHeight                 = 22;
     this.gridGroupingControl1.Text = "gridGroupingControl1";
     this.gridGroupingControl1.TopLevelGroupOptions.RepaintCaptionWhenItemsChanged = true;
     this.gridGroupingControl1.TopLevelGroupOptions.ShowAddNewRecordBeforeDetails  = false;
     this.gridGroupingControl1.TopLevelGroupOptions.ShowCaption = false;
     //
     // dataSet11
     //
     this.dataSet11.DataSetName             = "DataSet1";
     this.dataSet11.Locale                  = new System.Globalization.CultureInfo("en-US");
     this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
     //
     // oleDbDataAdapter1
     //
     this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand1;
     this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1;
     this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
     this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
         new System.Data.Common.DataTableMapping("Table", "Statistics", new System.Data.Common.DataColumnMapping[] {
             new System.Data.Common.DataColumnMapping("ID", "ID"),
             new System.Data.Common.DataColumnMapping("losses", "losses"),
             new System.Data.Common.DataColumnMapping("School", "School"),
             new System.Data.Common.DataColumnMapping("Sport", "Sport"),
             new System.Data.Common.DataColumnMapping("ties", "ties"),
             new System.Data.Common.DataColumnMapping("wins", "wins"),
             new System.Data.Common.DataColumnMapping("year", "year")
         })
     });
     this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1;
     //
     // oleDbDeleteCommand1
     //
     this.oleDbDeleteCommand1.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)
     });
     //
     // 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.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)
     });
     //
     // propertyGrid1
     //
     this.propertyGrid1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
                                                                       | System.Windows.Forms.AnchorStyles.Right)));
     this.propertyGrid1.BackColor                 = System.Drawing.Color.White;
     this.propertyGrid1.CommandsBackColor         = System.Drawing.Color.White;
     this.propertyGrid1.CommandsDisabledLinkColor = System.Drawing.Color.White;
     this.propertyGrid1.HelpBackColor             = System.Drawing.Color.White;
     this.propertyGrid1.LineColor                 = System.Drawing.Color.White;
     this.propertyGrid1.Location       = new System.Drawing.Point(766, 2);
     this.propertyGrid1.Name           = "propertyGrid1";
     this.propertyGrid1.SelectedObject = this.gridGroupingControl1;
     this.propertyGrid1.Size           = new System.Drawing.Size(234, 636);
     this.propertyGrid1.TabIndex       = 14;
     //
     // Form1
     //
     this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
     this.ClientSize          = new System.Drawing.Size(1012, 656);
     this.Controls.Add(this.propertyGrid1);
     this.Controls.Add(this.gridGroupingControl1);
     this.MinimumSize = new System.Drawing.Size(800, 400);
     this.Name        = "Form1";
     this.Text        = "Summary Tutorial";
     ((System.ComponentModel.ISupportInitialize)(this.gridGroupingControl1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
     this.ResumeLayout(false);
 }