void ImportFromCSV_Click(object sender, EventArgs e)
{
nChartControl1.Clear();
InitTitleAndBackground();
NBarSeries bar0 = (NBarSeries)nChartControl1.Charts[0].Series.Add(SeriesType.Bar);
bar0.Legend.Mode = SeriesLegendMode.DataPoints;
//bar0.FillStyle = new NColorFillStyle(Color.Aquamarine);
NBarSeries bar1 = (NBarSeries)nChartControl1.Charts[0].Series.Add(SeriesType.Bar);
bar1.Legend.Mode = SeriesLegendMode.DataPoints;
//bar0.FillStyle = new NColorFillStyle(Color.BurlyWood);
bar1.MultiBarMode = MultiBarMode.Clustered;
string csvFile = Application.StartupPath + "\\..\\..\\DataManipulation\\Importing\\Sample.csv";
NCsvReader reader = new NCsvReader();
reader.CellSeparator = ',';
reader.LineSeparators = new char[] { '\r', '\n' };
reader.HasHeader = false;
reader.EscapeCharacter = '\\';
reader.TrimCell = true;
reader.Columns.Add(new NStringCsvColumn("String Column"));
reader.Columns.Add(new NDoubleCsvColumn("Double Column"));
reader.Columns.Add(new NDecimalCsvColumn("Decimal Column"));
reader.Columns.Add(new NColorCsvColumn("Color0 Column"));
reader.Columns.Add(new NColorCsvColumn("Color1 Column"));
try
{
DataTable dt = reader.LoadDataTableFromFile(csvFile);
nChartControl1.DataBindingManager.AddBinding(0, 0, "Values", dt, "Double Column");
nChartControl1.DataBindingManager.AddBinding(0, 0, "Labels", dt, "String Column");
nChartControl1.DataBindingManager.AddBinding(0, 0, "FillStyles", dt, "Color0 Column");
nChartControl1.DataBindingManager.AddBinding(0, 1, "Values", dt, "Decimal Column");
nChartControl1.DataBindingManager.AddBinding(0, 1, "Labels", dt, "String Column");
nChartControl1.DataBindingManager.AddBinding(0, 1, "FillStyles", dt, "Color1 Column");
nDataGridView1.DataSource = dt;
nDataGridView1.AutoResizeColumns();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
nChartControl1.Refresh();
}
protected void Page_Load(object sender, EventArgs e)
{
nChartControl1.BackgroundStyle.FrameStyle.Visible = false;
nChartControl1.Panels.Clear();
// set a chart title
NLabel title = nChartControl1.Labels.AddHeader("Import from CSV File");
title.TextStyle.FontStyle = new NFontStyle("Times New Roman", 14, FontStyle.Italic);
title.TextStyle.ShadowStyle.Type = ShadowType.LinearBlur;
title.ContentAlignment = ContentAlignment.BottomRight;
title.Location = new NPointL(
new NLength(2, NRelativeUnit.ParentPercentage),
new NLength(2, NRelativeUnit.ParentPercentage));
NCartesianChart chart = new NCartesianChart();
NBarSeries bar0 = (NBarSeries)chart.Series.Add(SeriesType.Bar);
bar0.Legend.Mode = SeriesLegendMode.DataPoints;
//bar0.FillStyle = new NColorFillStyle(Color.Aquamarine);
NBarSeries bar1 = (NBarSeries)chart.Series.Add(SeriesType.Bar);
bar1.Legend.Mode = SeriesLegendMode.DataPoints;
//bar0.FillStyle = new NColorFillStyle(Color.BurlyWood);
bar1.MultiBarMode = MultiBarMode.Clustered;
string csvFile = this.MapPathSecure(this.TemplateSourceDirectory + "\\Sample.csv");
NCsvReader reader = new NCsvReader();
reader.CellSeparator = ',';
reader.LineSeparators = new char[] { '\r', '\n' };
reader.HasHeader = false;
reader.EscapeCharacter = '\\';
reader.TrimCell = true;
reader.Columns.Add(new NStringCsvColumn("String Column"));
reader.Columns.Add(new NDoubleCsvColumn("Double Column"));
reader.Columns.Add(new NDecimalCsvColumn("Decimal Column"));
reader.Columns.Add(new NColorCsvColumn("Color0 Column"));
reader.Columns.Add(new NColorCsvColumn("Color1 Column"));
// apply layout
ApplyLayoutTemplate(0, nChartControl1, chart, title, null);
// import
try
{
DataTable dt = reader.LoadDataTableFromFile(csvFile);
nChartControl1.DataBindingManager.AddBinding(0, 0, "Values", dt, "Double Column");
nChartControl1.DataBindingManager.AddBinding(0, 0, "Labels", dt, "String Column");
nChartControl1.DataBindingManager.AddBinding(0, 0, "FillStyles", dt, "Color0 Column");
nChartControl1.DataBindingManager.AddBinding(0, 1, "Values", dt, "Decimal Column");
nChartControl1.DataBindingManager.AddBinding(0, 1, "Labels", dt, "String Column");
nChartControl1.DataBindingManager.AddBinding(0, 1, "FillStyles", dt, "Color1 Column");
}
catch (Exception)
{
}
}
