asp.net代码生成柱状图和饼图

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.Office.Interop.Owc11;
using System.Data.SqlClient;

public partial class ClusterChart : System.Web.UI.Page
{
       protected void Page_Load(object sender, EventArgs e)
       {
           for (int i = 2000; i < 2050; i++)
           {
               this.DropDownList1.Items.Add(i.ToString());
           }

       }
       protected void CreateUserWizard1_CreatedUser(object sender, EventArgs e)
       {

       }
       protected void AnYear_Click(object sender, EventArgs e)
       {
           this.ClustChart();
       }
       //生成柱状图．
       public void ClustChart()
       {
           int strDrop = int.Parse(DropDownList1.SelectedValue.ToString());

           string strCon = "Server=.;Database=Test;Uid=sa;Pwd=ok";
           SqlConnection Con = new SqlConnection(strCon);
           string sqlStr = "select Month, sum(SFDJ_Price) as Price from Test a where Year = " + strDrop + " GROUP BY Month ";

           SqlDataAdapter sqlDA = new SqlDataAdapter(sqlStr, Con);
           DataSet ds = new DataSet();
           sqlDA.Fill(ds);
           Label1.Text = Con.State.ToString();
           this.DataGrid1.DataSource = ds;
           this.DataGrid1.DataBind();
           Con.Close();

           this.Image2.Visible = false;
           this.Image1.Visible = true;
           int[] Month = new int[12] { 1, 2, 3, 4, 5, 6, 7, 8, 9

凌众科技专业提供服务器租用、服务器托管、企业邮局、虚拟主机等服务，公司网站：http://www.lingzhong.cn 为了给广大客户了解更多的技术信息，本技术文章收集来源于网络,凌众科技尊重文章作者的版权，如果有涉及你的版权有必要删除你的文章，请和我们联系。以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢!