analysis.aspx.cs

在线考试系统： 1、为了保证示例代码正确运行

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Configuration;
using System.Data.SqlClient;
using Dundas.Charting.WebControl;

namespace TestOnline
{
	/// <summary>
	/// Analysis 的摘要说明。
	/// </summary>
	public class Analysis : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.DropDownList dplpapername;
		protected Dundas.Charting.WebControl.Chart chtscore;
	    private DataSet DataSetScore = new DataSet("StuScore");
		private string[] Xvalue=new string[] {"60以下","60-70","70-85","85以上"};
		private int[] Yvalue=new int[] {1,2,5,3};
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (!IsPostBack) 
			{
				Bind_PaperName();
			}
               
		}
		void Bind_PaperName()
		{
			//创建数据库连接对象
			SqlConnection objconn = new SqlConnection(ConfigurationSettings.AppSettings["connstr"]);
			objconn.Open();
			String objsql   = "Select PaperName from Papers";
			SqlDataAdapter da = new SqlDataAdapter(objsql, objconn);
			//创建并填充DataSet
			DataSet ds = new DataSet();
			da.Fill(ds, "Papers");
			dplpapername.DataSource = ds;
			dplpapername.DataMember = "Papers";
			dplpapername.DataTextField = "PaperName";
			dplpapername.DataBind();
			objconn.Close();
		}
		void Yvalue_Caculate()
		{
			SqlConnection objconn = new SqlConnection(ConfigurationSettings.AppSettings["connstr"]);
			string selectStr  = "select * from Scores where PaperName='" + dplpapername.SelectedValue.ToString() + "'";
			SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter(selectStr, objconn);
			DataSetScore.Clear();
			sqlDataAdapter1.Fill(DataSetScore, "StuScore");
			int total   = DataSetScore.Tables[0].Rows.Count;
			Label1.Text = total.ToString();
			for(int i=0;i<4;i++)
				Yvalue[i]=0;
			for(int i=0;i<total;i++)
			{
				double score=Convert.ToDouble(this.DataSetScore.Tables[0].Rows[i]["StuScore"]);
				if(score<60)Yvalue[0]++;
				if((60<=score)&(score<70))Yvalue[1]++;
				if((70<=score)&(score<85))Yvalue[2]++;
				if(85<=score)Yvalue[3]++;			
				
			}
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.dplpapername.SelectedIndexChanged += new System.EventHandler(this.dplpapername_SelectedIndexChanged);
			this.Button1.Click += new System.EventHandler(this.Button1_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void Button1_Click(object sender, System.EventArgs e)
		{
			Series series  = chtscore.Series.Add("Grade");
			series.ChartArea = "Default";
            
			series.ChartType = "Line";
			series.BorderWidth = 2;
			series.ShowLabelAsValue = true;
			series.MarkerStyle = MarkerStyle.Square;
			series.MarkerSize = 7;
			series.MarkerColor = Color.Red;
			series.Color = Color.Red;
            
			Yvalue_Caculate();
			chtscore.Series["Grade"].Points.DataBindXY(Xvalue, Yvalue);
		}

		private void dplpapername_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}
	}
}