想做一个统计图表,在论坛里搜了好久,可是不知道源码在哪里,谁能提供呀?先谢谢了

解决方案 »

  1.   

    OWC图表(C#)
    OWC.ChartSpace owcChartSpace=new OWC.ChartSpace();
    OWC.WCChart owcChart=owcChartSpace.Charts.Add(0);
    ADODB.Connection ConnADO = new ADODB.Connection();
    ADODB.Recordset RecordsetADO = new ADODB.Recordset();
    string connectionString = "Provider=MSDataShape;Data Provider=SQLOLEDB;uid=OAM;pwd=OAM;Data Source=bqsnet;initial catalog=oam";
    ConnADO.Open(connectionString,"OAM","OAM",-1);
    RecordsetADO.ActiveConnection = ConnADO;
    RecordsetADO.CursorType = ADODB.CursorTypeEnum.adOpenStatic;
    RecordsetADO.CursorLocation = ADODB.CursorLocationEnum.adUseClient;
    string strSQL = "select * from student order by student";
    RecordsetADO.Open(strSQL,ConnADO,ADODB.CursorTypeEnum.adOpenStatic,ADODB.LockTypeEnum.adLockReadOnly,0);
    owcChartSpace.DataSource=(msdatasrc.DataSource)RecordsetADO;
    owcChart.Type=OWC.ChartChartTypeEnum.chChartTypeColumnClustered; //柱状
    // owcChart.Type = OWC.ChartChartTypeEnum.chChartTypeSmoothLineMarkers;  //线状
    owcChart.SetData(OWC.ChartDimensionsEnum.chDimSeriesNames,0,"student");
    foreach (OWC.WCSeries owcSeries in owcChart.SeriesCollection)
    {
    owcSeries.SetData(OWC.ChartDimensionsEnum.chDimCategories,0,"test");  //X轴
    owcSeries.SetData(OWC.ChartDimensionsEnum.chDimValues,0,"score");  //Y轴
    }
    foreach (OWC.WCAxis axis in owcChart.Axes)
    {   //说明表示意义
    owcChart.HasLegend=true;
    owcChart.Legend.Position=OWC.ChartLegendPositionEnum.chLegendPositionBottom;
    // owcChart.Legend.Font.Size=15;
    //标题
    owcChart.HasTitle=true;
    owcChart.Title.Caption="学生成绩表";
    //X,Y轴意义
    axis.HasTitle=true;
    if (axis.Type==ChartAxisTypeEnum.chCategoryAxis)
    {
    axis.Title.Caption="test";
    }
    else
    {
    axis.Title.Caption="score";
    }
    }
    // owcChart.SeriesCollection[1].Interior.Color="red";  //改变颜色
    // owcChart.SeriesCollection[1].Line.Color="red";  //改变颜色
    Random rd=new Random();
    int nfilenameSuffix;
    string sfilenamesuffix;
    nfilenameSuffix = 100000 * rd.Next();
    sfilenamesuffix = Convert.ToString(nfilenameSuffix);
    owcChartSpace.ExportPicture(MapPath("../Report/") + sfilenamesuffix + ".gif", "gif", 800, 600);
    Image1.ImageUrl = "../Report/" + sfilenamesuffix + ".gif";
    在项目引用中加入com中的microsoft office web component9.0组件且引用using OWC
      

  2.   

    http://www.cnblogs.com/edobnet/archive/2004/06/07/13999.aspx