Profile Picture

Column Headings on a DataView on a DataGrid

Posted By Paul Mathieu 13 Years Ago
Author
Message
Paul Mathieu
Posted 13 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: Forum Members
Last Active: 3 Years Ago
Posts: 4, Visits: 5
NChart chart = nChartControl1.Charts[0];
NDataSeriesCollection arrSeries = new NDataSeriesCollection();
NSmoothLineSeries movedata = (NSmoothLineSeries)chart.Series[0];
arrSeries.Add(movedata.Labels, DataSeriesMask.Labels);
dataView1.Table = arrSeries.ExportToDataTable(sTableName);

How do you rename the column heading "Labels" to something else?

Can it be done with
dataView1.Table.Columns.Add(...)
If it can be renamed here or added here, how would you add the data to that specific column?

Third question: Ctrl A,Crtl C then Ctrl V on excel spreadsheet will transfer the data.
Can it be exported to an excel spreadsheet with DDE or oleDb?

Thank you,
Paul



Nevron Support
Posted 13 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)

Group: Forum Members
Last Active: Last Week
Posts: 3,054, Visits: 4,009

Hello Paul,

The Caption of the created column can be changed by changing the name of the respective data series in the chart, for example:

    series.Labels.Name = "MyColumn";

You cannot export a data series to a specific (pre-created) DataTable column, but since you can set the column name this shouldn't be a problem. Regarding export to Excel spreadsheets - currently the chart doesn't provide such functionality.



Best Regards,
Nevron Support Team



Paul Mathieu
Posted 13 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: Forum Members
Last Active: 3 Years Ago
Posts: 4, Visits: 5
Thank you for the information.
I am using the DataGridView which can be customize.
Added code to export to excel from the DataGridView.
Will look again at the NDataGridView.
Thanks again,
Paul




Similar Topics


Reading This Topic