private void SetGridSettings()
        {
            //Bind Products DropDown:
            this.gridEX1.DropDowns["Products"].SetDataBinding(this.jsNorthWindDataSet1.Products, "");

            //Adding a GroupHeaderTotal:
            GridEXGroupHeaderTotal groupTotal = new GridEXGroupHeaderTotal();
            groupTotal.AggregateFunction = AggregateFunction.Count;
            groupTotal.TotalFormatMode = FormatMode.UseStringFormat;
            groupTotal.TotalFormatString = "{0} Customers";
            this.gridEX1.RootTable.GroupHeaderTotals.Add(groupTotal);

            this.gridEX1.RowHeaders = InheritableBoolean.True;
            this.gridEX1.GroupMode = GroupMode.Collapsed;

            //Group Customers by Order_Details.Product:
            this.gridEX1.RootTable.Groups.Add(this.gridEX1.Tables["OrderDetails"].Columns["ProductID"]);
        }
        private void SetGridSettings()
        {
            //Bind Products DropDown:
            this.gridEX1.DropDowns["Products"].SetDataBinding(this.jsNorthWindDataSet1.Products, "");

            //Adding a GroupHeaderTotal:
            GridEXGroupHeaderTotal groupTotal = new GridEXGroupHeaderTotal();

            groupTotal.AggregateFunction = AggregateFunction.Count;
            groupTotal.TotalFormatMode   = FormatMode.UseStringFormat;
            groupTotal.TotalFormatString = "{0} Customers";
            this.gridEX1.RootTable.GroupHeaderTotals.Add(groupTotal);

            this.gridEX1.RowHeaders = InheritableBoolean.True;
            this.gridEX1.GroupMode  = GroupMode.Collapsed;

            //Group Customers by Order_Details.Product:
            this.gridEX1.RootTable.Groups.Add(this.gridEX1.Tables["OrderDetails"].Columns["ProductID"]);
        }