Datatable不可以排序,要想排序隻能是給它的視圖DataView進行排序,這在制作Chart時很重要,因為對于時序圖而言,必須首先按照時間進行排序。
private void toolStripMenuItem1_Click(object sender, EventArgs e)
{
DataTable dt = this.dataGridView1.DataSource as DataTable;
dt.DefaultView.Sort = "年份";
DataView dv= new DataView(dt);//資料視圖,Datatable無法排序
dv.Sort = "年份";
ChartForm frm = new ChartForm();
frm.chart1.DataSource = dv;
frm.chart1.Series[0].XValueMember = "年份";
frm.chart1.Series[0].YValueMembers = strColumnName;
MessageBox.Show(strColumnName);
frm.chart1.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.FastLine;
frm.Show();
}