MSChart的研究(二)

继续上篇：

      chart可以有下列几种数据源：

              1.视图对象

              2.dataRead对象（xml，sql，oledb）

              3.dataSet对象

              4.dataRow对象

              5.dataColumn对象

              6.数组对象

              7.List对象

              8.sqlCommand对象（oledbCommand）

              9.sqlDataAdapter对象（oledbDataAdapter）

              10.所有实现IEnumerable借口的对象

 

一.数据源——xml

代码：

protected void Page_Load(object sender, EventArgs e) { string fileNameString = Server.MapPath(".//App_Data//data.xml"); string fileNameSchema = Server.MapPath(".//App_data//data.xsd"); DataSet ds = new DataSet(); ds.ReadXmlSchema(fileNameSchema); ds.ReadXml(fileNameString); DataView dv = new DataView(ds.Tables[0]); Chart1.DataBindTable(dv,"Name"); }

效果图：

二.数据源——Excel

代码：

protected void Page_Load(object sender, EventArgs e) { string fileNameString = Server.MapPath(".//App_Data//ExcelData.xls"); //连接Excel数据源 string conStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + fileNameString + ";Extended Properties=/"Excel 8.0;HDR=YES/""; OleDbConnection con = new OleDbConnection(conStr); con.Open(); OleDbCommand cmd = new OleDbCommand("select * from [data1$A1:E25]", con); OleDbDataReader read = cmd.ExecuteReader(); chart1.DataBindTable(read, "HOUR"); read.Close(); con.Close(); for (int i = 1; i < chart1.Series.Count; i++) { chart1.Series[i].ChartType = SeriesChartType.Line; chart1.Series[i].BorderWidth = 2; } chart1.Legends.Add("Default"); //设置表 chart1.Width = 600; chart1.Height = 400; chart1.BackColor = Color.Azure; }
效果图：

 

 

三.数据源——CSV文件

代码：

protected void Page_Load(object sender, EventArgs e) { string file = "DataFile.csv"; //获取路径 string path = Server.MapPath(".//App_Data//"); string sql = "select * from " + file; string conStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=/"Text;HDR=No;FMT=Delimited/""; OleDbConnection con=new OleDbConnection(conStr); con.Open(); OleDbCommand cmd=new OleDbCommand(sql,con); OleDbDataReader read=cmd.ExecuteReader(); //"1"表示第一列即时间列，"2"表示第二列 Chart1.Series[0].Points.DataBindXY(read,"1",read,"2"); Chart1.Series[0].ChartType = SeriesChartType.Line; Chart1.Width = 600; Chart1.Height = 400; Chart1.BackColor = Color.Azure; read.Close(); con.Close(); }

效果图：