c#-mschart-简单例子.doc

c# mschart 简单例子2010-04-16 18:43:14|分类： 控件 |标签： |字号大中小订阅 第一个简单的chart： spline/ Create new data series and set its visual attributes 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); 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);同时显示2条曲线/ Populate series with random data Random random = new Random(); for (int pointIndex = 0; pointIndex 10; pointIndex+) Chart1.SeriesSeries1.Points.AddY(random.Next(45, 95); Chart1.SeriesSeries2.Points.AddY(random.Next(5, 75); / Set series chart type Chart1.SeriesSeries1.ChartType = SeriesChartType.Line; Chart1.SeriesSeries2.ChartType = SeriesChartType.Spline; / Set point labels Chart1.SeriesSeries1.IsValueShownAsLabel = true; Chart1.SeriesSeries2.IsValueShownAsLabel = true; / Enable X axis margin Chart1.ChartAreasChartArea1.AxisX.IsMarginVisible = true; / Enable 3D, and show data point marker lines Chart1.ChartAreasChartArea1.Area3DStyle.Enable3D = true; Chart1.SeriesSeries1ShowMarkerLines = True; Chart1.SeriesSeries2ShowMarkerLines = True;显示column类型图/ Create new data series and set its visual attributes Series series = new Series(FlowRead); series.ChartType = SeriesChartType.Column; series.BorderWidth = 3; series.ShadowOffset = 2; / Populate new series with data series.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 collection Chart1.Series.Add(series);很多点，效率还可以/ Fill series data double yValue = 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 type Chart1.SeriesSeries1.ChartType = SeriesChartType.FastLine; 日期，xy类型/ Create a new random number generator Random rnd = new Random(); / Data points X value is using current date DateTime date = DateTime.Now.Date; / Add points to the stock chart series for (int index = 0; index 10; index+) Chart1.SeriesSeries1.Points.AddXY( date, / X value is a date rnd.Next(40, 50); / Close Y value / Add 1 day to our X value date = date.AddDays(1); int-int的xy数据绘图/ Create a new random number generator Random rnd = new Random(); / Add points to the stock chart series for (int index = 0; index 10; index+) Chart1.SeriesSeries1.Points.AddXY( rnd.Next(10, 90), / X value is a date rnd.Next(40, 50); / Close Y value 数据库数据，datetime-int类型string connStr = server=localhost;database=seis_project;uid=seisprjs;pwd=seisprjs; SqlConnection myConn = new SqlConnection(connStr); string selStr = select 时间,序号 from pub_log_read order by 序号 asc; SqlCommand myCmd = myConn.CreateCommand(); myCmd.CommandText = selStr; myConn.Open(); SqlDataReader sdr = myCmd.ExecuteReader(CommandBehavior.CloseConnection); / Since the reader implements and IEnumerable, pass the reader directly into / the DataBindTable method with the name of the Column to be used as the XValue Chart1.DataBindTable(sdr, 时间); sdr.Close(); myConn.Close();数据库数据2，string-int类型string connStr = server=localhost;database=seis_project;uid=seisprjs;pwd=seisprjs; SqlConnection myConn = new SqlConnection(connStr); string selStr = select 帐号,count(帐号) as 次数 from pub_log_read group by 帐号 order by 帐号 asc; SqlCommand myCmd = myConn.CreateCommand(); myCmd.CommandText = selStr; myConn.Open(); SqlDataReader sdr = myCmd.ExecuteReader(CommandBehavior.CloseConnection); / Since the reader implements and IEnumerable, pass the reader directly into / the DataBindTable method with the name of the Column to be used as the XValue Chart1.DataBindTable(sdr, 帐号); sdr.Close(); myConn.Close();数据库绑定3-error？string connStr = server=localhost;database=seis_project;uid=seisprjs;pwd=seisprjs; SqlConnection myConn = new SqlConnection(connStr); string selStr = select 帐号,count(帐号) as 次数 from pub_log_read group by 帐号 order by 帐号 asc; SqlCommand myCmd = myConn.CreateCommand(); myCmd.CommandText = selStr; myConn.Open(); / Set chart data source Chart1.DataSource = myCmd; / Set series members names for the X and Y values Chart1.SeriesSeries1.XValueMember = 帐号; Chart1.SeriesSeries1.YValueMembers = 次数; / Data bind to the selected data source Chart1.DataBind(); myConn.Close();数据库4，只绑定ystring connStr = server=localhost;database=seis_project;uid=seisprjs;pwd=seisprjs; SqlConnection myConn = new SqlConnection(connStr); string selStr = select 序号 from pub_log_read order by 序号 asc; SqlCommand myCmd = myConn.CreateCommand(); myCmd.CommandText = selStr; myConn.Open(); SqlDataReader sdr = myCmd.ExecuteReader(CommandBehavior.CloseConnection); / Since the reader implements and IEnumerable, pass the reader directly into / the DataBindTable method with the name of the Column to be used as the XValue Chart1.Series0.Points.DataBindY(sdr); sdr.Close(); myConn.Close();数据库5，绑定xystring connStr = server=localhost;database=seis_project;uid=seisprjs;pwd=seisprjs; SqlConnection myConn = new SqlConnection(connStr); string selStr = select 帐号,count(帐号) as 次数 from pub_log_read group by 帐号 order by 帐号 desc; SqlCommand myCmd = myConn.CreateCommand(); myCmd.CommandText = selStr; myConn.Open(); SqlDataReader sdr = myCmd.ExecuteReader(CommandBehavior.CloseConnection); / Since the reader implements and IEnumerable, pass the reader directly into / the DataBindTable method with the name of the Column to be used as the XValue Chart1.Series0.Points.DataBindXY(sdr, 帐号,sdr,次数); sdr.Close(); myConn.Close();数据库6，支持显示参数/ Resolve the address to the Access database string fileNameString = this.MapPath(.); fileNameString += .datachartdata.mdb; / Initialize a connection string string myConnectionString = PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source= + fileNameString; / Define the database query string mySelectQuery=SELECT * FROM REPSALES WHERE Year=2004; / Create a database connection object using the connection string OleDbConnection myConnection = new OleDbConnection(myConnectionString); / Create a database command on the connection using query OleDbCommand myCommand = new OleDbCommand(mySelectQuery, myConnection); / Open the connection myCommand.Connection.Open(); / Create a database reader OleDbDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection); / Since the reader implements and IEnumerable, pass the reader directly into / the DataBind method with the name of the Columns assigned to the appropriate property Chart1.SeriesSeries1.Points.DataBind( myReader, Name, Sales, Tooltip=Year, Label=CommissionsC2); / Close the reader and the connection myReader.Close(); myConnection.Close();数据库7，支持多line/ Resolve the address to the Access database string fileNameString = this.MapPath(.); fileNameString += .datachartdata.mdb; / Initialize a connection string string myConnectionString = PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source= + fileNameString; / Define the database query string mySelectQuery=SELECT * FROM REPSALES; / Create a database connection object using the connection string OleDbConnection myConnection = new OleDbConnection(myConnectionString); / Create a database command on the connection using query OleDbCommand myCommand = new OleDbCommand(mySelectQuery, myConnection); / Open the connection myCommand.Connection.Open(); / Create a database reader OleDbDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection); / Data bind chart to a table where all rows are grouped in series by the Name column Chart1.DataBindCrossTable( myReader, Name, Year, Sales, Label=CommissionsC); / Close the reader and the connection myReader.Close(); myConnection.Close();数据库8，按照行添加数据/ Resolve the address to the Access database string fileNameString = this.MapPath(.); fileNameString += .datachartdata.mdb; / Initialize a connection string string myConnectionString = PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source= + fileNameString; / Define the database query string mySelectQuery=SELECT * FROM SALESCOUNTS; / Create a database connection object using the connection string OleDbConnection myConnection = new OleDbConnection(myConnectionString); / Create a database command on the connection using query OleDbCommand myCommand = new OleDbCommand(mySelectQuery, myConnection); / Open the connection myCommand.Connection.Open(); / Initializes a new instance of the OleDbDataAdapter class OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(); myDataAdapter.SelectCommand = myCommand; / Initializes a new instance of the DataSet class DataSet myDataSet = new DataSet(); / Adds rows in the DataSet myDataAdapter.Fill(myDataSet, Query); foreach(DataRow row in myDataSet.TablesQuery.Rows) / For each Row add a new series string seriesName = rowSalesRep.ToString(); Chart1.Series.Add(seriesName); Chart1.SeriesseriesName.ChartType = SeriesChartType.Line; Chart1.SeriesseriesName.BorderWidth = 2; for(int colIndex = 1; colIndex myDataSet.TablesQuery.Columns.Count; colIndex+) / For each column (column 1 and onward) add the value as a point string columnName = myDataSet.TablesQuery.ColumnscolIndex.ColumnName; int YVal = (int) rowcolumnName; Chart1.SeriesseriesName.Points.AddXY(columnName, YVal); DataGrid.DataSource = myDataSet; DataGrid.DataBind(); / Closes the connection to the data source. This is the preferred / method of closing any open connection. myCommand.Connection.Close();使用xml数据/ resolve the address to the XML document string fileNameString = this.MapPath(.); string fileNameSchema = this.MapPath(.); fileNameString += .datadata.xml; fileNameSchema += .datadata.xsd; / Initializes a new instance of the DataSet class DataSet custDS = new DataSet(); / Read XML schema into the DataSet. custDS.ReadXmlSchema( fileNameSchema ); / Read XML schema and data into the DataSet. custDS.ReadXml( fileNameString ); / Initializes a new instance of the DataView class DataView firstView = new DataView(custDS.Tables0); / Since the DataView implements and IEnumerable, pass the reader directly into / the DataBindTable method with the name of the column used for the X value. Chart1.DataBindTable(firstView, Name);使用excel数据/ resolve the address to the Excel file string fileNameString = this.MapPath(.); fileNameString += .dataExcelData.xls; / Create connection object by using the preceding connection string. string sConn = Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + fileNameString + ;Extended Properties=Excel 8.0;HDR=YES; OleDbConnection myConnection = new OleDbConnection( sConn ); myConnection.Open(); / The code to follow uses a SQL SELECT command to display the data from the worksheet. / Create new OleDbCommand to return data from worksheet. OleDbCommand myCommand = new OleDbCommand( Select * From data1$A1:E25, myConnection ); / create a database reader OleDbDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection); / Populate the chart with data in the file Chart1.DataBindTable(myReader, HOUR); / close the reader and the connection myReader.Close(); myConnection.Close();使用csv数据/ Filename of the CSV file string file = DataFile.csv; / Get the path of the CSV file string path = this.MapPath(.); path += .data; / Create a select statement and a connection string. string mySelectQuery = Select * from + file; string ConStr = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=+ path+ ;Extended Properties=Text;HDR=No;FMT=Delimited; OleDbConnection myConnection = new OleDbConnection(ConStr); / Create a database command on the connection using query OleDbCommand myCommand = new OleDbCommand(mySelectQuery, myConnection); / Open the connection and create the reader myCommand.Connection.Open(); OleDbDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection); / Column 1 is a time value, column 2 is a double / Databind the reader to the chart using the DataBindXY method Chart1.Series0.Points.DataBindXY(myReader, 1, myReader, 2); / Close connection and data reader myReader.Close(); myConnection.Close();数组绘图/ Initialize an array of doubles double yval = 2, 6, 4, 5, 3 ; / Initialize an array of strings string xval = Peter, Andrew, Julie, Mary, Dave ; / Bind the double array to the Y axis points of the Default data series Chart1.SeriesSeries1.Points.DataBindXY(xval, yval);数据库9，dataview/ Resolve the address to the Access database string fileNameString = this.MapPath(.); fileNameString += .datachartdata.mdb; / Initialize a connection string string myConnectionString = PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source= + fileNameString; / Define the database query string mySelectQuery=SELECT * FROM REPS; / Create a database connection object using the connection string OleDbConnection myConnection = new OleDbConnection(myConnectionString); / Create a databas