c#-ms-chart-控件使用方法匯總(附統(tǒng)計(jì)圖)

1、精選優(yōu)質(zhì)文檔傾情為你奉上精選優(yōu)質(zhì)文檔傾情為你奉上專心專注專業(yè)專心專注專業(yè)精選優(yōu)質(zhì)文檔傾情為你奉上專心專注專業(yè)第一個(gè)簡(jiǎn)單的chart：創(chuàng)建曲線圖 chart1.Series.Clear(); Series series = new Series(Spline); series.ChartType = SeriesChartType.Spline; series.BorderWidth = 3; series.ShadowOffset = 2; / Populate new series with data series.Points.AddY(67); series.Points.AddY(57

2、); series.Points.AddY(83); series.Points.AddY(23); series.Points.AddY(70); series.Points.AddY(60); series.Points.AddY(90); series.Points.AddY(20); / Add series into the charts series collection chart1.Series.Add(series);同時(shí)顯示2條曲線/ Populate series with random dataRandom random = new Random();for (int

3、pointIndex = 0; pointIndex 10;pointIndex+)Chart1.SeriesSeries1.Points.AddY(random.Next(45, 95);Chart1.SeriesSeries2.Points.AddY(random.Next(5, 75);/ Set series chart typeChart1.SeriesSeries1.ChartType = SeriesChartType.Line;Chart1.SeriesSeries2.ChartType = SeriesChartType.Spline;/ Set point labelsCh

4、art1.SeriesSeries1.IsValueShownAsLabel = true;Chart1.SeriesSeries2.IsValueShownAsLabel = true;/ Enable X axis marginChart1.ChartAreasChartArea1.AxisX.IsMarginVisible = true;/ Enable 3D, and show data point marker linesChart1.ChartAreasChartArea1.Area3DStyle.Enable3D = true;Chart1.SeriesSeries1ShowMa

5、rkerLines = True;Chart1.SeriesSeries2ShowMarkerLines = True;顯示column類型圖,柱狀圖/ Create new data series and set its visual attributesChart1.Series.Clear();Series series = new Series(FlowRead);series.ChartType = SeriesChartType.Column;series.BorderWidth = 3;series.ShadowOffset = 2;/ Populate new series w

6、ith dataseries.Points.AddY(67);series.Points.AddY(57);series.Points.AddY(83);series.Points.AddY(23);series.Points.AddY(70);series.Points.AddY(60);series.Points.AddY(90);series.Points.AddY(20);/ Add series into the charts series collectionChart1.Series.Add(series);很多點(diǎn)，效率還可以/ Fill series datadouble yV

7、alue = 50.0;Random random = new Random();for (int pointIndex = 0; pointIndex 20000;pointIndex+)yValue = yValue + (random.NextDouble() * 10.0 - 5.0);Chart1.SeriesSeries1.Points.AddY(yValue);/ Set fast line chart typeChart1.SeriesSeries1.ChartType = SeriesChartType.FastLine; 日期，xy類型/ Create a new rand

8、om number generatorRandom rnd = new Random();/ Data points X value is using current dateDateTime date = DateTime.Now.Date;/ Add points to the stock chart seriesfor (int index = 0; index 10; index+)Chart1.SeriesSeries1.Points.AddXY(date,/ X value is a daternd.Next(40,50); /Close Y value/ Add 1 day to

9、 our X valuedate = date.AddDays(1);int-int的xy數(shù)據(jù)繪圖/ Create a new random number generatorRandom rnd = new Random();/ Add points to the stock chart seriesfor (int index = 0; index 10; index+)Chart1.SeriesSeries1.Points.AddXY(rnd.Next(10,90),/ X value is a daternd.Next(40,50); /Close Y value數(shù)據(jù)庫(kù)數(shù)據(jù)，dateti

10、me-int類型 Chart1.Series.Clear(); OleDbConnection conn = new OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + Application.StartupPath + db.mdb + ;Persist Security Info=False); OleDbCommand cmd = conn.CreateCommand(); conn.Open(); cmd.CommandText = select 時(shí)間,序號(hào) from pub_log_read order by

11、 序號(hào) asc; /DataSet ds = new DataSet(); /OleDbDataAdapter da = new OleDbDataAdapter(); /da.SelectCommand = cmd; /da.Fill(ds, tbscore); OleDbDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); Chart1.DataBindTable(dr, 時(shí)間); dr.Close();數(shù)據(jù)庫(kù)數(shù)據(jù)2，string-int類型 Chart1.Series.Clear(); OleDbConne

12、ction conn = new OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + Application.StartupPath + db.mdb + ;Persist Security Info=False); OleDbCommand cmd = conn.CreateCommand(); conn.Open(); cmd.CommandText = select 賬號(hào),count(賬號(hào)) as 次數(shù) from pub_log_read group by 賬號(hào) order by 賬號(hào) asc; /DataSet

13、 ds = new DataSet(); /OleDbDataAdapter da = new OleDbDataAdapter(); /da.SelectCommand = cmd; /da.Fill(ds, tbscore); OleDbDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); Chart1.DataBindTable(dr, 賬號(hào)); dr.Close();數(shù)據(jù)庫(kù)綁定3-string-int型 Chart1.Series.Clear(); Chart1.Series.Add(Series1);

14、OleDbConnection conn = new OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + Application.StartupPath + db.mdb + ;Persist Security Info=False); OleDbCommand cmd = conn.CreateCommand(); cmd.CommandText = select 賬號(hào),count(賬號(hào)) as 次數(shù) from pub_log_read group by 賬號(hào) order by 賬號(hào) asc; conn.Open()

15、; DataSet ds = new DataSet(); OleDbDataAdapter da = new OleDbDataAdapter(); da.SelectCommand = cmd; da.Fill(ds, tbscore); Chart1.DataSource = ds; Chart1.SeriesSeries1.XValueMember = 賬號(hào); Chart1.SeriesSeries1.YValueMembers = 次數(shù); / Data bind to the selected data source Chart1.DataBind(); conn.Close();數(shù)

16、據(jù)庫(kù)4，只綁定y Chart1.Series.Clear(); Chart1.Series.Add(序號(hào)); OleDbConnection conn = new OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + Application.StartupPath + db.mdb + ;Persist Security Info=False); OleDbCommand cmd = conn.CreateCommand(); conn.Open(); cmd.CommandText = select 序號(hào) from p

17、ub_log_read order by 序號(hào) asc; /DataSet ds = new DataSet(); /OleDbDataAdapter da = new OleDbDataAdapter(); /da.SelectCommand = cmd; /da.Fill(ds, tbscore); OleDbDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); Chart1.Series0.Points.DataBindY(dr); dr.Close();數(shù)據(jù)庫(kù)5，綁定xy Chart1.Series.Cl

18、ear(); Chart1.Series.Add(序號(hào)); OleDbConnection conn = new OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + Application.StartupPath + db.mdb + ;Persist Security Info=False); OleDbCommand cmd = conn.CreateCommand(); conn.Open(); cmd.CommandText = select 賬號(hào),count(賬號(hào)) as 次數(shù) from pub_log_re

19、ad group by 賬號(hào) order by 賬號(hào) desc; /DataSet ds = new DataSet(); /OleDbDataAdapter da = new OleDbDataAdapter(); /da.SelectCommand = cmd; /da.Fill(ds, tbscore); OleDbDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); Chart1.Series0.Points.DataBindXY(dr,賬號(hào),dr,次數(shù)); dr.Close();數(shù)據(jù)庫(kù)6，支持顯示參數(shù)

20、Chart1.Series.Clear(); Chart1.Series.Add(S1); OleDbConnection conn = new OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + Application.StartupPath + db.mdb + ;Persist Security Info=False); OleDbCommand cmd = conn.CreateCommand(); conn.Open(); cmd.CommandText = SELECT * FROM REPSALES WH

