This example demonstrates how import data from various data sources.

| Language: C# |
using Nevron.Nov;
using Nevron.Nov.Chart;
using Nevron.Nov.Data;
using Nevron.Nov.DataStructures;
using Nevron.Nov.Dom;
using Nevron.Nov.Formulas;
using Nevron.Nov.Graphics;
using Nevron.Nov.Layout;
using Nevron.Nov.UI;
using Nevron.Nov.Windows.Forms;
using System;
using System.Collections;
using System.Windows.Forms;
namespace NovWinFormsProject
{
public partial class Form1 : Form
{
#region Constructors
public Form1()
{
InitializeComponent();
// Set form title
Text = "NOV WinForms - NChartDataImportExample";
// 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()
{
NChartViewWithCommandBars chartViewWithCommandBars = new NChartViewWithCommandBars();
m_ChartView = chartViewWithCommandBars.View;
m_ChartView.Surface.CreatePredefinedChart(ENPredefinedChartType.Cartesian);
// add interlaced stripe for Y axis
NScaleStrip strip = new NScaleStrip(new NColorFill(NColor.Beige), null, true, 0, 0, 1, 1);
strip.Interlaced = true;
((NCartesianChart)m_ChartView.Surface.Charts[0]).Axes[ENCartesianAxis.PrimaryY].Scale.Strips.Add(strip);
// configure title
m_ChartView.Surface.Titles[0].Text = "Chart Data Import";
// use bright theme
m_ChartView.Document.StyleSheets.ApplyTheme(new NChartTheme(ENChartPalette.Bright, ENChartPaletteTarget.DataPoints));
// import single data series
OnImportSingleDataSeriesClick(null);
return chartViewWithCommandBars;
}
public NWidget CreateExampleControls()
{
NStackPanel stack = new NStackPanel();
NUniSizeBoxGroup group = new NUniSizeBoxGroup(stack);
NButton importSingleDataSeries = new NButton("Import Single Data Series");
importSingleDataSeries.Click += OnImportSingleDataSeriesClick;
stack.Add(importSingleDataSeries);
NButton importMultipleDataSeriesFromEnumrables = new NButton("Import Multiple Data Series\r\n(from IEnumerables)");
importMultipleDataSeriesFromEnumrables.Click += OnImportMultipleDataSeriesFromEnumerablesClick;
stack.Add(importMultipleDataSeriesFromEnumrables);
NButton importMultipleDataSeriesFromTable = new NButton("Import Multiple Data Series\r\n(from NDataTable)");
importMultipleDataSeriesFromTable.Click += OnImportMultipleDataSeriesFromTableClick;
stack.Add(importMultipleDataSeriesFromTable);
if (NDbConnection.IsTypeSupported(ENDbConnectionType.Odbc))
{
NButton importMultipleDataSeriesFromDBReader = new NButton("Import Multiple Data Series\r\n(from NDbReader)");
importMultipleDataSeriesFromDBReader.Click += OnImportMultipleDataSeriesFromDBReaderClick;
stack.Add(importMultipleDataSeriesFromDBReader);
}
return group;
}
public string GetExampleDescription()
{
return @"This example demonstrates how import data from various data sources.
";
}
///
/// Gets the relevant documentation links for the example
///
///
public (string Name, string Url)[] GetDocumentationUrls()
{
return new[]
{
("Data Binding", "https://www.nevron.com/docs/openvision/chart-data-binding.html"),
("Chart Data Series", "https://www.nevron.com/docs/openvision/chart-data-series.html"),
("Data Tables", "https://www.nevron.com/docs/openvision/data-tables.html"),
("CSV Files", "https://www.nevron.com/docs/openvision/csv-files.html"),
("Excel Files", "https://www.nevron.com/docs/openvision/excel-files.html"),
};
}
#endregion
#region Implementation
private void OnImportMultipleDataSeriesFromEnumerablesClick(NEventArgs arg)
{
// clear chart
ClearChart();
// get chart
NCartesianChart chart = (NCartesianChart)m_ChartView.Surface.Charts[0];
// switch X axis in linear scale
chart.Axes[ENCartesianAxis.PrimaryX].Scale = new NLinearScale();
// create a point series to show the imported values
NPointSeries pointSeries = new NPointSeries();
chart.Series.Add(pointSeries);
pointSeries.ValueFormatter = new NNumericValueFormatter("0.00");
pointSeries.DataLabelStyle = new NDataLabelStyle();
pointSeries.DataLabelStyle.Visible = true;
pointSeries.DataLabelStyle.Format = "