Renaming and saving file each time code executes

Farhan Shariff

I have a DataTable

new	Old	New_1	plot
2.1	1.1	4.3	0.60
0.4	1.2	2.1	0.12
3.1	2.3	3.2	0.29

I want to plot chart's with: 1new vs plot , Old vs plot, new_1 vs plot1 and save each of plots as images thus creating multiple chart images one for each column.
I want to use column index, the index of plot column is fixed.
I think if I am able to save image with different names each time and loop the column index ,I will be able to generate charts for each column.

for(int g=0; g< resultDt.Columns.Count-1;g++)
{

Chart chart = new Chart();
chart.DataSource = resultDt;
chart.Width = 800;
chart.Height = 550;
//create serie...
Series serie1 = new Series();
serie1.Name = "Serie1";
serie1.Color = Color.FromArgb(112, 255, 200);
serie1.BorderColor = Color.FromArgb(164, 164, 164);
serie1.ChartType = SeriesChartType.Line;

serie1.XValueMember = resultDt.Columns[0].ColumnName;
serie1.YValueMembers = "plot";

chart.Series.Add(serie1);
//create chartareas...
ChartArea ca = new ChartArea();
ca.Name = "ChartArea1";
ca.BackColor = Color.White;
ca.BorderColor = Color.FromArgb(26, 59, 105);
ca.BorderWidth = 0;
ca.BorderDashStyle = ChartDashStyle.Solid;
ca.AxisX = new Axis();
ca.AxisY = new Axis();

//ChartArea ca = new ChartArea("main");
ca.BackColor = System.Drawing.Color.FromArgb(64, System.Drawing.Color.White);
chart.ChartAreas.Add(ca);

//databind...
chart.DataBind();

//save result...
chart.SaveImage(@"C:\myChart.png", ChartImageFormat.Png);

}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
Accepted answer
On the face of it, it's just a matter of changing this line so that it saves to a different file each time around the loop:

chart.SaveImage(@"C:\myChart.png", ChartImageFormat.Png);

If you want to use myChart1.png, myChart2.png and so on, then I'd change it to:

chart.SaveImage(@"C:\myChart" + (g + 1).ToString() + ".png", ChartImageFormat.Png);
Farhan Shariff12y ago
by using these I have finally combined the graphs with real and reference curves

Thank's A lot Vulpes. You are the BEST.

chart1.Series["Series1"].Points.DataBindXY(ds.Tables[0].DefaultView, table8.Columns[g].ColumnName, ds.Tables[0].DefaultView, "plot");
chart1.Series["Series2"].Points.DataBindXY(ds.Tables[1].DefaultView, table8.Columns[g].ColumnName, ds.Tables[1].DefaultView, "plot"); // binding to second table
chart1.SaveImage(@"C:\Matlab\" + (g).ToString() + ".png", ChartImageFormat.Png);
Vulpes12y ago
On the first question, the DataTable.Merge method can only be used with DataTables which have largely the same schema. So, if the two tables have columns with the same name, they will map to the same column in the merged table.

If you want to merge two datatables which don't have similar schemas but do have columns with the same name, then you'll have to create the merged table 'manually' and give one of those columns a different name in the merged table.

On the second question, whilst you can set the DataSource to be a DataSet, I think you'll find that all Series will use columns in the first table (or throw an exception otherwise) as there doesn't appear to be a way to distinguish which table is to used.

However, if instead of setting the DataSource and calling the DataBind method, you bind directly to the points collection like the following, then it should work:

chart1.Series["Series1"].Points.DataBindXY(ds.Tables[0].DefaultView, "someCol1", ds.Tables[0].DefaultView, "someCol2"); // binding to first table

chart1.Series["Series2"].Points.DataBindXY(ds.Tables[1].DefaultView, "someCol3", ds.Tables[1].DefaultView, "someCol4"); // binding to second table
Farhan Shariff12y ago
I have a 2 question?. 1.Can I merge or join Datatable with same column name. 2.Suppose I create a Dataset (If I am not wrong dataset is collection of datatables.)then by using dataset for datasource can I plot columns from two different datatables in Single chart area using different Series