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
}
}