21、ERE Year=2004; /DataSet ds = new DataSet(); /OleDbDataAdapter da = new OleDbDataAdapter(); /da.SelectCommand = cmd; /da.Fill(ds, tbscore); OleDbDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); Chart1.Series0.Points.DataBind(dr, name, sales, Tooltip=Year, Label=CommissionsC2); dr.C

22、lose();數(shù)據(jù)庫(kù)7，支持多l(xiāng)ine Chart1.Series.Clear(); Chart1.Series.Add(S1); OleDbConnection conn = new OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + Application.StartupPath + db.mdb + ;Persist Security Info=False); OleDbCommand cmd = conn.CreateCommand(); conn.Open(); cmd.CommandText = SELEC

23、T * FROM REPSALES; /DataSet ds = new DataSet(); /OleDbDataAdapter da = new OleDbDataAdapter(); /da.SelectCommand = cmd; /da.Fill(ds, tbscore); OleDbDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); Chart1.DataBindCrossTable(dr, Name, Year, Sales, Label=CommissionsC); dr.Close();數(shù)據(jù)庫(kù)

24、8，按照行添加數(shù)據(jù)/ Resolve the address to the Access database stringfileNameString = this.MapPath(.);fileNameString += .datachartdata.mdb; /Initialize a connectionstring stringmyConnectionString = PROVIDER=Microsoft.Jet.OLEDB.4.0;DataSource= + fileNameString; / Definethe databasequery stringmySelectQuery=SE

25、LECT * FROM SALESCOUNTS; / Createa database connection object using the connectionstringOleDbConnection myConnection = newOleDbConnection(myConnectionString); / Create adatabase command on the connection usingquery OleDbCommandmyCommand = new OleDbCommand(mySelectQuery, myConnection); / Open theconn

26、ectionmyCommand.Connection.Open(); /Initializes a new instance of the OleDbDataAdapter classOleDbDataAdapter myDataAdapter = new OleDbDataAdapter();myDataAdapter.SelectCommand = myCommand; /Initializes a new instance of the DataSet class DataSetmyDataSet = new DataSet(); / Addsrows in the DataSetmyD

27、ataAdapter.Fill(myDataSet,Query);foreach(DataRow row in myDataSet.TablesQuery.Rows) / For each Row add a new seriesstring seriesName = rowSalesRep.ToString();Chart1.Series.Add(seriesName);Chart1.SeriesseriesName.ChartType = SeriesChartType.Line;Chart1.SeriesseriesName.BorderWidth = 2;for(int colInde

28、x = 1; colIndex myDataSet.TablesQuery.Columns.Count; colIndex+)/ For each column (column 1 and onward) add the value as apointstring columnName =myDataSet.TablesQuery.ColumnscolIndex.ColumnName;int YVal = (int) rowcolumnName;Chart1.SeriesseriesName.Points.AddXY(columnName, YVal); DataGrid.DataSource

29、 = myDataSet;DataGrid.DataBind(); / Closesthe connection to the data source. This is the preferred / method ofclosing any open connection.myCommand.Connection.Close();使用xml數(shù)據(jù)/ resolve the address to the XML document stringfileNameString = this.MapPath(.); stringfileNameSchema = this.MapPath(.);fileN

30、ameString += .datadata.xml;fileNameSchema += .datadata.xsd; /Initializes a new instance of the DataSet class DataSetcustDS = new DataSet(); / Read XMLschema into the DataSet.custDS.ReadXmlSchema( fileNameSchema ); / ReadXML schema and data into the DataSet.custDS.ReadXml( fileNameString ); /Initiali

31、zes a new instance of the DataView class DataViewfirstView = new DataView(custDS.Tables0); / Sincethe DataView implements and IEnumerable, pass the reader directlyinto / theDataBindTable method with the name of the column used for the Xvalue.Chart1.DataBindTable(firstView, Name);使用excel數(shù)據(jù)/ resolve t

