using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;
using?System.Diagnostics;??//??任務管理程序處理引用

namespace?studentsystem
{
????public?partial?class?AcademicStatus?:?Form
????{
????????private?SqlConnection?myconn;
????????public?AcademicStatus（）
????????{
????????????myconn?=?new?SqlConnection（studentsystem.database.Sqlconnection.connection）;
????????????InitializeComponent（）;
????????}

????????private?void?scno_TextChanged（object?sender?EventArgs?e）
????????{
????????????myconn.Open（）;
????????????SqlCommand?cmd?=?new?SqlCommand（““myconn）;
????????????string?sql=“select?*?from?student“;
????????????cmd.CommandText?=?sql;??????????
????????????
????????????if?（null!=cmd.ExecuteScalar（））
????????????{
????????????????sql?=?“select?SUM（所得學分）from?year1?where?學號=‘“?+?scno.Text.Trim（）?+?“‘group?by?學號“;
????????????????cmd.CommandText?=?sql;
????????????????if?（null!=cmd.ExecuteScalar（））
????????????????{
????????????????????grade1.Text?=?cmd.ExecuteScalar（）.ToString（）+“??分“;
????????????????}
????????????????else?grade1.Text?=?“0???分“;

????????????????sql?=?“select?SUM（所得學分）from?year2?where?學號=‘“?+?scno.Text.Trim（）?+?“‘group?by?學號“;
????????????????cmd.CommandText?=?sql;
????????????????if?（null?!=?cmd.ExecuteScalar（））
????????????????{
????????????????????grade2.Text?=?cmd.ExecuteScalar（）.ToString（）?+?“??分“;
????????????????}
????????????????else?grade2.Text?=?“0???分“;

????????????????sql?=?“select?SUM（所得學分）from?year3?where?學號=‘“?+?scno.Text.Trim（）?+?“‘group?by?學號“;
????????????????cmd.CommandText?=?sql;
????????????????if?（null?!=?cmd.ExecuteScalar（））
????????????????{
????????????????????grade3.Text?=?cmd.ExecuteScalar（）.ToString（）?+?“??分“;
????????????????}
????????????????else?grade3.Text?=?“0???分“;

????????????????sql?=?“select?SUM（所得學分）from?year4?where?學號=‘“?+?scno.Text.Trim（）?+?“‘group?by?學號“;
????????????????cmd.CommandText?=?sql;
????????????????if?（null?!=?cmd.ExecuteScalar（））
????????????????{
????????????????????grade4.Text?=?cmd.ExecuteScalar（）.ToString（）?+?“??分“;
????????????????}
????????????????else?grade4.Text?=?“0???分“;

????????????????string?s=null;
????????????????sql?=?“select?姓名?from?grade?where?學號=‘“?+?scno.Text.Trim（）?+?“‘“;
????????????????cmd.CommandText?=?sql;
????????????????if?（null?!=?cmd.ExecuteScalar（））
????????????????{
????????????????????s?=?“姓名：?“?+?cmd.ExecuteScalar（）.ToString（）?+?“????????“;
????????????????}???????????????

????????????????sql?=?“select?SUM（所得學分）from?grade?where?學號=‘“?+?scno.Text.Trim（）?+?“‘group?by?學號“;
????????????????cmd.CommandText?=?sql;
????????????????if?（null?!=?cmd.ExecuteScalar（））
????????????????{
????????????????????
????????????????????cmd.CommandText?=?sql;
????????????????????string?bs?=?cmd.ExecuteScalar（）.ToString（）;
????????????????????in

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????5039??2010-01-11?21:38??數據庫課程設計\studentsystem\studentsystem\AcademicStatus.cs

?????文件???????8418??2010-01-11?21:15??數據庫課程設計\studentsystem\studentsystem\AcademicStatus.Designer.cs

?????文件???????5814??2010-01-11?21:15??數據庫課程設計\studentsystem\studentsystem\AcademicStatus.resx

?????文件???????2314??2010-01-10?03:01??數據庫課程設計\studentsystem\studentsystem\AddClass.cs

?????文件???????6333??2010-01-10?03:01??數據庫課程設計\studentsystem\studentsystem\AddClass.Designer.cs

?????文件???????5814??2010-01-10?03:01??數據庫課程設計\studentsystem\studentsystem\AddClass.resx

?????文件???????2099??2010-01-11?09:57??數據庫課程設計\studentsystem\studentsystem\AddCourse.cs

?????文件???????8013??2010-01-11?09:43??數據庫課程設計\studentsystem\studentsystem\AddCourse.Designer.cs

?????文件???????5814??2010-01-11?09:43??數據庫課程設計\studentsystem\studentsystem\AddCourse.resx

?????文件???????2517??2010-01-11?09:25??數據庫課程設計\studentsystem\studentsystem\AddCS.cs

?????文件???????8324??2010-01-11?09:23??數據庫課程設計\studentsystem\studentsystem\AddCS.Designer.cs

?????文件???????5814??2010-01-11?09:23??數據庫課程設計\studentsystem\studentsystem\AddCS.resx

?????文件???????2629??2010-01-13?02:48??數據庫課程設計\studentsystem\studentsystem\AddGrade.cs

?????文件???????8167??2010-01-11?09:36??數據庫課程設計\studentsystem\studentsystem\AddGrade.Designer.cs

?????文件???????5814??2010-01-11?09:36??數據庫課程設計\studentsystem\studentsystem\AddGrade.resx

?????文件???????2535??2010-01-09?22:09??數據庫課程設計\studentsystem\studentsystem\AddMajor.cs

?????文件???????8289??2010-01-09?15:55??數據庫課程設計\studentsystem\studentsystem\AddMajor.Designer.cs

?????文件???????5814??2010-01-09?15:55??數據庫課程設計\studentsystem\studentsystem\AddMajor.resx

?????文件???????1981??2010-01-09?15:17??數據庫課程設計\studentsystem\studentsystem\AddRoles.cs

?????文件???????7847??2010-01-08?19:42??數據庫課程設計\studentsystem\studentsystem\AddRoles.Designer.cs

?????文件???????5814??2010-01-08?19:37??數據庫課程設計\studentsystem\studentsystem\AddRoles.resx

?????文件???????2011??2010-01-10?20:59??數據庫課程設計\studentsystem\studentsystem\AddSchools.cs

?????文件???????6522??2010-01-09?11:19??數據庫課程設計\studentsystem\studentsystem\AddSchools.Designer.cs

?????文件???????5814??2010-01-09?11:19??數據庫課程設計\studentsystem\studentsystem\AddSchools.resx

?????文件???????3562??2010-01-09?02:07??數據庫課程設計\studentsystem\studentsystem\AddUser.cs

?????文件??????10289??2010-01-09?02:07??數據庫課程設計\studentsystem\studentsystem\AddUser.Designer.cs

?????文件???????5814??2010-01-09?02:07??數據庫課程設計\studentsystem\studentsystem\AddUser.resx

?????文件???????1092??2010-01-12?20:34??數據庫課程設計\studentsystem\studentsystem\app.config

?????文件?????321752??2010-01-12?20:34??數據庫課程設計\studentsystem\studentsystem\bin\Debug\app.publish\Application?Files\studentsystem_1_0_0_1\iTunes4.ico.deploy

?????文件???????1092??2010-01-12?20:34??數據庫課程設計\studentsystem\studentsystem\bin\Debug\app.publish\Application?Files\studentsystem_1_0_0_1\studentsystem.exe.config.deploy

............此處省略290個文件信息