protected override NWidget CreateExampleContent() { // create a view and get its grid NTableGridView view = new NTableGridView(); NTableGrid grid = view.Grid; // bind to sales data source NDataSource dataSource = NDummyDataSource.CreateCompanySalesDataSource(); grid.DataSource = dataSource; // create an expression filter rule that matches records for which Company is equal to Leka string companyFxName = dataSource.CreateFormulaFieldName("Company"); string expression1 = companyFxName + "==\"" + NDummyDataSource.RandomCompanyName() + "\""; grid.FilteringRules.Add(new NFilteringRule(new NFormulaRowCondition(expression1))); // create an expression filter rule that matches records for which Sales is larger than 1000 string salesFxName = dataSource.CreateFormulaFieldName("Sales"); string expression2 = salesFxName + ">1000"; grid.FilteringRules.Add(new NFilteringRule(new NFormulaRowCondition(expression2))); grid.AllowSortColumns = true; grid.AlternatingRows = true; grid.RowHeaders.Visible = true; return(view); }
protected override NWidget CreateExampleContent() { m_TableView = new NTableGridView(); m_TableView.Grid.DataSource = NDummyDataSource.CreateCompanySalesDataSource(); m_TableView.Grid.AllowEdit = true; return(m_TableView); }
protected override NWidget CreateExampleContent() { m_TableView = new NTableGridView(); m_TableView.Grid.DataSource = NDummyDataSource.CreateCompanySalesDataSource(); // show the row headers m_TableView.Grid.RowHeaders.Visible = true; return(m_TableView); }
protected override NWidget CreateExampleContent() { // create a view and get its grid NTableGridView view = new NTableGridView(); NTableGrid grid = view.Grid; // bind the grid to the data source grid.DataSource = NDummyDataSource.CreateCompanySalesDataSource(); // create a sorting rule that sorts by the company column first NColumn companyColumn = grid.Columns.GetColumnByFieldName("Company"); grid.SortingRules.Add(new NSortingRule(companyColumn, ENSortingDirection.Ascending)); // create a sorting rule that sorts by the sales column next NColumn salesColumn = grid.Columns.GetColumnByFieldName("Sales"); grid.SortingRules.Add(new NSortingRule(salesColumn, ENSortingDirection.Ascending)); return(view); }
protected override NWidget CreateExampleContent() { NTableGridView gridView = new NTableGridView(); NTableGrid grid = gridView.Grid; // bind the grid to the data source grid.DataSource = NDummyDataSource.CreateCompanySalesDataSource(); // create a grouping rule that groups by the company field value first // note that in order to indicate the grouping in the grouping panel, the rule must reference the respective column NColumn companyColumn = grid.Columns.GetColumnByFieldName("Company"); string fx1 = grid.CreateFormulaFieldName("Company"); NFormulaRowValue fxRowValue = new NFormulaRowValue(fx1); NGroupingRule groupingRule1 = new NGroupingRule(companyColumn, fxRowValue, ENSortingDirection.Ascending); grid.GroupingRules.Add(groupingRule1); // create a grouping rule that groups by sales larger than 1000 next // note that in order to indicate the grouping in the grouping panel, the rule must reference the respective column string fx2 = grid.CreateFormulaFieldName("Sales") + ">1000"; NColumn salesColumn = grid.Columns.GetColumnByFieldName("Sales"); NGroupingRule groupingRule2 = NGroupingRule.FromFormula(salesColumn, fx2); groupingRule2.CreateGroupRowCellsDelegate += delegate(NGroupingRuleCreateGroupRowCellsArgs arg) { bool groupValue = (bool)((NVariant)arg.GroupRow.GroupValue); string text = groupValue? "Sales greater than 1000" : "Sales less than or equal to 1000"; return(new NGroupRowCell[] { new NGroupRowCell(text) }); }; grid.GroupingRules.Add(groupingRule2); // alter some view preferences grid.AllowSortColumns = true; grid.AlternatingRows = true; grid.RowHeaders.Visible = true; return(gridView); }