private void checkBoxEnableDatabinding_CheckedChanged(object sender, System.EventArgs e)
{
if (nChartControl1 == null)
{
return;
}
NDataBindingManager dataBindingManager = nChartControl1.DataBindingManager;
dataBindingManager.EnableDataBinding = checkBoxEnableDatabinding.Checked;
dataBindingManager.UpdateChartControl();
}
public override void Initialize()
{
base.Initialize();
// add a label
NLabel title = nChartControl1.Labels.AddHeader("Binding to DataAdapter");
title.TextStyle.FontStyle = new NFontStyle("Times New Roman", 18, FontStyle.Italic);
title.ContentAlignment = ContentAlignment.BottomCenter;
title.Location = new NPointL(new NLength(50, NRelativeUnit.ParentPercentage), new NLength(2, NRelativeUnit.ParentPercentage));
NChart chart = nChartControl1.Charts[0];
// add the bar series
NBarSeries bar = new NBarSeries();
chart.Series.Add(bar);
bar.Name = "Bar";
bar.Legend.Format = "<label>";
bar.DataLabelStyle.Format = "<label>";
bar.BarShape = BarShape.SmoothEdgeBar;
bar.Legend.Mode = SeriesLegendMode.DataPoints;
// connection string with relative path
this.oleDbConnection1.ConnectionString = @"Data Source=""" + Application.StartupPath + @"\..\..\DataManipulation\DataBinding\Data.mdb"";Provider=""Microsoft.Jet.OLEDB.4.0"";";
try
{
NDataBindingManager dataBindingManager = nChartControl1.DataBindingManager;
dataBindingManager.AddBinding(0, 0, "Values", oleDbDataAdapter1, "values");
dataBindingManager.AddBinding(0, 0, "Labels", oleDbDataAdapter1, "colors");
dataBindingManager.AddBinding(0, 0, "FillStyles", oleDbDataAdapter1, "colors");
dataBindingManager.UpdateChartControl();
oleDbDataAdapter1.Fill(dataSet1);
DataTable dataTable = dataSet1.Tables[0];
dataTable.Columns["id"].ReadOnly = true;
dataTable.RowChanged += new DataRowChangeEventHandler(dataTable_RowChanged);
dataView1.Table = dataTable;
}
catch (Exception x)
{
MessageBox.Show(x.Message);
}
}
public override void Initialize()
{
base.Initialize();
// setup background
// add a label
NLabel title = nChartControl1.Labels.AddHeader("Binding to DataTable");
title.TextStyle.FontStyle = new NFontStyle("Times New Roman", 18, FontStyle.Italic);
title.ContentAlignment = ContentAlignment.BottomCenter;
title.Location = new NPointL(new NLength(50, NRelativeUnit.ParentPercentage), new NLength(2, NRelativeUnit.ParentPercentage));
NChart chart = nChartControl1.Charts[0];
// add bar series 1
NBarSeries bar1 = (NBarSeries)chart.Series.Add(SeriesType.Bar);
bar1.Name = "Bar 1";
bar1.DataLabelStyle.Format = "<value>";
// add bar series 2
NBarSeries bar2 = (NBarSeries)chart.Series.Add(SeriesType.Bar);
bar2.MultiBarMode = MultiBarMode.Clustered;
bar2.FillStyle = new NColorFillStyle(Color.Violet);
bar2.Name = "Bar 2";
bar2.DataLabelStyle.Format = "<value>";
NDataBindingManager dataBindingManager = nChartControl1.DataBindingManager;
dataBindingManager.AddBinding(0, 0, "Values", dataTable, "ValueY1");
dataBindingManager.AddBinding(0, 1, "Values", dataTable, "ValueY2");
dataGrid1.SetDataBinding(dataTable, null);
}
