Demonstrates custom calculated columns.
Custom calculated columns are represented by the NCustomCalculatedColumn class. It exposes a GetRowValueDelegate delegate, which is called whenever the column must provide a value for a specific row. Thus it is up to the user to provide a row value for a specific row.
In the example the Total column is a custom calculated column that is calculated as {Price*Quantity}.

| Language: C# |
using Nevron.Nov;
using Nevron.Nov.Data;
using Nevron.Nov.DataStructures;
using Nevron.Nov.Dom;
using Nevron.Nov.Editors;
using Nevron.Nov.Graphics;
using Nevron.Nov.Grid;
using Nevron.Nov.Layout;
using Nevron.Nov.UI;
using Nevron.Nov.Windows.Forms;
using System;
using System.Windows.Forms;
namespace NovWinFormsProject
{
public partial class Form1 : Form
{
#region Constructors
public Form1()
{
InitializeComponent();
// Set form title
Text = "NOV WinForms - NCustomCalculatedColumnsExample";
// Create the NOV example and its controls
NWidget exampleContent = CreateExampleContent();
NWidget exampleControls = CreateExampleControls();
if (exampleControls != null)
{
exampleControls.PreferredWidth = 300;
}
// Place the example and its controls in a pair box
NPairBox pairBox = new NPairBox(exampleContent, exampleControls);
pairBox.FillMode = ENStackFillMode.First;
pairBox.FitMode = ENStackFitMode.First;
pairBox.Margins = new NMargins(NDesign.HorizontalSpacing, NDesign.VerticalSpacing);
// Host the example in the form
NNovWidgetHost host = new NNovWidgetHost(pairBox);
host.Dock = DockStyle.Fill;
Controls.Add(host);
}
#endregion
#region Example
public NWidget CreateExampleContent()
{
m_GridView = new NTableGridView();
NTableGrid grid = m_GridView.Grid;
// bind the grid to the data source
grid.DataSource = NDummyDataSource.CreatePersonsOrdersDataSource();
// add an event calculated column of type Double
NCustomCalculatedColumn totalColumn = new NCustomCalculatedColumn();
totalColumn.Title = "Total";
totalColumn.GetRowValueDelegate += delegate(NCustomCalculatedColumnGetRowValueArgs arg)
{
// calculate a RowValue for the RowIndex
double price = Convert.ToDouble(arg.DataSource.GetValue(arg.RowIndex, "Price"));
double quantity = Convert.ToDouble(arg.DataSource.GetValue(arg.RowIndex, "Quantity"));
return (double)(price * quantity);
};
totalColumn.Format.BackgroundFill = new NColorFill(NColor.SeaShell);
grid.Columns.Add(totalColumn);
return m_GridView;
}
public NWidget CreateExampleControls()
{
NStackPanel stack = new NStackPanel();
return stack;
}
public string GetExampleDescription()
{
return @"
Demonstrates custom calculated columns.
Custom calculated columns are represented by the NCustomCalculatedColumn class.
It exposes a GetRowValueDelegate delegate, which is called whenever the column must provide a value for a specific row.
Thus it is up to the user to provide a row value for a specific row.
In the example the Total column is a custom calculated column that is calculated as {Price*Quantity}.
";
}
///
/// Gets the relevant documentation links for the example
///
///
public (string Name, string Url)[] GetDocumentationUrls()
{
return new[]
{
("Grid Calculated Columns", "https://www.nevron.com/docs/openvision/grid-calculated-columns.html"),
("Grid Columns", "https://www.nevron.com/docs/openvision/grid-columns.html"),
};
}
#endregion
#region Implementation
#endregion
#region Event Handlers
#endregion
#region Fields
NTableGridView m_GridView;
#endregion
#region Static Methods
#endregion
#region Constants
#endregion
#region Nested Types
#endregion
}
} | Language: VB.NET |
Imports Nevron.Nov
Imports Nevron.Nov.Dom
Imports Nevron.Nov.Graphics
Imports Nevron.Nov.Grid
Imports Nevron.Nov.Layout
Imports Nevron.Nov.UI
Imports Nevron.Nov.Windows.Wpf
Imports System
Class MainWindow
#Region "Constructors"
Public Sub New()
' This call is required by the designer.
InitializeComponent()
' Add any initialization after the InitializeComponent() call.
' Set form title
Title = "NOV WPF - NCustomCalculatedColumnsExample"
' Create the NOV example and its controls
Dim exampleContent As NWidget = CreateExampleContent()
Dim exampleControls As NWidget = CreateExampleControls()
If Not exampleControls Is Nothing Then
exampleControls.PreferredWidth = 300
End If
' Place the example and its controls in a pair box
Dim pairBox As NPairBox = New NPairBox(exampleContent, exampleControls)
pairBox.FillMode = ENStackFillMode.First
pairBox.FitMode = ENStackFitMode.First
pairBox.Margins = New NMargins(NDesign.HorizontalSpacing, NDesign.VerticalSpacing)
' Host the example in the form
Dim host As NNovWidgetHost(Of NWidget) = New NNovWidgetHost(Of NWidget)(pairBox)
Content = host
End Sub
#End Region
#Region "Example"
Public Function CreateExampleContent() As NWidget
m_GridView = New NTableGridView()
Dim grid = m_GridView.Grid
' bind the grid to the data source
grid.DataSource = NDummyDataSource.CreatePersonsOrdersDataSource()
' add an event calculated column of type Double
Dim totalColumn As NCustomCalculatedColumn(Of Double) = New NCustomCalculatedColumn(Of Double)()
totalColumn.Title = "Total"
totalColumn.GetRowValueDelegate += Function(arg As NCustomCalculatedColumnGetRowValueArgs(Of Double))
' calculate a RowValue for the RowIndex
Dim price = Convert.ToDouble(arg.DataSource.GetValue(arg.RowIndex, "Price"))
Dim quantity = Convert.ToDouble(arg.DataSource.GetValue(arg.RowIndex, "Quantity"))
Return price * quantity
End Function
totalColumn.Format.BackgroundFill = New NColorFill(NColor.SeaShell)
grid.Columns.Add(totalColumn)
Return m_GridView
End Function
Public Function CreateExampleControls() As NWidget
Dim stack As NStackPanel = New NStackPanel()
Return stack
End Function
Public Function GetExampleDescription() As String
Return "
Demonstrates custom calculated columns.
Custom calculated columns are represented by the NCustomCalculatedColumn class.
It exposes a GetRowValueDelegate delegate, which is called whenever the column must provide a value for a specific row.
Thus it is up to the user to provide a row value for a specific row.
In the example the Total column is a custom calculated column that is calculated as {Price*Quantity}.
"
End Function
'''
''' Gets the relevant documentation links for the example
'''
'''
Public Function GetDocumentationUrls() As (String, String)()
Return {("Grid Calculated Columns", "https://www.nevron.com/docs/openvision/grid-calculated-columns.html"), ("Grid Columns", "https://www.nevron.com/docs/openvision/grid-columns.html")}
End Function
#End Region
#Region "Implementation"
#End Region
#Region "Event Handlers"
#End Region
#Region "Fields"
Private m_GridView As NTableGridView
#End Region
#Region "Static Methods"
#End Region
#Region "Constants"
#End Region
#Region "Nested Types"
#End Region
End Class