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ù)對MSChart學習:本次主要針對MSChart的圖形交互和AJAX的應(yīng)用。22二. AJAX(一)Click Event23三. AJAX(二)Chart as Trriger29四. AJAX(三)AJAX更新31五. AJAX(四)Real Time Chart35解決MSChart底部橫坐標顯示不全的問題 收藏38mschart 上下限閾值 畫橫線 收藏38MSChart for vs2008 收藏39MSCHART全部屬性方法介紹 收藏41在access 中創(chuàng)建庫表（.net實現(xiàn)）57MSChart學習幫助-開發(fā)日志（二）.net 3.5 圖表控件 收藏62三個電壓，三個電流70.NET MSChart應(yīng)用的一個簡單例子76初試 ASP.NET Chart Control83微軟圖表控件使用初探-數(shù)據(jù)綁定(交叉表)88MSChart圖表控件的一些使用96微軟Chart控件導學-數(shù)據(jù)綁定110Mschart學習(MSchart介紹)116微軟圖表控件MsChart使用初探122微軟Chart控件導學-渲染圖表135介紹MSChart的常用屬性和事件MSChart的元素組成最常用的屬性包括ChartAreas：增加多個繪圖區(qū)域，每個繪圖區(qū)域包含獨立的圖表組、數(shù)據(jù)源，用于多個圖表類型在一個繪圖區(qū)不兼容時。AlignmentOrientation：圖表區(qū)對齊方向，定義兩個繪圖區(qū)域間的對齊方式。AlignmentStyle：圖表區(qū)對齊類型，定義圖表間用以對其的元素。AlignWithChartArea：參照對齊的繪圖區(qū)名稱。InnerPlotPosition：圖表在繪圖區(qū)內(nèi)的位置屬性。Auto：是否自動對齊。Height：圖表在繪圖區(qū)內(nèi)的高度（百分比，取值在0-100 ）Width：圖表在繪圖區(qū)內(nèi)的寬度（百分比，取值在0-100 ）X,Y：圖表在繪圖區(qū)內(nèi)左上角坐標Position：繪圖區(qū)位置屬性，同InnerPlotPosition。Name：繪圖區(qū)名稱。Axis：坐標軸集合Title：坐標軸標題TitleAlignment：坐標軸標題對齊方式Interval：軸刻度間隔大小IntervalOffset：軸刻度偏移量大小MinorGrid：次要輔助線MinorTickMark：次要刻度線MajorGrid：主要輔助線MajorTickMark：主要刻度線DataSourceID：MSChart的數(shù)據(jù)源。Legends：圖例說明。Palette：圖表外觀定義。Series：最重要的屬性，圖表集合，就是最終看到的餅圖、柱狀圖、線圖、點圖等構(gòu)成的集合；可以將多種相互兼容的類型放在一個繪圖區(qū)域內(nèi)，形成復合圖。IsValueShownAsLabel：是否顯示數(shù)據(jù)點標簽，如果為true，在圖表中顯示每一個數(shù)據(jù)值Label：數(shù)據(jù)點標簽文本LabelFormat：數(shù)據(jù)點標簽文本格式LabelAngle：標簽字體角度Name：圖表名稱Points：數(shù)據(jù)點集合XValueType：橫坐標軸類型YValueType：縱坐標軸類型XValueMember：橫坐標綁定的數(shù)據(jù)源（如果數(shù)據(jù)源為Table，則填寫橫坐標要顯示的字段名稱 ）YValueMembers：縱坐標綁定的數(shù)據(jù)源（如果數(shù)據(jù)源為Table，則填寫縱坐標要顯示的字段名稱，縱坐標可以有兩個 ） ChartArea：圖表所屬的繪圖區(qū)域名稱ChartType：圖表類型（柱形、餅形、線形、點形等）Legend：圖表使用的圖例名稱Titles：標題集合。width：MSChart的寬度。height：MSChart的高度。常用事件：Series1.Points.DataBind() 綁定數(shù)據(jù)點集合，如果要在一個MSChart控件的一個繪圖區(qū)(ChartArea)內(nèi)添加多個不同數(shù)據(jù)源的圖表，就用這個主動綁定數(shù)據(jù)集合的方法。可以將表中指定字段的值綁定到指定的坐標軸上。MSChart1.DataBind() 給整個MSChart綁定一個數(shù)據(jù)源，該MSChart中的圖表全部可以使用該數(shù)據(jù)源作為統(tǒng)計來源。本文來自CSDN博客，轉(zhuǎn)載請標明出處：/jetable/archive/2009/01/08/3727444.aspx下面給一個自己做的例子：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; /圖片背景色 /建一個圖表集合 Series series = new Series(test); series.ChartType = SeriesChartType.Column; /圖標集類型，Line為直線，SpLine為曲線 series.Color = Color.Green; /線條顏色 series.BorderWidth = 2; /線條寬度 series.ShadowOffset = 1; /陰影寬度 series.IsVisibleInLegend =false; /是否顯示數(shù)據(jù)說明 series.IsValueShownAsLabel = true; series.MarkerStyle = MarkerStyle.Diamond; /線條上的數(shù)據(jù)點標志類型 series.MarkerSize = 8; / 標志的大小 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中 /再建一個圖表集合 Series series1 = new Series(ok); series1.ChartType = SeriesChartType.Column; /圖標集類型，Line為直線，SpLine為曲線 series1.Color = Color.Red; /線條顏色 series1.BorderWidth = 2; /線條寬度 series1.ShadowOffset = 1; /陰影寬度 series1.IsVisibleInLegend = false; /是否顯示數(shù)據(jù)說明 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è)置坐標軸 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; /圖片背景色 /建一個圖表集合 Series series = new Series(test); series.ChartType = SeriesChartType.Column; /圖標集類型，Line為直線，SpLine為曲線 series.Color = Color.Green; /線條顏色 series.BorderWidth = 2; /線條寬度 series.ShadowOffset = 1; /陰影寬度 series.IsVisibleInLegend =false; /是否顯示數(shù)據(jù)說明 series.IsValueShownAsLabel = true; series.MarkerStyle = MarkerStyle.Diamond; /線條上的數(shù)據(jù)點標志類型 series.MarkerSize = 8; / 標志的大小 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中 /再建一個圖表集合 Series series1 = new Series(ok); series1.ChartType = SeriesChartType.Column; /圖標集類型，Line為直線，SpLine為曲線 series1.Color = Color.Red; /線條顏色 series1.BorderWidth = 2; /線條寬度 series1.ShadowOffset = 1; /陰影寬度 series1.IsVisibleInLegend = false; /是否顯示數(shù)據(jù)說明 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è)置坐標軸 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)); /圖表標題 /新建連接 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ù)說明 Chart1.Series1.MarkerStyle = MarkerStyle.Circle; /線條上的數(shù)據(jù)點標志類型 Chart1.Series1.MarkerSize = 8; /標志大小 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 = 價格; /Y軸標題 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)); /圖表標題 /新建連接 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ù)說明 Chart1.Series1.MarkerStyle = MarkerStyle.Circle; /線條上的數(shù)據(jù)點標志類型 Chart1.Series1.MarkerSize = 8; /標志大小 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 = 價格; /Y軸標題 效果圖如下：數(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)); /圖表標題 /新建連接 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)); /圖表標題 /新建連接 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)); /圖表標題 /新建連接 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)); /圖表標題 /新建連接 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)); /圖表標題 /新建連接 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); 效果圖如下：（有點不理想，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); /圖表標題 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); /圖表標題 using (OleDbConnection con=new OleDbConnection(PROVIDE