?? seecls.aspx.cs
字號:
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=HSJ;Initial Catalog=class;User ID=sa;Pwd=hsj;");
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:該調(diào)用是 ASP.NET Web 窗體設計器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內(nèi)容。
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -