MSChart控件資料大合集.doc

介紹MSChart的常用屬性和事件2數(shù)據(jù)源綁定（一），具體代碼如下：6數(shù)據(jù)源綁定方式（二）8數(shù)據(jù)源綁定（三）：9數(shù)據(jù)源綁定（四）：11數(shù)據(jù)源綁定（四）行綁定13數(shù)據(jù)源綁定（五）15MSChart的研究(二) 收藏17一.數(shù)據(jù)源xml18二.數(shù)據(jù)源Excel18三.數(shù)據(jù)源CSV文件20繼續(xù)對(duì)MSChart學(xué)習(xí):本次主要針對(duì)MSChart的圖形交互和AJAX的應(yīng)用。22二. AJAX(一)Click Event23三. AJAX(二)Chart as Trriger29四. AJAX(三)AJAX更新31五. AJAX(四)Real Time Chart35解決MSChart底部橫坐標(biāo)顯示不全的問(wèn)題 收藏38mschart 上下限閾值 畫(huà)橫線 收藏38MSChart for vs2008 收藏39MSCHART全部屬性方法介紹 收藏41在access 中創(chuàng)建庫(kù)表（.net實(shí)現(xiàn)）57MSChart學(xué)習(xí)幫助-開(kāi)發(fā)日志（二）.net 3.5 圖表控件 收藏62三個(gè)電壓，三個(gè)電流70.NET MSChart應(yīng)用的一個(gè)簡(jiǎn)單例子76初試 ASP.NET Chart Control83微軟圖表控件使用初探-數(shù)據(jù)綁定(交叉表)88MSChart圖表控件的一些使用96微軟Chart控件導(dǎo)學(xué)-數(shù)據(jù)綁定110Mschart學(xué)習(xí)(MSchart介紹)116微軟圖表控件MsChart使用初探122微軟Chart控件導(dǎo)學(xué)-渲染圖表135介紹MSChart的常用屬性和事件MSChart的元素組成最常用的屬性包括ChartAreas：增加多個(gè)繪圖區(qū)域，每個(gè)繪圖區(qū)域包含獨(dú)立的圖表組、數(shù)據(jù)源，用于多個(gè)圖表類型在一個(gè)繪圖區(qū)不兼容時(shí)。AlignmentOrientation：圖表區(qū)對(duì)齊方向，定義兩個(gè)繪圖區(qū)域間的對(duì)齊方式。AlignmentStyle：圖表區(qū)對(duì)齊類型，定義圖表間用以對(duì)其的元素。AlignWithChartArea：參照對(duì)齊的繪圖區(qū)名稱。InnerPlotPosition：圖表在繪圖區(qū)內(nèi)的位置屬性。Auto：是否自動(dòng)對(duì)齊。Height：圖表在繪圖區(qū)內(nèi)的高度（百分比，取值在0-100 ）Width：圖表在繪圖區(qū)內(nèi)的寬度（百分比，取值在0-100 ）X,Y：圖表在繪圖區(qū)內(nèi)左上角坐標(biāo)Position：繪圖區(qū)位置屬性，同InnerPlotPosition。Name：繪圖區(qū)名稱。Axis：坐標(biāo)軸集合Title：坐標(biāo)軸標(biāo)題TitleAlignment：坐標(biāo)軸標(biāo)題對(duì)齊方式Interval：軸刻度間隔大小IntervalOffset：軸刻度偏移量大小MinorGrid：次要輔助線MinorTickMark：次要刻度線MajorGrid：主要輔助線MajorTickMark：主要刻度線DataSourceID：MSChart的數(shù)據(jù)源。Legends：圖例說(shuō)明。Palette：圖表外觀定義。Series：最重要的屬性，圖表集合，就是最終看到的餅圖、柱狀圖、線圖、點(diǎn)圖等構(gòu)成的集合；可以將多種相互兼容的類型放在一個(gè)繪圖區(qū)域內(nèi)，形成復(fù)合圖。IsValueShownAsLabel：是否顯示數(shù)據(jù)點(diǎn)標(biāo)簽，如果為true，在圖表中顯示每一個(gè)數(shù)據(jù)值Label：數(shù)據(jù)點(diǎn)標(biāo)簽文本LabelFormat：數(shù)據(jù)點(diǎn)標(biāo)簽文本格式LabelAngle：標(biāo)簽字體角度Name：圖表名稱Points：數(shù)據(jù)點(diǎn)集合XValueType：橫坐標(biāo)軸類型YValueType：縱坐標(biāo)軸類型XValueMember：橫坐標(biāo)綁定的數(shù)據(jù)源（如果數(shù)據(jù)源為T(mén)able，則填寫(xiě)橫坐標(biāo)要顯示的字段名稱 ）YValueMembers：縱坐標(biāo)綁定的數(shù)據(jù)源（如果數(shù)據(jù)源為T(mén)able，則填寫(xiě)縱坐標(biāo)要顯示的字段名稱，縱坐標(biāo)可以有兩個(gè) ） ChartArea：圖表所屬的繪圖區(qū)域名稱ChartType：圖表類型（柱形、餅形、線形、點(diǎn)形等）Legend：圖表使用的圖例名稱Titles：標(biāo)題集合。width：MSChart的寬度。height：MSChart的高度。常用事件：Series1.Points.DataBind() 綁定數(shù)據(jù)點(diǎn)集合，如果要在一個(gè)MSChart控件的一個(gè)繪圖區(qū)(ChartArea)內(nèi)添加多個(gè)不同數(shù)據(jù)源的圖表，就用這個(gè)主動(dòng)綁定數(shù)據(jù)集合的方法?？梢詫⒈碇兄付ㄗ侄蔚闹到壎ǖ街付ǖ淖鴺?biāo)軸上。MSChart1.DataBind() 給整個(gè)MSChart綁定一個(gè)數(shù)據(jù)源，該MSChart中的圖表全部可以使用該數(shù)據(jù)源作為統(tǒng)計(jì)來(lái)源。本文來(lái)自CSDN博客，轉(zhuǎn)載請(qǐng)標(biāo)明出處：/jetable/archive/2009/01/08/3727444.aspx下面給一個(gè)自己做的例子：view plaincopy to clipboardprint?int date = new int 20, 40, 50, 80, 30, 10, 60 ; int test = new int 10, 80, 70, 40, 20, 50,90; Chart1.Width = 600; /圖片寬度 Chart1.Height = 400; /圖片高度 Chart1.BackColor = Color.Azure; /圖片背景色 /建一個(gè)圖表集合 Series series = new Series(test); series.ChartType = SeriesChartType.Column; /圖標(biāo)集類型，Line為直線，SpLine為曲線 series.Color = Color.Green; /線條顏色 series.BorderWidth = 2; /線條寬度 series.ShadowOffset = 1; /陰影寬度 series.IsVisibleInLegend =false; /是否顯示數(shù)據(jù)說(shuō)明 series.IsValueShownAsLabel = true; series.MarkerStyle = MarkerStyle.Diamond; /線條上的數(shù)據(jù)點(diǎn)標(biāo)志類型 series.MarkerSize = 8; / 標(biāo)志的大小 DateTime date1 = DateTime.Now.Date; for (int i = 0; i date.Length; i+) series.Points.AddXY(date1, datei); date1 = date1.AddDays(1); Chart1.Series.Add(series); /把數(shù)據(jù)集添加到Chart1中 /再建一個(gè)圖表集合 Series series1 = new Series(ok); series1.ChartType = SeriesChartType.Column; /圖標(biāo)集類型，Line為直線，SpLine為曲線 series1.Color = Color.Red; /線條顏色 series1.BorderWidth = 2; /線條寬度 series1.ShadowOffset = 1; /陰影寬度 series1.IsVisibleInLegend = false; /是否顯示數(shù)據(jù)說(shuō)明 series1.IsValueShownAsLabel = true; series1.MarkerStyle = MarkerStyle.Diamond; series1.MarkerSize = 8; DateTime date2 = DateTime.Now.Date; for (int i = 0; i test.Length; i+) series1.Points.AddXY(date2, testi); date2 = date2.AddDays(1); Chart1.Series.Add(series1); /把數(shù)據(jù)集添加到Chart1中 /設(shè)置坐標(biāo)軸 Chart1.ChartAreas0.AxisX.LineColor = Color.Blue; Chart1.ChartAreas0.AxisY.LineColor = Color.Blue; Chart1.ChartAreas0.AxisX.LineWidth = 2; Chart1.ChartAreas0.AxisY.LineWidth = 2; Chart1.ChartAreas0.AxisY.Title = 總額; /設(shè)置網(wǎng)格線 Chart1.ChartAreas0.AxisX.MajorGrid.LineColor = Color.Blue; Chart1.ChartAreas0.AxisY.MajorGrid.LineColor = Color.Blue; int date = new int 20, 40, 50, 80, 30, 10, 60 ; int test = new int 10, 80, 70, 40, 20, 50,90; Chart1.Width = 600; /圖片寬度 Chart1.Height = 400; /圖片高度 Chart1.BackColor = Color.Azure; /圖片背景色 /建一個(gè)圖表集合 Series series = new Series(test); series.ChartType = SeriesChartType.Column; /圖標(biāo)集類型，Line為直線，SpLine為曲線 series.Color = Color.Green; /線條顏色 series.BorderWidth = 2; /線條寬度 series.ShadowOffset = 1; /陰影寬度 series.IsVisibleInLegend =false; /是否顯示數(shù)據(jù)說(shuō)明 series.IsValueShownAsLabel = true; series.MarkerStyle = MarkerStyle.Diamond; /線條上的數(shù)據(jù)點(diǎn)標(biāo)志類型 series.MarkerSize = 8; / 標(biāo)志的大小 DateTime date1 = DateTime.Now.Date; for (int i = 0; i date.Length; i+) series.Points.AddXY(date1, datei); date1 = date1.AddDays(1); Chart1.Series.Add(series); /把數(shù)據(jù)集添加到Chart1中 /再建一個(gè)圖表集合 Series series1 = new Series(ok); series1.ChartType = SeriesChartType.Column; /圖標(biāo)集類型，Line為直線，SpLine為曲線 series1.Color = Color.Red; /線條顏色 series1.BorderWidth = 2; /線條寬度 series1.ShadowOffset = 1; /陰影寬度 series1.IsVisibleInLegend = false; /是否顯示數(shù)據(jù)說(shuō)明 series1.IsValueShownAsLabel = true; series1.MarkerStyle = MarkerStyle.Diamond; series1.MarkerSize = 8; DateTime date2 = DateTime.Now.Date; for (int i = 0; i test.Length; i+) series1.Points.AddXY(date2, testi); date2 = date2.AddDays(1); Chart1.Series.Add(series1); /把數(shù)據(jù)集添加到Chart1中 /設(shè)置坐標(biāo)軸 Chart1.ChartAreas0.AxisX.LineColor = Color.Blue; Chart1.ChartAreas0.AxisY.LineColor = Color.Blue; Chart1.ChartAreas0.AxisX.LineWidth = 2; Chart1.ChartAreas0.AxisY.LineWidth = 2; Chart1.ChartAreas0.AxisY.Title = 總額; /設(shè)置網(wǎng)格線 Chart1.ChartAreas0.AxisX.MajorGrid.LineColor = Color.Blue; Chart1.ChartAreas0.AxisY.MajorGrid.LineColor = Color.Blue; 最后顯示的圖片：數(shù)據(jù)源綁定（一），具體代碼如下：view plaincopy to clipboardprint?protected void Page_Load(object sender, EventArgs e) string fileName = Server.MapPath(.); fileName += App_Datachartdata.mdb; Chart1.Width = 600; /圖表寬度 Chart1.Height = 400; /圖表高度 Chart1.BackColor = Color.Azure; /圖表背景色 Chart1.Titles.Add(房地產(chǎn)); /圖表標(biāo)題 /新建連接 using (OleDbConnection con=new OleDbConnection(PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=+fileName) OleDbCommand cmd = new OleDbCommand(SELECT Name, Sales FROM REPS, con); con.Open(); OleDbDataReader read = cmd.ExecuteReader(); Chart1.DataBindTable(read, Name); read.Close(); /注意數(shù)據(jù)綁定后，它的series是1而不是0 Chart1.Series1.IsValueShownAsLabel = true; /是否顯示數(shù)據(jù) Chart1.Series1.IsVisibleInLegend = false; /是否顯示數(shù)據(jù)說(shuō)明 Chart1.Series1.MarkerStyle = MarkerStyle.Circle; /線條上的數(shù)據(jù)點(diǎn)標(biāo)志類型 Chart1.Series1.MarkerSize = 8; /標(biāo)志大小 Chart1.ChartAreas0.AxisX.LineColor = Color.Blue; /X軸顏色 Chart1.ChartAreas0.AxisY.LineColor = Color.Blue; /Y軸顏色 Chart1.ChartAreas0.AxisX.LineWidth = 2; /X軸寬度 Chart1.ChartAreas0.AxisY.LineWidth = 2; /Y軸寬度 Chart1.ChartAreas0.AxisY.Title = 價(jià)格; /Y軸標(biāo)題 protected void Page_Load(object sender, EventArgs e) string fileName = Server.MapPath(.); fileName += App_Datachartdata.mdb; Chart1.Width = 600; /圖表寬度 Chart1.Height = 400; /圖表高度 Chart1.BackColor = Color.Azure; /圖表背景色 Chart1.Titles.Add(房地產(chǎn)); /圖表標(biāo)題 /新建連接 using (OleDbConnection con=new OleDbConnection(PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=+fileName) OleDbCommand cmd = new OleDbCommand(SELECT Name, Sales FROM REPS, con); con.Open(); OleDbDataReader read = cmd.ExecuteReader(); Chart1.DataBindTable(read, Name); read.Close(); /注意數(shù)據(jù)綁定后，它的series是1而不是0 Chart1.Series1.IsValueShownAsLabel = true; /是否顯示數(shù)據(jù) Chart1.Series1.IsVisibleInLegend = false; /是否顯示數(shù)據(jù)說(shuō)明 Chart1.Series1.MarkerStyle = MarkerStyle.Circle; /線條上的數(shù)據(jù)點(diǎn)標(biāo)志類型 Chart1.Series1.MarkerSize = 8; /標(biāo)志大小 Chart1.ChartAreas0.AxisX.LineColor = Color.Blue; /X軸顏色 Chart1.ChartAreas0.AxisY.LineColor = Color.Blue; /Y軸顏色 Chart1.ChartAreas0.AxisX.LineWidth = 2; /X軸寬度 Chart1.ChartAreas0.AxisY.LineWidth = 2; /Y軸寬度 Chart1.ChartAreas0.AxisY.Title = 價(jià)格; /Y軸標(biāo)題 效果圖如下：數(shù)據(jù)源綁定方式（二）view plaincopy to clipboardprint?protected void Page_Load(object sender, EventArgs e) string fileName = Server.MapPath(.); fileName += App_Datachartdata.mdb; Chart1.Width = 600; /圖表寬度 Chart1.Height = 400; /圖表高度 Chart1.BackColor = Color.Azure; /圖表背景色 Chart1.Titles.Add(房地產(chǎn)); /圖表標(biāo)題 /新建連接 using (OleDbConnection con=new OleDbConnection(PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=+fileName) OleDbCommand cmd = new OleDbCommand(SELECT Name, Sales FROM REPS, con); con.Open(); /OleDbDataReader read = cmd.ExecuteReader(); /Chart1.DataBindTable(read, Name); /read.Close(); Chart1.DataSource = cmd; Chart1.Series0.XValueMember = Name; Chart1.Series0.YValueMembers = Sales; con.Close(); Chart1.DataBind(); 效果圖如下：數(shù)據(jù)源綁定（三）：view plaincopy to clipboardprint?protected void Page_Load(object sender, EventArgs e) string fileName = Server.MapPath(.); fileName += App_Datachartdata.mdb; Chart1.Width = 600; /圖表寬度 Chart1.Height = 400; /圖表高度 Chart1.BackColor = Color.Azure; /圖表背景色 Chart1.Titles.Add(房地產(chǎn)); /圖表標(biāo)題 /新建連接 using (OleDbConnection con=new OleDbConnection(PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=+fileName) OleDbCommand cmd = new OleDbCommand(SELECT GrossSales FROM SALES WHERE QuarterEnding #01/01/2002#, con); con.Open(); OleDbDataReader read = cmd.ExecuteReader(); Chart1.Series0.Points.DataBindY(read, GrossSales); read.Close(); protected void Page_Load(object sender, EventArgs e) string fileName = Server.MapPath(.); fileName += App_Datachartdata.mdb; Chart1.Width = 600; /圖表寬度 Chart1.Height = 400; /圖表高度 Chart1.BackColor = Color.Azure; /圖表背景色 Chart1.Titles.Add(房地產(chǎn)); /圖表標(biāo)題 /新建連接 using (OleDbConnection con=new OleDbConnection(PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=+fileName) OleDbCommand cmd = new OleDbCommand(SELECT GrossSales FROM SALES WHERE QuarterEnding #01/01/2002#, con); con.Open(); OleDbDataReader read = cmd.ExecuteReader(); Chart1.Series0.Points.DataBindY(read, GrossSales); read.Close(); 效果圖如下：數(shù)據(jù)源綁定（四）： view plaincopy to clipboardprint?protected void Page_Load(object sender, EventArgs e) string fileName = Server.MapPath(.); fileName += App_Datachartdata.mdb; Chart1.Width = 600; /圖表寬度 Chart1.Height = 400; /圖表高度 Chart1.BackColor = Color.Azure; /圖表背景色 Chart1.Titles.Add(房地產(chǎn)); /圖表標(biāo)題 /新建連接 using (OleDbConnection con=new OleDbConnection(PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=+fileName) OleDbCommand cmd = new OleDbCommand(SELECT * FROM REPSALES, con); con.Open(); OleDbDataReader read = cmd.ExecuteReader(); Chart1.DataBindCrossTable(read, Name, Year, Sales, Label=CommissionsC); read.Close(); / Chart1.Legends.Add(Name); protected void Page_Load(object sender, EventArgs e) string fileName = Server.MapPath(.); fileName += App_Datachartdata.mdb; Chart1.Width = 600; /圖表寬度 Chart1.Height = 400; /圖表高度 Chart1.BackColor = Color.Azure; /圖表背景色 Chart1.Titles.Add(房地產(chǎn)); /圖表標(biāo)題 /新建連接 using (OleDbConnection con=new OleDbConnection(PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=+fileName) OleDbCommand cmd = new OleDbCommand(SELECT * FROM REPSALES, con); con.Open(); OleDbDataReader read = cmd.ExecuteReader(); Chart1.DataBindCrossTable(read, Name, Year, Sales, Label=CommissionsC); read.Close(); / Chart1.Legends.Add(Name); 效果圖如下：（有點(diǎn)不理想，Legend中出現(xiàn)了Series1，關(guān)于legend的設(shè)置還有待研究）數(shù)據(jù)源綁定（四）行綁定view plaincopy to clipboardprint?protected void Page_Load(object sender, EventArgs e) string fileName = Server.MapPath(.); fileName += App_Datachartdata.mdb; Chart1.Width = 600; /圖表寬度 Chart1.Height = 400; /圖表高度 Chart1.BackColor = Color.Azure; /圖表背景色 Chart1.Titles.Add(Bind By Rows); /圖表標(biāo)題 using (OleDbConnection con=new OleDbConnection(PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source= + fileName) OleDbCommand cmd = new OleDbCommand(SELECT * FROM SALESCOUNTS, con); OleDbDataAdapter oda = new OleDbDataAdapter(); oda.SelectCommand = cmd; DataSet ds = new DataSet(); oda.Fill(ds); foreach (DataRow row in ds.Tables0.Rows) string seriesName=rowSalesRep.ToString(); Chart1.Series.Add(seriesName); Chart1.SeriesseriesName.ChartType = SeriesChartType.Line; Chart1.SeriesseriesName.BorderWidth = 2; for (int col = 1; col ds.Tables0.Columns.Count; col+) string colName = ds.Tables0.Columnscol.ColumnName; int yVal = Convert.ToInt32(rowcolName.ToString(); Chart1.SeriesseriesName.Points.AddXY(colName, yVal); protected void Page_Load(object sender, EventArgs e) string fileName = Server.MapPath(.); fileName += App_Datachartdata.mdb; Chart1.Width = 600; /圖表寬度 Chart1.Height = 400; /圖表高度 Chart1.BackColor = Color.Azure; /圖表背景色 Chart1.Titles.Add(Bind By Rows); /圖表標(biāo)題 using (OleDbConnection con=new OleDbConnection(PROVIDE