Nevron NOV Chart for WPF ships with hundreds of examples with full source code, as part of the Nevron Open Vision Suite.
All WPF Chart examples are also available as a stand-alone Visual Studio solution
in C# and VB.NET,
which you can download from the links below.
Data Import Example for WPF Description
This example demonstrates how import data from various data sources.
C# Data Import Example Code for Nevron Chart for WPF
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 = "
Download a fully functional C# (.cs) Data Import Example for WPF Solution
VB.NET Data Import Example Code for Nevron Chart for WPF
Language: VB.NET
Imports Nevron.Nov
Imports Nevron.Nov.Chart
Imports Nevron.Nov.Data
Imports Nevron.Nov.DataStructures
Imports Nevron.Nov.Dom
Imports Nevron.Nov.Graphics
Imports Nevron.Nov.Layout
Imports Nevron.Nov.UI
Imports Nevron.Nov.Windows.Wpf
Imports System
Imports System.Collections
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 - NChartDataImportExample"
' 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
Dim chartViewWithCommandBars As NChartViewWithCommandBars = New NChartViewWithCommandBars()
m_ChartView = chartViewWithCommandBars.View
m_ChartView.Surface.CreatePredefinedChart(ENPredefinedChartType.Cartesian)
' add interlaced stripe for Y axis
Dim strip As NScaleStrip = New NScaleStrip(New NColorFill(NColor.Beige), Nothing, True, 0, 0, 1, 1)
strip.Interlaced = True
CType(m_ChartView.Surface.Charts(CInt(0)), NCartesianChart).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(Nothing)
Return chartViewWithCommandBars
End Function
Public Function CreateExampleControls() As NWidget
Dim stack As NStackPanel = New NStackPanel()
Dim group As NUniSizeBoxGroup = New NUniSizeBoxGroup(stack)
Dim importSingleDataSeries As NButton = New NButton("Import Single Data Series")
importSingleDataSeries.Click += AddressOf OnImportSingleDataSeriesClick
stack.Add(importSingleDataSeries)
Dim importMultipleDataSeriesFromEnumrables As NButton = New NButton("Import Multiple Data Series" & vbCrLf & "(from IEnumerables)")
importMultipleDataSeriesFromEnumrables.Click += AddressOf OnImportMultipleDataSeriesFromEnumerablesClick
stack.Add(importMultipleDataSeriesFromEnumrables)
Dim importMultipleDataSeriesFromTable As NButton = New NButton("Import Multiple Data Series" & vbCrLf & "(from NDataTable)")
importMultipleDataSeriesFromTable.Click += AddressOf OnImportMultipleDataSeriesFromTableClick
stack.Add(importMultipleDataSeriesFromTable)
If NDbConnection.IsTypeSupported(ENDbConnectionType.Odbc) Then
Dim importMultipleDataSeriesFromDBReader As NButton = New NButton("Import Multiple Data Series" & vbCrLf & "(from NDbReader)")
importMultipleDataSeriesFromDBReader.Click += AddressOf OnImportMultipleDataSeriesFromDBReaderClick
stack.Add(importMultipleDataSeriesFromDBReader)
End If
Return group
End Function
Public Function GetExampleDescription() As String
Return "
This example demonstrates how import data from various data sources.
"
End Function
'''
''' Gets the relevant documentation links for the example
'''
'''
Public Function GetDocumentationUrls() As (String, String)()
Return {("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")}
End Function
#End Region
#Region "Implementation"
Private Sub OnImportMultipleDataSeriesFromEnumerablesClick(arg As NEventArgs)
' clear chart
ClearChart()
' get chart
Dim chart = CType(m_ChartView.Surface.Charts(0), NCartesianChart)
' switch X axis in linear scale
chart.Axes(ENCartesianAxis.PrimaryX).Scale = New NLinearScale()
' create a point series to show the imported values
Dim pointSeries As NPointSeries = New NPointSeries()
chart.Series.Add(pointSeries)
pointSeries.ValueFormatter = New NNumericValueFormatter("0.00")
pointSeries.DataLabelStyle = New NDataLabelStyle()
pointSeries.DataLabelStyle.Visible = True
pointSeries.DataLabelStyle.Format = ""
pointSeries.DataLabelStyle.VertAlign = ENVerticalAlignment.Bottom
pointSeries.DataLabelStyle.ArrowLength = 30
' create random data series
Const dataPointCount = 10
Dim values As Double() = CreateRandomData(dataPointCount)
Dim xvalues As Double() = CreateRandomData(dataPointCount)
Dim labels = New String(values.Length - 1) {}
For i = 0 To dataPointCount - 1
labels(i) = "Label: " & (i + 1).ToString()
Next
' import multiple data series
pointSeries.DataPoints.SetDataSeries(New NKeyValuePair(Of IEnumerable, String)() {New NKeyValuePair(Of IEnumerable, String)(values, "Value"), New NKeyValuePair(Of IEnumerable, String)(xvalues, "X"), New NKeyValuePair(Of IEnumerable, String)(labels, "Label")})
End Sub
Private Sub OnImportMultipleDataSeriesFromTableClick(arg As NEventArgs)
' clear chart
ClearChart()
' get chart
Dim chart = CType(m_ChartView.Surface.Charts(0), NCartesianChart)
' switch X axis in linear scale
chart.Axes(ENCartesianAxis.PrimaryX).Scale = New NLinearScale()
' create a line series to show the imported values
Dim lineSeries As NLineSeries = New NLineSeries()
chart.Series.Add(lineSeries)
lineSeries.ValueFormatter = New NNumericValueFormatter("0.00")
lineSeries.DataLabelStyle = New NDataLabelStyle()
lineSeries.DataLabelStyle.Visible = True
lineSeries.DataLabelStyle.Format = ""
lineSeries.DataLabelStyle.VertAlign = ENVerticalAlignment.Bottom
lineSeries.DataLabelStyle.ArrowLength = 30
' create a table with random data
Dim table As NMemoryDataTable = New NMemoryDataTable(New NFieldInfo("Y", GetType(Double)), New NFieldInfo("X", GetType(Double)), New NFieldInfo("Label", GetType(String)))
Const dataPointCount = 10
Dim rnd As Random = New Random()
For i = 0 To dataPointCount - 1
table.AddRow()
table.SetValue(i, "Y", rnd.Next(0, 100))
table.SetValue(i, "X", rnd.Next(0, 100))
table.SetValue(i, "Label", "Label: " & i.ToString())
Next
' import multiple data series
lineSeries.DataPoints.SetDataSeries(table, New NKeyValuePair(Of String, String)() {New NKeyValuePair(Of String, String)("Y", "Value"), New NKeyValuePair(Of String, String)("X", "X"), New NKeyValuePair(Of String, String)("Label", "Label")})
End Sub
Private Sub OnImportMultipleDataSeriesFromDBReaderClick(arg As NEventArgs)
Dim topLevelWindow As NTopLevelWindow = NApplication.CreateTopLevelWindow()
topLevelWindow.Title = "Select DB Source"
Dim stack As NStackPanel = New NStackPanel()
' connection string
Dim connectionString As NTextBox = New NTextBox()
connectionString.Text = "DSN=Xtreme"
stack.Add(New NPairBox("Connection String:", connectionString))
' connection string
Dim sqlQuery As NTextBox = New NTextBox()
sqlQuery.Text = "SELECT * FROM SALES"
stack.Add(New NPairBox("SQL Query:", sqlQuery))
' value column
Dim valueColumn As NTextBox = New NTextBox()
valueColumn.Text = ""
stack.Add(New NPairBox("Value Column:", valueColumn))
' label column
Dim labelColumn As NTextBox = New NTextBox()
labelColumn.Text = ""
stack.Add(New NPairBox("Label Column:", labelColumn))
Dim buttonStrip As NButtonStrip = New NButtonStrip()
buttonStrip.AddOKCancelButtons()
stack.Add(buttonStrip)
topLevelWindow.Content = stack
topLevelWindow.Open()
topLevelWindow.Closed += Sub(e)
' clear chart
ClearChart()
' get chart
Dim chart = CType(m_ChartView.Surface.Charts(0), NCartesianChart)
' switch X axis in linear scale
chart.Axes(ENCartesianAxis.PrimaryX).Scale = New NOrdinalScale()
' create a point series to show the imported values
Dim pointSeries As NPointSeries = New NPointSeries()
chart.Series.Add(pointSeries)
pointSeries.ValueFormatter = New NNumericValueFormatter("0.00")
pointSeries.DataLabelStyle = New NDataLabelStyle()
pointSeries.DataLabelStyle.Visible = True
pointSeries.DataLabelStyle.Format = ""
pointSeries.DataLabelStyle.VertAlign = ENVerticalAlignment.Bottom
pointSeries.DataLabelStyle.ArrowLength = 30
' created random data series
Dim connection As NDbConnection = Nothing
Try
' try open the connection
connection = NDbConnection.Open(ENDbConnectionType.Odbc, connectionString.Text)
Dim dataReader = connection.ExecuteReader("SELECT * FROM SALES")
' TODO - execute queries and commands
' import multiple data series
Dim dataMappings As NList(Of NKeyValuePair(Of String, String)) = New NList(Of NKeyValuePair(Of String, String))()
If Not String.IsNullOrEmpty(valueColumn.Text) Then
dataMappings.Add(New NKeyValuePair(Of String, String)(valueColumn.Text, "Value"))
End If
If Not String.IsNullOrEmpty(labelColumn.Text) Then
dataMappings.Add(New NKeyValuePair(Of String, String)(labelColumn.Text, "Label"))
End If
pointSeries.DataPoints.SetDataSeries(dataReader, dataMappings.ToArray())
Catch ex As Exception
' TODO: report connection or execution error
NMessageBox.Show(ex.Message, "Data Import Error")
Finally
' close the connection
If connection IsNot Nothing Then
connection.Close()
End If
End Try
End Sub
End Sub
Private Sub OnImportSingleDataSeriesClick(arg As NEventArgs)
' clear chart
ClearChart()
' get chart
Dim chart = CType(m_ChartView.Surface.Charts(0), NCartesianChart)
' switch X axis in ordinal scale
chart.Axes(ENCartesianAxis.PrimaryX).Scale = New NOrdinalScale()
' create a bar series to show the imported values
Dim barSeries As NBarSeries = New NBarSeries()
chart.Series.Add(barSeries)
barSeries.ValueFormatter = New NNumericValueFormatter("0.00")
' import randomly created double[]
Dim values As Double() = CreateRandomData(10)
barSeries.DataPoints.SetDataSeries(values, "Value")
End Sub
Private Sub ClearChart()
Dim chart = CType(m_ChartView.Surface.Charts(0), NCartesianChart)
chart.Series.Clear()
End Sub
#End Region
#Region "Event Handlers"
#End Region
#Region "Fields"
Private m_ChartView As NChartView
#End Region
#Region "Static Methods"
#End Region
#Region "Constants"
#End Region
#Region "Nested Types"
#End Region
End Class
Download a fully functional VB.NET (.vb) Data Import Example for WPF Solution