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