32、he address to the Excel file stringfileNameString = this.MapPath(.);fileNameString += .dataExcelData.xls; / Createconnection object by using the preceding connection string. string sConn= Provider=Microsoft.Jet.OLEDB.4.0;Data Source= +fileNameString + ;Extended Properties=Excel8.0;HDR=YES;OleDbConne

33、ction myConnection = new OleDbConnection( sConn );myConnection.Open(); / Thecode to follow uses a SQL SELECT command to display the data fromthe worksheet. / Createnew OleDbCommand to return data from worksheet. OleDbCommandmyCommand = new OleDbCommand( Select * From data1$A1:E25,myConnection ); / c

34、reatea databasereaderOleDbDataReader myReader =myCommand.ExecuteReader(CommandBehavior.CloseConnection); /Populate the chart with data in the fileChart1.DataBindTable(myReader, HOUR); / closethe reader and the connectionmyReader.Close();myConnection.Close();使用csv數(shù)據(jù)/ Filename of the CSV file string f

35、ile= DataFile.csv; / Getthe path of the CSV file string path= this.MapPath(.); path +=.data; / Createa select statement and a connection string. stringmySelectQuery = Select * from + file; stringConStr = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=+path+ ;Extended Properties=Text;HDR=No;FMT=Delimit

36、ed;OleDbConnection myConnection = new OleDbConnection(ConStr); / Createa database command on the connection using query OleDbCommandmyCommand = new OleDbCommand(mySelectQuery, myConnection); / Openthe connection and create the readermyCommand.Connection.Open();OleDbDataReader myReader =myCommand.Exe

37、cuteReader(CommandBehavior.CloseConnection); / Column1 is a time value, column 2 is a double / Databindthe reader to the chart using the DataBindXY methodChart1.Series0.Points.DataBindXY(myReader, 1, myReader,2); / Closeconnection and data readermyReader.Close();myConnection.Close();數(shù)組繪圖/ Initialize

38、 an array of doublesdouble yval = 2, 6, 4, 5, 3 ;/ Initialize an array of stringsstring xval = Peter, Andrew, Julie, Mary, Dave ;/ Bind the double array to the Y axis points of the Default dataseriesChart1.SeriesSeries1.Points.DataBindXY(xval, yval);數(shù)據(jù)庫(kù)9，dataview/ Resolve the address to the Access d

39、atabase stringfileNameString = this.MapPath(.);fileNameString += .datachartdata.mdb; /Initialize a connectionstring stringmyConnectionString = PROVIDER=Microsoft.Jet.OLEDB.4.0;DataSource= + fileNameString; / Definethe databasequery stringmySelectQuery=SELECT * FROM REPS; / Createa database connectio

40、n object using the connectionstringOleDbConnection myConnection = newOleDbConnection(myConnectionString); / Create adatabase command on the connection usingquery OleDbCommandmyCommand = new OleDbCommand(mySelectQuery, myConnection); / Open theconnectionmyCommand.Connection.Open(); /Initializes a new

41、 instance of the OleDbDataAdapter classOleDbDataAdapter custDA = new OleDbDataAdapter();custDA.SelectCommand = myCommand; /Initializes a new instance of the DataSet class DataSetcustDS = new DataSet(); / Addsrows in the DataSetcustDA.Fill(custDS, Customers); /Initializes a new instance of the DataVi

42、ew class DataViewfirstView = new DataView(custDS.Tables0); / Sincethe DataView implements IEnumerable, pass the dataview directlyinto/ the DataBind method with thename of the Columns selected in thequeryChart1.SeriesDefault.Points.DataBindXY(firstView,Name,firstView, Sales); / Closesthe connection to the data source. This is the preferred/ method of closing any openconnection.myCommand.Connection.Close();指定坐標(biāo)軸的數(shù)據(jù)顯示范圍/ Create a new random number generatorRandom rnd = new Random();/ Add points