Demonstrates how to show other tables data that is related to the master table rows.
NTableGridDetail and NTreeGridDetail are master-details that can display a table or tree grid that display information from a slave data source.
In this example we have created an NTableGridDetail detail that display information about each specific person orders. The master grid shows the Persons data source. The detail for each person are extracted from the PersonOrders data source and displayed as a table grid again.

| Language: C# |
using Nevron.Nov;
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.Presentation;
using Nevron.Nov.UI;
using Nevron.Nov.Windows.Forms;
using System.Windows.Forms;
namespace NovWinFormsProject
{
public partial class Form1 : Form
{
#region Constructors
public Form1()
{
InitializeComponent();
// Set form title
Text = "NOV WinForms - NMasterDetailTablesExample";
// 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()
{
// create a view and get its grid
m_View = new NTableGridView();
NTableGrid grid = m_View.Grid;
// bind the grid to the data source
grid.DataSource = NDummyDataSource.CreatePersonsDataSource();
// configure the master grid
grid.AllowEdit = false;
// assign some icons to the columns
for (int i = 0; i < grid.Columns.Count; i++)
{
NDataColumn dataColumn = grid.Columns[i] as NDataColumn;
if (dataColumn == null)
continue;
NImage image = null;
switch (dataColumn.FieldName)
{
case "Name":
image = Nevron.Nov.Graphics.NImage.FromBytes(Nevron.Nov.NConvert.FromBase64String("iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAIAAACQkWg2AAAABnRSTlMAAAAAAABupgeRAAABu0lEQVR42sUPA6yQQfjuz7ZtN2ZzbMpNaYpTtjQvY0pz1lg927ZtHz50/9PY3PpsiH8O8vPvRKeImIiQEB07AIfdQB3Q0dDT8bZ1i8RfgNsZkH0l5Z4jV7yO1oKCgtOnT9+6dcvJsLAwa61fyT4BsUVHIioqoamlxUNEF713754rGDly5PTp0758/V5SWgYolGULPhlg7SR6Tc0tPQHQWFtUVAQAJ06cLCgszC8sMca0aP6RTMW1oq2VWttIado621Na9wTEHj16jh07Lig4KCExKTIsuKG2esqUySR441wGZAsCSGrrZWRL/2kAQBIXzp56dyomr7ho0pA+Y9JCC3KyR02anZVfExaTZSwBEiLNXzCuowGhpb74/q592zdE/rgxb2z/HCqPvbxp3YuiwUOHbt6wBJD9BuK8guKOBgCrualqqFSL580OCgxYOHl4dlZ1i6a0jMKikipjoKNn8rTJfgM66DvK23E/6u3+ct271cqf1UPHHX6kjJg2feL4ieNFFyRmVzkpH7z6sX7VUkCuadStClo1dqSZ2SBJZiBPg2egB0n58tnlnkR0+trdNq2V0sZa54r/DH8AtopTKVMOx+0AAAAASUVORK5CYII="));
break;
case "Gender":
image = Nevron.Nov.Graphics.NImage.FromBytes(Nevron.Nov.NConvert.FromBase64String("iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAACOklEQVR42p3OQ2AYQRQG4NfYti1NLG1t27YtTWzbti1tatu2dezxRbup+d1/wP9YHn7q9bLwU5+XhJx8C/9jT+KF5zMCTuC8gBPfFlAA3fN79zMUQBZ+wTftUrTloePYVzJYcOvgYebBhg3PXs2ajU8d7fHh2NF4bfrkcp91CaSo+imTUXSfmb20UHfdYZaZn3gF9RdUscB7G59Ens6ag3e1DZ+dUVBb0imjwnTLyNLLdo6YvykcJ9FLOPbgeZzodx4XRF78ZLCy+ZGlR6Ys8G7NnXvjqprGs/MKWrLAic65kT2PnsMb9gR9lG2jCZNHLObUUpc9Xag5MbcavnbVwwPbpWS2AGfdjmay3PcUksmV9Lyn06VWEWCBsy38CDVYXon6JJQA75yZKRYKi00BztKtjVu8Fteh3fAi2W5zA7ZZ+EtBb1DWa0s9aoxIpcBjdbQ+VQoJZANn9poqajE2HymA7EktxU9VgpANX7FbUoKaw5Ip8EoUZaObBADLjXSWQK+xM/MYMjEXtxuMvXRKcgjGAjDAsRmdukR/TiHqOEVNAV7fUuEQYFvFh2CtjPijSgkhdrz7ATRzCcF91pMH1y28ExjDSVmfetcvwc/0Li2pUlO41CoImCQsnq3rFnPJZHgymgxL+mTIJD7SHpGKWt6Jl3Rcogn8SgmxpKUACBxd+/AlvXepjnM01XGMWgK/U62meL9OTRmrAbDNWAdLhKEV/lWRoS5bCNBXMrMaQA/+VZKCHE0CQPgHPd9r6pfko/KxAAAAAElFTkSuQmCC"));
break;
case "Birthday":
image = Nevron.Nov.Graphics.NImage.FromBytes(Nevron.Nov.NConvert.FromBase64String("iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAChklEQVR42oXQM5w9RwDA8d/Mztt9/Nu2bR6quE2XlHG6uP9cHdvpYnWxnbNte/fem9UEG/M7NiR/Eb9/qZl7sML03nm8/K/9M/eVGf5C8ReeV2rTC6Xww5bxUf7Yv+C3hsWS+N8N3l2pdrVPTnDHG31d5r3zplTtkbmtRryzUu3uWD3BX0lIPFs/cOszTXNv2rHGjjRPtBs9ow4ztfwIj7cZ48QaJ9I81zL/5nMNg7dCQj1X33dNznaeLzgFcukMc9OSVMrhzHr4eLyB9qiDS9ZD34REpWx2LMtf5Ratq15uHb3f8/W10hjz/Ir8KpTKEMQwXHqOMP8SdbUuihjLGKaLMKpfwF77DtPTPsrKsDy/CmPi5yUYNmRhkQITweKtm7FXrmcuMuhAEokUtY1TFDavJ7VyHYWszdoMHF4BCAuFEDQvwMYs7MpBTkF6w0qEBCk/QpWBIBGTYT6AoSJ8MQkCgar/4rN79l/MV83rDMvSDivSkhVZMDHoCPwY/KTEDcALYlytCfwijV98fI8AltZXnZ5KVd5CX343o6xgJi6AMSBAIJJSCBabOVYzxka3g+DDBzh4z1fLFDAdWTbr37mX3Uf3wYY1sHEDxAZ0AEGYlGEI4+NEUzPMtbTTb2cAphVAZNksPX8ar78dOTGEXfMRVsYiKsYEOiIsxQR+BM5iLKfA0rMV9NRUA6AABAJsh9yx01DIQSELxmDpECsIwA8hCP9Q+oAAQAJ4Oqpu/L6a2aFh/NkZUBKUACtJyCT53hyzY6M0Vlf/vAZAkNj9+I3Hr965Jndl3pGHhCFN8omQ/CAIMFBydVzXPuy+fd0j370ItAp+txxYBuQByT+LAReYAiYBfgAKwDG3XKpSrgAAAABJRU5ErkJggg=="));
break;
case "Country":
image = Nevron.Nov.Graphics.NImage.FromBytes(Nevron.Nov.NConvert.FromBase64String("iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAACcUlEQVR42nXTA7AjdxwH8M/us3NX27alXG3bHFUadlwNa9u2hVxt27ayehtN/rX0xQg/gX+jipvww9hYNQwOLhvwA25Clf9HBbUFF9o7bLLH7WGzbYuwyfEXhfUu3yMsf/yBYZ6D5wkDcw4E1FABiACVoaEZa5tset6yi05bRmeTM+SThTTPJHkqyRJplv7iLy7+Qvls+SKmoR4Dbtp8i/OWXXPHFc202UOGB4cNqujr69PX26u3p1dPT88vHtthTM+iU5bFTRCjuuhie1eXXmZrlTkKo1O7BqJhg8Wc4igW/WQRURQBEeHLSzBWRTXGoYsueqgQaHc60u43mqFQVt7RDV3dblcIQfP1tQm0P1tcPOun2BQOjVHt71tWmvL10MvSIjPZKDVbTe12W7sY0PpsfvVLT1C8sq76OZfqNkawGlR7JyaqlSThyy9o59+SpVrt1i9BymZDK8o00xk0m/xw/plC+zvhw2VxH1TiVqvu9wBfvj6jJEvUPxuUFbmiLJTNUr22g7Kk02mjRANtEJfli/XRAw5ULwsfX7mLdw6/xCenHSXLM0VRmCwn5UVHa/BjIWTIUeAHv69x+udvTzew777SgXd9+y1fvzuz715ZUF7ksu96dOa9QzT3fUiQIscTMD3GJR/f+rHJ3neUsz/wS4BfgrywpKzI1N+ZW/rCqlrvL4wfkOB9PAKnANRm3H7GMHWzk0Ict39yK0RRGabsvUvoX+DKwJuBpwJ3By4IzB1Q+9sp44P+BdaptN67DNBBEyUKpPgCR+PjP075X8/E7IEjA5cGaoHrAscENg4M/+WZ/h974yYEf/dN2Ju/40cfj0TX7VMMDwAAAABJRU5ErkJggg=="));
break;
case "Phone":
image = Nevron.Nov.Graphics.NImage.FromBytes(Nevron.Nov.NConvert.FromBase64String("iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAACQklEQVR42o2SQ8DkSBhAX1Wnx7Zt3Na2bdu2bVs4r43TXFc6jX/bdpLiTvq38ILi+4oBwDM/6ftqG1tvc47pgGNkpBQ0z5k5+b0nzxr/Gk/+oO675N1af8X7df6KD8b+Jc5j30X3pdYfd8fnxroZQgB4Ym1pCy3KOFICZGf9kJ/Wer00xk331uOso6Vdc/CacXxxx1yev3AmkwJobtU443C2/5c4Wrvp0hjrrDW0hZolsyR3nrpPHJ9i05LxfHrzPC4+fAqVjRHGWKzt+xmMtS6ZQWbaK+dJ3r12AY98VkVORYR1joQLD5nG29fMo2qIIIkrtTF4Z9hZGLKnJOSFSxdQUKU44IFcTnu+gEg5Ni+dmAleWR8l60YbjTGGxJVGW5yxTEp7bv6wmMvfyOetn6pYMiOFt5aTn8kljC1blk/ixhNm0dS1J9ZYEldqnazFZNY0dQLUNSlSonONwlvGSctZz+WQcNnRs5k9RRDFKuMkbqCVBjx9sY4evIf8yo6uPoJHz1/Ize/nM31ygMUhVaTRKh7yi+OYMAz56sH1/LWnhYRVCycQRZ3tiSujpHNs0NHgLw41MyYI9ls/nV//qgI8L39RQNrbjJO4gQpj6QKHZ2iyihW/ba/n+WvXc8GT/7GrsJmpkwOUAmOkFFuv2FY0LhDLwTMcDS2KtUumUFobZi5ZJwJlfLFsak+/54xCKzvsN3VCirLqdtKCnjprFE0dwXsCYP5p2+6bnA5vE5LpeBwjIZDe0Ryaie9V/nLCa/8DaeHUDITqw6EAAAAASUVORK5CYII="));
break;
case "Email":
image = Nevron.Nov.Graphics.NImage.FromBytes(Nevron.Nov.NConvert.FromBase64String("iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAACs0lEQVR4Aa2SA8wtRwBGz+xePtu2bSus7Tao7aBmVEW1bdvus237v76rUad2o/cli8E5Q8G/5IHnl/TMeP4juYyYDbEslaP37rz+HBfVcPPNGyx/yl8E9z21tHne46JmTdJ3jB+RpmfHEMI9rFpdYUNxgFy1cfeVqlR4/OabTw3+Irj5sS9zXZq2nJ7xvLub5LzBh8/Ik04nqFoFL9iPF29Cl3fxwc4j2Liz/KZo0uayy8+asB1APPDEkh7C98/o1FbcOnawT4f2GiKDTkKELCCCA4hwF7gHvZNdyWS+2zPEzF2+7+TmLdt+KR55dunanu1U/9mjKtC07f/C+F1BFtG17XwbXcji3W1eT6VTqf6zhy5F1ZvhBWVE7Kbs1i2S3WACLMoJI2QkMXI1SRjgmYDpmWtZqh87NmWBoJLg9TuG1N921gKJAe0e5R4Ta4xOKJRL1BdfwI4dB0lh4eONg5jaPiSX8dm9v0KzplmEEFgLBovwfIyxlKqSlq1aUIpCPtx83M99UsYY2nbpzxdzdzB7QhdatcjzyQ+7fga0/ukxaGXBCKZN68reAwf45vNN1LvMQe394hfB5GFtmJcWfL1oL77n0Tjnk836GPMTDArBwUKNL77YQakW4HXoRN/BHZk71/wiMMDAfq346oftjBrcmnHDOuE5kbFQk1CWgtZ1yVdfb2bXxiqTZ46mEoGSTuCmSNU9r7y1jsmjOzB8cDsH+kQGImVxnFuzdeUMfUf1JRAp5j8/FztmLFprnEDz4qtrGDagNYOHtKMWCwqRppoIlDFECURSuMeSSOjYq5e71pLK59872LpHaUaM7kzfPi1YX4A9ZaiEPuW6RUkPYwRBoB1sqQcGqSBo1JtaY0Wzov1lCd+9s4TPY0kcJURhTOL+ZSJRTm6t5bfY31/QDMshyY/gFJCcZo3GBQAAAABJRU5ErkJggg=="));
break;
default:
continue;
}
// NOTE: The CreateHeaderContentDelegate is invoked whenever the Title changes or the UpdateHeaderContent() is called.
// you can use this event to create custom column header content
dataColumn.CreateHeaderContentDelegate = delegate(NColumn theColumn)
{
NPairBox pairBox = new NPairBox(image, dataColumn.Title, ENPairBoxRelation.Box1BeforeBox2);
pairBox.Spacing = 2;
return pairBox;
};
dataColumn.UpdateHeaderContent();
}
// get the grid master details
NMasterDetails masterDetails = grid.MasterDetails;
// creater the table grid detail.
// NOTE: It shows information from the sales data source. the details are bound using field binding
NTableGridDetail detail = new NTableGridDetail();
masterDetails.Details.Add(detail);
detail.DataSource = NDummyDataSource.CreatePersonsOrdersDataSource();
// configure the details grid
detail.GridView.Grid.AllowEdit = false;
NRelationMasterBinding masterBinding = new NRelationMasterBinding();
masterBinding.Relations.Add(new NRelation("Id", "PersonId"));
detail.MasterBinding = masterBinding;
return m_View;
}
public NWidget CreateExampleControls()
{
NStackPanel stack = new NStackPanel();
NList editors = NDesigner.GetDesigner(m_View.Grid).CreateMemberEditors(
m_View.Grid,
NGrid.FrozenRowsProperty,
NGrid.IntegralVScrollProperty);
for (int i = 0; i < editors.Count; i++)
{
stack.Add(editors[i]);
}
return stack;
}
public string GetExampleDescription()
{
return @"
Demonstrates how to show other tables data that is related to the master table rows.
NTableGridDetail and NTreeGridDetail are master-details that can display a table or tree grid that display information from a slave data source.
In this example we have created an NTableGridDetail detail that display information about each specific person orders.
The master grid shows the Persons data source.
The detail for each person are extracted from the PersonOrders data source and displayed as a table grid again.
";
}
///
/// Gets the relevant documentation links for the example
///
///
public (string Name, string Url)[] GetDocumentationUrls()
{
return new[]
{
("Grid Master - Details", "https://www.nevron.com/docs/openvision/grid-master-details.html"),
("Grid Data Binding and Column Generation", "https://www.nevron.com/docs/openvision/grid-data-binding-and-column-generation.html"),
("Data Tables", "https://www.nevron.com/docs/openvision/data-tables.html"),
("Data Sources", "https://www.nevron.com/docs/openvision/data-sources.html"),
};
}
#endregion
#region Implementation
#endregion
#region Event Handlers
#endregion
#region Fields
NTableGridView m_View;
#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.Editors
Imports Nevron.Nov.Graphics
Imports Nevron.Nov.Grid
Imports Nevron.Nov.Layout
Imports Nevron.Nov.Presentation
Imports Nevron.Nov.UI
Imports Nevron.Nov.Windows.Forms
Public Class Form1
#Region "Constructors"
Public Sub New()
' This call is required by the designer.
InitializeComponent()
' Add any initialization after the InitializeComponent() call.
' Set form title
Text = "NOV WinForms - NMasterDetailTablesExample"
' 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)
host.Dock = DockStyle.Fill
Controls.Add(host)
End Sub
#End Region
#Region "Example"
Public Function CreateExampleContent() As NWidget
' create a view and get its grid
m_View = New NTableGridView()
Dim grid = m_View.Grid
' bind the grid to the data source
grid.DataSource = NDummyDataSource.CreatePersonsDataSource()
' configure the master grid
grid.AllowEdit = False
' assign some icons to the columns
For i = 0 To grid.Columns.Count - 1
Dim dataColumn As NDataColumn = TryCast(grid.Columns(i), NDataColumn)
If dataColumn Is Nothing Then Continue For
Dim image As NImage = Nothing
Select Case dataColumn.FieldName
Case "Name"
image = Nevron.Nov.Graphics.NImage.FromBytes(Nevron.Nov.NConvert.FromBase64String("iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAIAAACQkWg2AAAABnRSTlMAAAAAAABupgeRAAABu0lEQVR42sUPA6yQQfjuz7ZtN2ZzbMpNaYpTtjQvY0pz1lg927ZtHz50/9PY3PpsiH8O8vPvRKeImIiQEB07AIfdQB3Q0dDT8bZ1i8RfgNsZkH0l5Z4jV7yO1oKCgtOnT9+6dcvJsLAwa61fyT4BsUVHIioqoamlxUNEF713754rGDly5PTp0758/V5SWgYolGULPhlg7SR6Tc0tPQHQWFtUVAQAJ06cLCgszC8sMca0aP6RTMW1oq2VWttIado621Na9wTEHj16jh07Lig4KCExKTIsuKG2esqUySR441wGZAsCSGrrZWRL/2kAQBIXzp56dyomr7ho0pA+Y9JCC3KyR02anZVfExaTZSwBEiLNXzCuowGhpb74/q592zdE/rgxb2z/HCqPvbxp3YuiwUOHbt6wBJD9BuK8guKOBgCrualqqFSL580OCgxYOHl4dlZ1i6a0jMKikipjoKNn8rTJfgM66DvK23E/6u3+ct271cqf1UPHHX6kjJg2feL4ieNFFyRmVzkpH7z6sX7VUkCuadStClo1dqSZ2SBJZiBPg2egB0n58tnlnkR0+trdNq2V0sZa54r/DH8AtopTKVMOx+0AAAAASUVORK5CYII="))
Case "Gender"
image = Nevron.Nov.Graphics.NImage.FromBytes(Nevron.Nov.NConvert.FromBase64String("iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAACOklEQVR42p3OQ2AYQRQG4NfYti1NLG1t27YtTWzbti1tatu2dezxRbup+d1/wP9YHn7q9bLwU5+XhJx8C/9jT+KF5zMCTuC8gBPfFlAA3fN79zMUQBZ+wTftUrTloePYVzJYcOvgYebBhg3PXs2ajU8d7fHh2NF4bfrkcp91CaSo+imTUXSfmb20UHfdYZaZn3gF9RdUscB7G59Ens6ag3e1DZ+dUVBb0imjwnTLyNLLdo6YvykcJ9FLOPbgeZzodx4XRF78ZLCy+ZGlR6Ys8G7NnXvjqprGs/MKWrLAic65kT2PnsMb9gR9lG2jCZNHLObUUpc9Xag5MbcavnbVwwPbpWS2AGfdjmay3PcUksmV9Lyn06VWEWCBsy38CDVYXon6JJQA75yZKRYKi00BztKtjVu8Fteh3fAi2W5zA7ZZ+EtBb1DWa0s9aoxIpcBjdbQ+VQoJZANn9poqajE2HymA7EktxU9VgpANX7FbUoKaw5Ip8EoUZaObBADLjXSWQK+xM/MYMjEXtxuMvXRKcgjGAjDAsRmdukR/TiHqOEVNAV7fUuEQYFvFh2CtjPijSgkhdrz7ATRzCcF91pMH1y28ExjDSVmfetcvwc/0Li2pUlO41CoImCQsnq3rFnPJZHgymgxL+mTIJD7SHpGKWt6Jl3Rcogn8SgmxpKUACBxd+/AlvXepjnM01XGMWgK/U62meL9OTRmrAbDNWAdLhKEV/lWRoS5bCNBXMrMaQA/+VZKCHE0CQPgHPd9r6pfko/KxAAAAAElFTkSuQmCC"))
Case "Birthday"
image = Nevron.Nov.Graphics.NImage.FromBytes(Nevron.Nov.NConvert.FromBase64String("iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAChklEQVR42oXQM5w9RwDA8d/Mztt9/Nu2bR6quE2XlHG6uP9cHdvpYnWxnbNte/fem9UEG/M7NiR/Eb9/qZl7sML03nm8/K/9M/eVGf5C8ReeV2rTC6Xww5bxUf7Yv+C3hsWS+N8N3l2pdrVPTnDHG31d5r3zplTtkbmtRryzUu3uWD3BX0lIPFs/cOszTXNv2rHGjjRPtBs9ow4ztfwIj7cZ48QaJ9I81zL/5nMNg7dCQj1X33dNznaeLzgFcukMc9OSVMrhzHr4eLyB9qiDS9ZD34REpWx2LMtf5Ratq15uHb3f8/W10hjz/Ir8KpTKEMQwXHqOMP8SdbUuihjLGKaLMKpfwF77DtPTPsrKsDy/CmPi5yUYNmRhkQITweKtm7FXrmcuMuhAEokUtY1TFDavJ7VyHYWszdoMHF4BCAuFEDQvwMYs7MpBTkF6w0qEBCk/QpWBIBGTYT6AoSJ8MQkCgar/4rN79l/MV83rDMvSDivSkhVZMDHoCPwY/KTEDcALYlytCfwijV98fI8AltZXnZ5KVd5CX343o6xgJi6AMSBAIJJSCBabOVYzxka3g+DDBzh4z1fLFDAdWTbr37mX3Uf3wYY1sHEDxAZ0AEGYlGEI4+NEUzPMtbTTb2cAphVAZNksPX8ar78dOTGEXfMRVsYiKsYEOiIsxQR+BM5iLKfA0rMV9NRUA6AABAJsh9yx01DIQSELxmDpECsIwA8hCP9Q+oAAQAJ4Oqpu/L6a2aFh/NkZUBKUACtJyCT53hyzY6M0Vlf/vAZAkNj9+I3Hr965Jndl3pGHhCFN8omQ/CAIMFBydVzXPuy+fd0j370ItAp+txxYBuQByT+LAReYAiYBfgAKwDG3XKpSrgAAAABJRU5ErkJggg=="))
Case "Country"
image = Nevron.Nov.Graphics.NImage.FromBytes(Nevron.Nov.NConvert.FromBase64String("iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAACcUlEQVR42nXTA7AjdxwH8M/us3NX27alXG3bHFUadlwNa9u2hVxt27ayehtN/rX0xQg/gX+jipvww9hYNQwOLhvwA25Clf9HBbUFF9o7bLLH7WGzbYuwyfEXhfUu3yMsf/yBYZ6D5wkDcw4E1FABiACVoaEZa5tset6yi05bRmeTM+SThTTPJHkqyRJplv7iLy7+Qvls+SKmoR4Dbtp8i/OWXXPHFc202UOGB4cNqujr69PX26u3p1dPT88vHtthTM+iU5bFTRCjuuhie1eXXmZrlTkKo1O7BqJhg8Wc4igW/WQRURQBEeHLSzBWRTXGoYsueqgQaHc60u43mqFQVt7RDV3dblcIQfP1tQm0P1tcPOun2BQOjVHt71tWmvL10MvSIjPZKDVbTe12W7sY0PpsfvVLT1C8sq76OZfqNkawGlR7JyaqlSThyy9o59+SpVrt1i9BymZDK8o00xk0m/xw/plC+zvhw2VxH1TiVqvu9wBfvj6jJEvUPxuUFbmiLJTNUr22g7Kk02mjRANtEJfli/XRAw5ULwsfX7mLdw6/xCenHSXLM0VRmCwn5UVHa/BjIWTIUeAHv69x+udvTzew777SgXd9+y1fvzuz715ZUF7ksu96dOa9QzT3fUiQIscTMD3GJR/f+rHJ3neUsz/wS4BfgrywpKzI1N+ZW/rCqlrvL4wfkOB9PAKnANRm3H7GMHWzk0Ict39yK0RRGabsvUvoX+DKwJuBpwJ3By4IzB1Q+9sp44P+BdaptN67DNBBEyUKpPgCR+PjP075X8/E7IEjA5cGaoHrAscENg4M/+WZ/h974yYEf/dN2Ju/40cfj0TX7VMMDwAAAABJRU5ErkJggg=="))
Case "Phone"
image = Nevron.Nov.Graphics.NImage.FromBytes(Nevron.Nov.NConvert.FromBase64String("iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAACQklEQVR42o2SQ8DkSBhAX1Wnx7Zt3Na2bdu2bVs4r43TXFc6jX/bdpLiTvq38ILi+4oBwDM/6ftqG1tvc47pgGNkpBQ0z5k5+b0nzxr/Gk/+oO675N1af8X7df6KD8b+Jc5j30X3pdYfd8fnxroZQgB4Ym1pCy3KOFICZGf9kJ/Wer00xk331uOso6Vdc/CacXxxx1yev3AmkwJobtU443C2/5c4Wrvp0hjrrDW0hZolsyR3nrpPHJ9i05LxfHrzPC4+fAqVjRHGWKzt+xmMtS6ZQWbaK+dJ3r12AY98VkVORYR1joQLD5nG29fMo2qIIIkrtTF4Z9hZGLKnJOSFSxdQUKU44IFcTnu+gEg5Ni+dmAleWR8l60YbjTGGxJVGW5yxTEp7bv6wmMvfyOetn6pYMiOFt5aTn8kljC1blk/ixhNm0dS1J9ZYEldqnazFZNY0dQLUNSlSonONwlvGSctZz+WQcNnRs5k9RRDFKuMkbqCVBjx9sY4evIf8yo6uPoJHz1/Ize/nM31ygMUhVaTRKh7yi+OYMAz56sH1/LWnhYRVCycQRZ3tiSujpHNs0NHgLw41MyYI9ls/nV//qgI8L39RQNrbjJO4gQpj6QKHZ2iyihW/ba/n+WvXc8GT/7GrsJmpkwOUAmOkFFuv2FY0LhDLwTMcDS2KtUumUFobZi5ZJwJlfLFsak+/54xCKzvsN3VCirLqdtKCnjprFE0dwXsCYP5p2+6bnA5vE5LpeBwjIZDe0Ryaie9V/nLCa/8DaeHUDITqw6EAAAAASUVORK5CYII="))
Case "Email"
image = Nevron.Nov.Graphics.NImage.FromBytes(Nevron.Nov.NConvert.FromBase64String("iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAACs0lEQVR4Aa2SA8wtRwBGz+xePtu2bSus7Tao7aBmVEW1bdvus237v76rUad2o/cli8E5Q8G/5IHnl/TMeP4juYyYDbEslaP37rz+HBfVcPPNGyx/yl8E9z21tHne46JmTdJ3jB+RpmfHEMI9rFpdYUNxgFy1cfeVqlR4/OabTw3+Irj5sS9zXZq2nJ7xvLub5LzBh8/Ik04nqFoFL9iPF29Cl3fxwc4j2Liz/KZo0uayy8+asB1APPDEkh7C98/o1FbcOnawT4f2GiKDTkKELCCCA4hwF7gHvZNdyWS+2zPEzF2+7+TmLdt+KR55dunanu1U/9mjKtC07f/C+F1BFtG17XwbXcji3W1eT6VTqf6zhy5F1ZvhBWVE7Kbs1i2S3WACLMoJI2QkMXI1SRjgmYDpmWtZqh87NmWBoJLg9TuG1N921gKJAe0e5R4Ta4xOKJRL1BdfwI4dB0lh4eONg5jaPiSX8dm9v0KzplmEEFgLBovwfIyxlKqSlq1aUIpCPtx83M99UsYY2nbpzxdzdzB7QhdatcjzyQ+7fga0/ukxaGXBCKZN68reAwf45vNN1LvMQe394hfB5GFtmJcWfL1oL77n0Tjnk836GPMTDArBwUKNL77YQakW4HXoRN/BHZk71/wiMMDAfq346oftjBrcmnHDOuE5kbFQk1CWgtZ1yVdfb2bXxiqTZ46mEoGSTuCmSNU9r7y1jsmjOzB8cDsH+kQGImVxnFuzdeUMfUf1JRAp5j8/FztmLFprnEDz4qtrGDagNYOHtKMWCwqRppoIlDFECURSuMeSSOjYq5e71pLK59872LpHaUaM7kzfPi1YX4A9ZaiEPuW6RUkPYwRBoB1sqQcGqSBo1JtaY0Wzov1lCd+9s4TPY0kcJURhTOL+ZSJRTm6t5bfY31/QDMshyY/gFJCcZo3GBQAAAABJRU5ErkJggg=="))
Case Else
Continue For
End Select
' NOTE: The CreateHeaderContentDelegate is invoked whenever the Title changes or the UpdateHeaderContent() is called.
' you can use this event to create custom column header content
dataColumn.CreateHeaderContentDelegate = Function(theColumn As NColumn)
Dim pairBox As NPairBox = New NPairBox(image, dataColumn.Title, ENPairBoxRelation.Box1BeforeBox2)
pairBox.Spacing = 2
Return pairBox
End Function
dataColumn.UpdateHeaderContent()
Next
' get the grid master details
Dim masterDetails = grid.MasterDetails
' creater the table grid detail.
' NOTE: It shows information from the sales data source. the details are bound using field binding
Dim detail As NTableGridDetail = New NTableGridDetail()
masterDetails.Details.Add(detail)
detail.DataSource = NDummyDataSource.CreatePersonsOrdersDataSource()
' configure the details grid
detail.GridView.Grid.AllowEdit = False
Dim masterBinding As NRelationMasterBinding = New NRelationMasterBinding()
masterBinding.Relations.Add(New NRelation("Id", "PersonId"))
detail.MasterBinding = masterBinding
Return m_View
End Function
Public Function CreateExampleControls() As NWidget
Dim stack As NStackPanel = New NStackPanel()
Dim editors = NDesigner.GetDesigner(m_View.Grid).CreateMemberEditors(m_View.Grid, NGrid.FrozenRowsProperty, NGrid.IntegralVScrollProperty)
For i = 0 To editors.Count - 1
stack.Add(editors(i))
Next
Return stack
End Function
Public Function GetExampleDescription() As String
Return "
Demonstrates how to show other tables data that is related to the master table rows.
NTableGridDetail and NTreeGridDetail are master-details that can display a table or tree grid that display information from a slave data source.
In this example we have created an NTableGridDetail detail that display information about each specific person orders.
The master grid shows the Persons data source.
The detail for each person are extracted from the PersonOrders data source and displayed as a table grid again.
"
End Function
'''
''' Gets the relevant documentation links for the example
'''
'''
Public Function GetDocumentationUrls() As (String, String)()
Return {("Grid Master - Details", "https://www.nevron.com/docs/openvision/grid-master-details.html"), ("Grid Data Binding and Column Generation", "https://www.nevron.com/docs/openvision/grid-data-binding-and-column-generation.html"), ("Data Tables", "https://www.nevron.com/docs/openvision/data-tables.html"), ("Data Sources", "https://www.nevron.com/docs/openvision/data-sources.html")}
End Function
#End Region
#Region "Implementation"
#End Region
#Region "Event Handlers"
#End Region
#Region "Fields"
Private m_View As NTableGridView
#End Region
#Region "Static Methods"
#End Region
#Region "Constants"
#End Region
#Region "Nested Types"
#End Region
End Class