using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient ;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace class_kinghome
{
	/// <summary>
	/// seecls 的摘要說明。
	/// </summary>
	public class seecls : System.Web.UI.Page
	{
		public string getsno;
		public string getsname;
		protected System.Web.UI.WebControls.DataGrid mycs;
		public string getsdept;
		public string countcredit;
		public string fee;
	
		private void Page_Load(object sender, System.EventArgs e)
		{   getsno=Request["sno"];
			SqlConnection Con = new SqlConnection("Data Source=(local);Initial Catalog=class;User ID=sa;Pwd=sasasa;");  
			string sel="select * from stu where sno='"+getsno+"'";
			SqlCommand addCommand =new SqlCommand(sel,Con);
			addCommand.Connection.Open();
			SqlDataReader selreader ;
			selreader=addCommand.ExecuteReader();
			if (selreader.Read()==true)
			{
					getsname=selreader.GetString(1);
				getsdept=selreader.GetString(2);
			}
			addCommand.Connection.Close();
			sel="select sum(ccredit) from csee ,sco where csee.cno=sco.cno and sco.sno='"+getsno+"'";
			addCommand =new SqlCommand(sel,Con);
			addCommand.Connection.Open();
			selreader=addCommand.ExecuteReader();
			int a;
			if (selreader.Read()==true)
			{
				countcredit=selreader.GetValue(0).ToString();
				a=Int32.Parse(countcredit)*50;
				fee=a.ToString();
			}
			addCommand.Connection.Close();
			sel="select tea.tname, csee.cname,csee.cno,csee.cmon,csee.ctur,csee.cwen,csee.csat,csee.cfri,csee.cadr,csee.ccredit,sco.ckind from csee,tea,sco where  sco.cno=csee.cno and csee.tno=tea.tno and sco.sno='"+getsno+"'";
			SqlDataAdapter Cmd=new SqlDataAdapter(sel,Con);
		DataSet	ds=new DataSet();
			Cmd.Fill(ds,"csee");
           
		mycs.DataSource=ds.Tables["csee"].DefaultView;
			mycs.DataBind();
		}
		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：該調用是 ASP.NET Web 窗體設計器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
		/// 此方法的內容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
	}
}