Owc的使用---自己封装好的类可以实现14种分析图

 

一、图形类型列表

chChartTypeColumnClustered----------垂直柱状统计图
        chChartTypeColumn3D-----------------3D垂直柱状统计图
        chChartTypeBarClustered---------------水平柱状统计图
        chChartTypeBar3D--------------------- 3D水平柱状统计图
        chChartTypeArea----------------------- 区域统计图
        chChartTypeArea3D--------------------3D区域统计图
        chChartTypeDoughnut------------------ 中空饼图
        chChartTypeLineStacked--------------- 折线统计图
        chChartTypeLine3D---------------------3D折线统计图
        chChartTypeLineMarkers--------------- 折线带点统计图
        chChartTypePie------------------------- 饼图
        chChartTypePie3D----------------------3D饼图
        chChartTypeRadarSmoothLine----------网状统计图
        chChartTypeSmoothLine----------------弧线统计图  

二、dll下载

下载地址: OWCWebChart.rar

三、使用方法

1、 在引用中引用dll

2、  using OWCWebChart;

3、 使用:

WebChart wc = new WebChart();

string name;

name = wc.show(type,this,datatable,"AAAA题目AAAAA","类别","数量","销售图");

this.Image1.ImageUrl=@"images/"+name;

说明:type-------即图形类型,直接给英文字符串

     this-------即本页面

     datatable—中包含两列,第1列为类别,第2列为数量.例如1列为年,2列为销售额

     接下来的4个字符串参数分别是:大标题,类别,数量,和小标题

     name-------是图片名称;

     images------是Web应用程序下与本页面(this)同层的文件夹

4、 具体示例代码:

webconfig文件

<appSettings>

          <add key="Connstring" value="Data Source=(local);User ID=sa;Password=sa;Initial Catalog=pubs" />

</appSettings>

web页面:加入一个Image,将下列代码放在Page_Load中, 在引用中引用dll

加入namespace

using OWCWebChart;

using System.IO;

using System.Configuration;

using System.Data.SqlClient;

代码:

string sql = "SELECT " +"Year(sa.ord_date) As [Year], " +"SUM(sa.qty) As [Qty] " +"FROM " +"sales sa " +"inner join stores st on(sa.stor_id = st.stor_id) " +"GROUP BY " +"Year(sa.ord_date) " + "ORDER BY " + "[Year]";

          string conn = ConfigurationSettings.AppSettings.Get("Connstring");

              SqlDataAdapter da = new SqlDataAdapter(sql,conn);

              DataSet ds = new DataSet();

              da.Fill(ds,"chartData");

              WebChart wc = new WebChart();

              name = wc.show("chChartTypeColumnClustered",this,ds.Tables[0],"AAAAAAAA题目AAAAAAAA","类别","数量","销售图");

    this.Image1.ImageUrl=@"images/"+name;

5、 效果图

6、  注意:本dll仅能在Web项目中使用.本dll封装的是owc10

 原文地址: http://xh831213.cnblogs.com/archive/2006/05/16/401461.html
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
使用OFFICE自带的OWC11制作而成,集成了绘制常用统计方法。<br>chChartTypeArea 29 <br>chChartTypeArea3D 60 <br>chChartTypeAreaOverlapped3D 61 <br>chChartTypeAreaStacked 30 <br>chChartTypeAreaStacked100 31 <br>chChartTypeAreaStacked1003D 63 <br>chChartTypeAreaStacked3D 62 <br>chChartTypeBar3D 50 <br>chChartTypeBarClustered 3 <br>chChartTypeBarClustered3D 51 <br>chChartTypeBarStacked 4 <br>chChartTypeBarStacked100 5 <br>chChartTypeBarStacked1003D 53 <br>chChartTypeBarStacked3D 52 <br>chChartTypeBubble 27 <br>chChartTypeBubbleLine 28 <br>chChartTypeColumn3D 46 <br>chChartTypeColumnClustered 0 <br>chChartTypeColumnClustered3D 47 <br>chChartTypeColumnStacked 1 <br>chChartTypeColumnStacked100 2 <br>chChartTypeColumnStacked1003D 49 <br>chChartTypeColumnStacked3D 48 <br>chChartTypeCombo -1 <br>chChartTypeCombo3D -2 <br>chChartTypeDoughnut 32 <br>chChartTypeDoughnutExploded 33 <br>chChartTypeLine 6 <br>chChartTypeLine3D 54 <br>chChartTypeLineMarkers 7 <br>chChartTypeLineOverlapped3D 55 <br>chChartTypeLineStacked 8 <br>chChartTypeLineStacked100 10 <br>chChartTypeLineStacked1003D 57 <br>chChartTypeLineStacked100Markers 11 <br>chChartTypeLineStacked3D 56 <br>chChartTypeLineStackedMarkers 9 <br>chChartTypePie 18 <br>chChartTypePie3D 58 <br>chChartTypePieExploded 19 <br>chChartTypePieExploded3D 59 <br>chChartTypePieStacked 20 <br>chChartTypePolarLine 42 <br>chChartTypePolarLineMarkers 43 <br>chChartTypePolarMarkers 41 <br>chChartTypePolarSmoothLine 44 <br>chChartTypePolarSmoothLineMarkers 45 <br>chChartTypeRadarLine 34 <br>chChartTypeRadarLineFilled 36 <br>chChartTypeRadarLineMarkers 35 <br>chChartTypeRadarSmoothLine 37 <br>chChartTypeRadarSmoothLineMarkers 38 <br>chChartTypeScatterLine 25 <br>chChartTypeScatterLineFilled 26 <br>chChartTypeScatterLineMarkers 24 <br>chChartTypeScatterMarkers 21 <br>chChartTypeScatterSmoothLine 23 <br>chChartTypeScatterSmoothLineMarkers 22 <br>chChartTypeSmoothLine 12 <br>chChartTypeSmoothLineMarkers 13 <br>chChartTypeSmoothLineStacked 14 <br>chChartTypeSmoothLineStacked100 16 <br>chChartTypeSmoothLineStacked100Markers 17 <br>chChartTypeSmoothLineStackedMarkers 15 <br>chChartTypeStockHLC 39 <br>chChartTypeStockOHLC 40 <br>这六十来个型,大部已经集成到OwcChart.dll里了。<br>

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值