学生管理系统文档(共62页)

1、PAGE PAGE 65学生(xu sheng)管理系统项目(xingm)计划：对我系学生信息管理（包括学生基本信息，学生成绩的综合管理）。数据库1、创建(chungjin)数据库Student_Management_System：CREATE DATABASE Student_Management_SystemGO2、（1）创建UserAuthentication表：USE Student_Management_SystemCREATE TABLE dbo.UserAuthentication(Useraccount nvarchar (64) COLLATE Chinese_PRC_CI_

2、AS NOT NULL ,Password nvarchar (64) COLLATE Chinese_PRC_CI_AS NOT NULL ,)GO（主键为Useraccount）（2）向UserAuthentication表插入数据：USE Student_Management_SystemINSERT INTO UserAuthentication VALUES(辅导员,123456)INSERT INTO UserAuthentication VALUES(教学干事,123456)GO（3）UserAuthentication表：3、（1）创建AllStudents表：USE Stud

3、ent_Management_SystemCREATE TABLE dbo.AllStudents (studentNO nvarchar (11) COLLATE Chinese_PRC_CI_AS NOT NULL ,studnetName nvarchar (32) COLLATE Chinese_PRC_CI_AS NOT NULL ,Grade int NOT NULL ,Speciality nvarchar (64) COLLATE Chinese_PRC_CI_AS NULL ,ID nvarchar (18) COLLATE Chinese_PRC_CI_AS NOT NUL

4、L ,AdmissionTime datetime NOT NULL ,Sex nvarchar (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,Nationality nvarchar (64) COLLATE Chinese_PRC_CI_AS NOT NULL ,Politication nvarchar (32) COLLATE Chinese_PRC_CI_AS NULL ,RoomNo nvarchar (16) COLLATE Chinese_PRC_CI_AS NOT NULL ,RoomTelephone nvarchar (16) COLLA

5、TE Chinese_PRC_CI_AS NULL ,Mobile nvarchar (16) COLLATE Chinese_PRC_CI_AS NULL ,Address nvarchar (256) COLLATE Chinese_PRC_CI_AS NULL ,Postal nvarchar (8) COLLATE Chinese_PRC_CI_AS NULL ,Parents nvarchar (64) COLLATE Chinese_PRC_CI_AS NULL ,ParentsPhone nvarchar (32) COLLATE Chinese_PRC_CI_AS NULL ,

6、ParentsWork nvarchar (256) COLLATE Chinese_PRC_CI_AS NULL ,QQ nvarchar (16) COLLATE Chinese_PRC_CI_AS NULL ,Email nvarchar (128) COLLATE Chinese_PRC_CI_AS NULL ,) GO（主键为studentNO）（2）向AllStudents表插入(ch r)数据：USE Student_Management_SystemINSERT INTO AllStudents VALUES(20062122001,陆一,2006,计算机科学与技术(jsh),

7、0000001,2006-09-01,男,汉族,团员,1-42615198855423,云南省昆明市滇池(din ch)学院,066501,陆釴教师,00000000,00000000)INSERT INTO AllStudents VALUES(20072122002,马二,2007,计算机科学与技术,0000002,2007-09-01,女,彝族,党员,2-33315198850236,云南省昆明市滇池学院,066502,马杨警察,11111111,11111111)INSERT

8、 INTO AllStudents VALUES(20082122003,张三(zhn sn),2008,计算机科学与技术,0000003,2008-09-01,男,苗族,团员,1-43615198852365,云南省昆明市滇池(din ch)学院,066503,张全商人,22222222,22222222)INSERT INTO AllStudents VALUES(20092122004,李四,2009,计算机科学与技术(jsh),0000004,2009-09-01,女,满族,团员,2-129151988

9、50025,云南省昆明市滇池学院,066504,李胜医生,33333333,33333333)INSERT INTO AllStudents VALUES(20102122005,王五,2010,计算机科学与技术,0000005,2010-09-01,男,壮族,党员,1-52615198852235,云南省昆明市滇池学院,066505,王翔工人,44444444,44444444)（3）AllStudents表：4、（1）创建Scores表：USE Student_Management_SystemCREATE

10、 TABLE dbo.Scores (ScoreID int IDENTITY (1, 1) NOT NULL ,StudentNO nvarchar (11) COLLATE Chinese_PRC_CI_AS NOT NULL ,StudentName nvarchar (32) COLLATE Chinese_PRC_CI_AS NOT NULL ,Speciality nvarchar (64) COLLATE Chinese_PRC_CI_AS NOT NULL ,Grade int NOT NULL ,Term nvarchar (16) COLLATE Chinese_PRC_C

11、I_AS NOT NULL ,Course nvarchar (128) COLLATE Chinese_PRC_CI_AS NOT NULL ,Attribute nvarchar (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,Xuefeng float NOT NULL ,Score float NULL ,) ON PRIMARYGO（主键为studentNO）（2）向Scores表插入(ch r)数据：USE Student_Management_SystemINSERT INTO Scores VALUES(20062122001,陆一,计算机科学与

12、技术(jsh),2006,2011年上学期,数据结构,必修,4,80)INSERT INTO Scores VALUES(20062122001,陆一,计算机科学与技术(jsh),2006,2011年上学期,离散数学（上）,必修,3,98)INSERT INTO Scores VALUES(20062122001,陆一,计算机科学与技术,2006,2011年上学期,数据库,必修,4,75)INSERT INTO Scores VALUES(20062122001,陆一,计算机科学与技术,2006,2011年上学期,毛泽东思想,选修,2,55)INSERT INTO Scores VALUES(

13、20062122001,陆一,计算机科学与技术(jsh),2006,2011年下学期,计算机专业英语,选修,2,56)INSERT INTO Scores VALUES(20062122001,陆一,计算机科学与技术(jsh),2006,2011年下学期,离散数学（下）,必修,3,95)INSERT INTO Scores VALUES(20072122002,马二,软件工程,2007,2011年上学期,数据结构(sh j ji u),必修,4,70)INSERT INTO Scores VALUES(20072122002,马二,软件工程,2007,2011年上学期,离散数学（上）,必修,3

14、,75)INSERT INTO Scores VALUES(20072122002,马二,软件工程,2007,2011年上学期,数据库,必修,4,80)INSERT INTO Scores VALUES(20072122002,马二,软件工程,2007,2011年上学期,毛泽东思想,选修,2,45)INSERT INTO Scores VALUES(20072122002,马二,软件工程,2007,2011年下学期,计算机专业英语,选修,2,38)INSERT INTO Scores VALUES(20072122002,马二,软件工程,2007,2011年下学期,离散数学（下）,必修,3,7

15、9)INSERT INTO Scores VALUES(20082122003,张三,电子信息工程,2008,2011年上学期(xuq),数据结构,必修,4,65)INSERT INTO Scores VALUES(20082122003,张三(zhn sn),电子信息工程,2008,2011年上学期,离散数学（上）,必修,3,79)INSERT INTO Scores VALUES(20082122003,张三,电子(dinz)信息工程,2008,2011年上学期,数据库,必修,4,60)INSERT INTO Scores VALUES(20082122003,张三,电子信息工程,2008

16、,2011年上学期,毛泽东思想,选修,2,75)INSERT INTO Scores VALUES(20082122003,张三,电子信息工程,2008,2011年下学期,计算机专业英语,选修,2,34)INSERT INTO Scores VALUES(20082122003,张三,电子信息工程,2008,2011年下学期,离散数学（下）,必修,3,90)INSERT INTO Scores VALUES(20092122004,李四,计算机科学与技术,2009,2011年上学期,数据结构,必修,4,45)INSERT INTO Scores VALUES(20092122004,李四,计算

17、机科学与技术,2009,2011年上学期,离散数学（上）,必修,3,57)INSERT INTO Scores VALUES(20092122004,李四,计算机科学与技术,2009,2011年上学期(xuq),数据库,必修,4,61)INSERT INTO Scores VALUES(20092122004,李四,计算机科学与技术,2009,2011年上学期(xuq),毛泽东思想,选修,2,62)INSERT INTO Scores VALUES(20092122004,李四,计算机科学与技术(jsh),2009,2011年下学期,计算机专业英语,选修,2,85)INSERT INTO Sc

18、ores VALUES(20092122004,李四,计算机科学与技术,2009,2011年下学期,离散数学（下）,必修,3,58)INSERT INTO Scores VALUES(20102122005,王五,软件工程,2010,2011年上学期,数据结构,必修,4,59)INSERT INTO Scores VALUES(20102122005,王五,软件工程,2010,2011年上学期,离散数学（上）,必修,3,80)INSERT INTO Scores VALUES(20102122005,王五,软件工程,2010,2011年上学期,数据库,必修,4,60)INSERT INTO S

19、cores VALUES(20102122005,王五,软件工程,2010,2011年上学期,毛泽东思想,选修,2,58)INSERT INTO Scores VALUES(20102122005,王五,软件工程(run jin n chn),2010,2011年下学期,计算机专业英语,选修,2,23)INSERT INTO Scores VALUES(20102122005,王五,软件工程(run jin n chn),2010,2011年下学期,离散数学（下）,必修,3,81)（3）Scores表：二 、功能设计登陆(dng l)用户登陆密码修改系统功能模块分角色设计（辅导员（班主任），教

20、学干事A、教学干事加入（文件导入）成绩；成绩修改，查询，删除；学分统计（应修学分，未修学分，已修学分）；查询成绩：按学号查询、按班级查询、按班级和课程查询；学生信息修改(年级，专业，备注)；删除学生，添加学生；成绩导出（excel） B、班主任查询成绩：按学号查询、按班级查询、按班级和课程查询；学生信息录入（基本信息、宿舍信息、家庭信息）；学生信息(xnx)修改（上述信息）；信息查询（按班查询、按学号查询、按指定条件查询（例如：查询指定班级(bnj)中性别“女”的所有(suyu)学生）；名单导出（两种方式：1按已有信息导出（例如导出班里团员的学生名单）；2按选择信息导出；三、操作界面（窗体类界

21、面）、控件类型、空间名。控件作用。相关代码。登录界面（1）界面图:(2)控件介绍:操作界面控件类型控件名控件标题控件作用登陆界面（Login Window）Labellabel1欢迎进入学生管理系统显示信息LabelLabel2用户账号显示输入信息LabelLabel3密码TextBoxtextBoxaccount无输入用户账号TextBoxtxtPassword无输入密码ButtonbtnLogon登录登录ButtonbtnClose取消取消登录Buttonbtnmpw修改密码修改密码（3）代码(di m)：using System;using System.Collections.Gene

22、ric;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace Student_Management_System public partial class Loginwindow : Form private string name = new string2; public string password = ne

23、w string2; SQLFunction sf; public Loginwindow() InitializeComponent(); private void btnLogon_Click(object sender, EventArgs e) try sf = new SQLFunction(); read(sf.myConn); if (this.textBoxaccount.Text = ) MessageBox.Show(请输入(shr)用户名！, 提示信息：); return; if (this.txtPassword.Text = ) MessageBox.Show(请输入

24、(shr)密码！, 提示信息：); return; if (!this.textBoxaccount.Text.Equals(name0) & !this.textBoxaccount.Text.Equals(name1) MessageBox.Show(您输入(shr)的姓名不存在！, 错误信息：, MessageBoxButtons.OK, MessageBoxIcon.Error); if (!this.txtPassword.Text.Equals(password0) & this.textBoxaccount.Text.Equals(name0) MessageBox.Show(您

25、输入(shr)的密码有错误！, 错误信息, MessageBoxButtons.OK, MessageBoxIcon.Error); if (!this.txtPassword.Text.Equals(password1) & this.textBoxaccount.Text.Equals(name1) MessageBox.Show(您输入(shr)的密码有错误！, 错误信息, MessageBoxButtons.OK, MessageBoxIcon.Error); if (this.textBoxaccount.Text.Equals(name1) & this.txtPassword.T

26、ext.Equals(password1) ) MessageBox.Show(欢迎您！教学干事！, 提示信息：); TeachingSecretaryManagementPlatform tm = new TeachingSecretaryManagementPlatform(); tm.Show(); if (this.textBoxaccount.Text.Equals(name0) & this.txtPassword.Text.Equals(password0) MessageBox.Show(欢迎您！辅导员！, 提示信息：); InstructorManagementPlatfor

27、m ip = new InstructorManagementPlatform(); ip.Show(); catch (Exception m) MessageBox.Show(m.Message); private void btnClose_Click(object sender, EventArgs e) Close(); public void read(SqlConnection Conn) int i = 0; SqlCommand com = Conn.CreateCommand(); com.CommandText = SELECT Useraccount,Password

28、FROM UserAuthentication; Conn.Open(); SqlDataReader dr = com.ExecuteReader(); while (dr.Read() i = dr.GetString(0).Trim(); this.passwordi = dr.GetString(1).Trim(); if (i 1) i+; Conn.Close(); private void btnmpw_Click(object sender, EventArgs e) try sf = new SQLFunction(); read(sf.myConn); if (this.t

29、extBoxaccount.Text.Equals(name0) & this.txtPassword.Text.Equals(password0) ModifyPassword mp = new ModifyPassword(name0, password0); mp.Show(); if (this.textBoxaccount.Text.Equals(name1) & this.txtPassword.Text.Equals(password1) ModifyPassword mp = new ModifyPassword(name1, password1); mp.Show(); if

30、 (!this.textBoxaccount.Text.Equals(name0) & !this.textBoxaccount.Text.Equals(name1) MessageBox.Show(您的信息不正确！无法(wf)修改密码！, 错误信息：, MessageBoxButtons.OK, MessageBoxIcon.Error); if (this.textBoxaccount.Text.Equals(name0) if (!this.txtPassword.Text.Equals(password0) MessageBox.Show(您的信息不正确(zhngqu)！无法修改密码！

31、, 错误信息：, MessageBoxButtons.OK, MessageBoxIcon.Error); if (this.textBoxaccount.Text.Equals(name1) if (!this.txtPassword.Text.Equals(password1) MessageBox.Show(您的信息不正确！无法修改(xigi)密码！, 错误信息：, MessageBoxButtons.OK, MessageBoxIcon.Error); catch (Exception m) MessageBox.Show(m.Message); 修改密码界面界面图：控件简介(jin

32、ji)：操作界面控件类型控件名控件标题控件作用密码修改（Modify-Password）Labellabel1原密码显示信息LabelLabel2新密码LabelLabel3再次输入新密码TextBoxTextBox1无原密码TextBoxTextBox2无新密码TextBoxTextBox3无又一次输入新密码Buttonbtnpws确定确定修改Buttonbtnpwc取消取消修改（3）代码(di m)：using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;usin

33、g System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;using System.Collections;namespace Student_Management_System public partial class ModifyPassword : Form public string Name1; public string Password1; public string password2 get return Passwor

34、d1; set Password1 = value; public ModifyPassword(string NAME, string PW) InitializeComponent(); Name1 = NAME; Password1 = PW; private void btnpws_Click(object sender, EventArgs e) if (!this.textBox1.Text.Equals(Password1) MessageBox.Show(您输入的原密码(m m)不正确, 错误信息, MessageBoxButtons.OK, MessageBoxIcon.Er

35、ror); if (!this.textBox2.Text.Equals(this.textBox3.Text) & this.textBox1.Text.Equals(Password1) MessageBox.Show(请再次(zi c)确认您的新密码, 错误信息, MessageBoxButtons.OK, MessageBoxIcon.Error); if (this.textBox1.Text.Equals(Password1) & this.textBox2.Text.Equals(this.textBox3.Text) & this.Name1 = 教学(jio xu)干事) S

36、QLFunction con = new SQLFunction(); con.myConn.ConnectionString = Data Source=.;Initial Catalog=Student_Management_System;Integrated Security=True; con.myConn.Open(); SqlCommand sc = con.myConn.CreateCommand(); string command = update UserAuthentication set Password= + this.textBox3.Text + + where U

37、seraccount=教学干事; sc.CommandText = command; sc.ExecuteNonQuery(); con.myConn.Close(); Close(); MessageBox.Show(恭喜您！已成功(chnggng)修改了密码！, 提示信息); if (this.textBox1.Text.Equals(Password1) & this.textBox2.Text.Equals(this.textBox3.Text) & this.Name1 = 辅导员) SQLFunction con = new SQLFunction(); con.myConn.Co

38、nnectionString = Data Source=.;Initial Catalog=Student_Management_System;Integrated Security=True; con.myConn.Open(); SqlCommand sc = con.myConn.CreateCommand(); string command = update UserAuthentication set Password= + this.textBox3.Text + + where Useraccount=辅导员; sc.CommandText = command; sc.Exec

39、uteNonQuery(); con.myConn.Close(); Close(); MessageBox.Show(恭喜您！已成功修改(xigi)了密码！, 提示信息); private void btnpwc_Click(object sender, EventArgs e) Close(); 辅导员管理(gunl)界面（1）、界面图：控件介绍(jisho)：操作界面控件类型控件名控件标题控件作用TabControltabControl1分页显示学生成绩查询DataGridViewdataGridView1显示数据LabelLabel1按学号学号LabelLabel2按班级班级Label

40、Label3按课程课程ComboBoxcomboSelectStudentNO1无显示学号ComboBoxcomboSelectSpeciality无显示班级ComboBoxcomboSelectCourse无显示课程ButtonbtnQuery1查询确认查询ButtonbtnQuery2查询确认查询ButtonbtnQuery3查询确认查询学生信息修改DataGridViewdataGridView2显示数据ComboBoxcomboSelectStudentNO2无显示学号ButtonbtnSIMSure确认确认修改Labellabel4学生学号显示文字LabelLabel5姓名显示文字L

41、abelLabel6性别显示文字LabelLabel7专业显示文字LabelLabel8年级显示文字LabelLabel9ID显示文字LabelLabel10宿舍号显示文字LabelLabel11宿舍电话显示文字LabelLabel12父母姓名显示文字学生信息修改LabelLabel13父母电话显示文字LabelLabel14父母工作显示文字TextBoxtextBox1无显示相应的内容TextBoxtextBox2TextBoxtextBox3TextBoxtextBox4TextBoxtextBox5TextBoxtextBox6TextBoxtextBox7TextBoxtextBox8

42、TextBoxtextBox9TextBoxtextBox10学生信息录入DataGridViewdataGridView3显示数据ButtonbtnSIEntry信息录入确认录入信息Labellabel15学生基本信息显示文字信息（提示）Label16学生家庭信息Label17学生宿舍信息Label18学号Label19姓名Label20年级Label21专业Label22IDLabel23性别Label24父母姓名Label25父母电话Label26父母工作Label27宿舍号Label28宿舍电话TextBoxtextBox_a无输入对应信息textBox_btextBox_c学生信息录

43、入TextBoxtextBox_d无输入对应信息textBox_etextBox_ftextBox_itextBox_jtextBox_ktextBox_gtextBox_h名单导出DataGridViewdataGridView4Labellabel29导出学生政治面貌信息：显示文字信息label30导出男/女学生名单:Label31导出学生选课情况：ComboBoxcomboPolitication无显示对应信息comboSex无comboCourse1无ButtonbtnLoESure1确定确定导出该信息btnLoESure2确定btnLoESure3确定代码(di m)：using S

44、ystem;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.Collections;using System.Text.RegularExpressions;namespace Student_Management_System publi

45、c partial class InstructorManagementPlatform : Form SQLFunction sql; public InstructorManagementPlatform() InitializeComponent(); sql = new SQLFunction(); GetStuMessageToComboBox1(); GetStuMessageToComboBox2And7(); GetStuMessageToComboBox3(); GetStuMessageToComboBox4(); GetStuMessageToComboBox5(); G

46、etStuMessageToComboBox6(); public void GetStuMessageToComboBox1() const string connectionString = Data Source=.;Initial Catalog=Student_Management_System;Integrated Security=True; SqlConnection myConn; myConn = new SqlConnection(); myConn.ConnectionString = connectionString; SqlCommand com = myConn.

47、CreateCommand(); com.CommandText = SELECT distinctstudentNOFROM Scores; myConn.Open(); SqlDataReader dr = com.ExecuteReader(); while (dr.Read() string no = dr.GetString(0); comboSelectStudentNO1.Items.Add(no); public void GetStuMessageToComboBox2And7() const string connectionString = Data Source=.;I

48、nitial Catalog=Student_Management_System;Integrated Security=True; SqlConnection myConn; myConn = new SqlConnection(); myConn.ConnectionString = connectionString; SqlCommand com = myConn.CreateCommand(); com.CommandText = SELECT distinctCourseFROM Scores; myConn.Open(); SqlDataReader dr = com.Execut

49、eReader(); while (dr.Read() string course = dr.GetString(0); comboSelectCourse.Items.Add(course); comboCourse1.Items.Add(course); public void GetStuMessageToComboBox3() const string connectionString = Data Source=.;Initial Catalog=Student_Management_System;Integrated Security=True; SqlConnection myC

50、onn; myConn = new SqlConnection(); myConn.ConnectionString = connectionString; SqlCommand com = myConn.CreateCommand(); com.CommandText = SELECT distinctSpecialityFROM Scores; myConn.Open(); SqlDataReader dr = com.ExecuteReader(); while (dr.Read() string speciality = dr.GetString(0); comboSelectSpec

51、iality.Items.Add(speciality); public void GetStuMessageToComboBox4() const string connectionString = Data Source=.;Initial Catalog=Student_Management_System;Integrated Security=True; SqlConnection myConn; myConn = new SqlConnection(); myConn.ConnectionString = connectionString; SqlCommand com = myCo

52、nn.CreateCommand(); com.CommandText = SELECT studentNOFROM AllStudents; myConn.Open(); SqlDataReader dr = com.ExecuteReader(); while (dr.Read() string no = dr.GetString(0); comboSelectStudentNO2.Items.Add(no); public void GetStuMessageToComboBox5() comboPolitication.Items.Add(团员(tunyun); comboPoliti

53、cation.Items.Add(党员(dngyun); public void GetStuMessageToComboBox6() comboSex.Items.Add(男生(nnshng); comboSex.Items.Add(女生(nshng); private void btnQuery1_Click(object sender, EventArgs e) if (comboSelectStudentNO1.Text != ) this.dataGridView1.DataSource = sql.GetStudentScore(comboSelectStudentNO1.Text

54、); else MessageBox.Show(请选择(xunz)学号！); private void btnQuery2_Click(object sender, EventArgs e) if (comboSelectSpeciality.Text != ) this.dataGridView1.DataSource = sql.GetStudentScore(comboSelectSpeciality.Text); else MessageBox.Show(请选择(xunz)专业！); private void btnQuery3_Click(object sender, EventAr

55、gs e) if (comboSelectCourse.Text != ) this.dataGridView1.DataSource = sql.GetStudentScore(comboSelectCourse.Text); else MessageBox.Show(请选择课程！); private void btnSIMSure_Click(object sender, EventArgs e) if (comboSelectStudentNO2.Text != ) if (textBox1.Text = & textBox2.Text = & textBox3.Text = & tex

56、tBox4.Text = & textBox5.Text = & textBox6.Text = & textBox7.Text = & textBox8.Text = & textBox9.Text = & textBox10.Text = ) MessageBox.Show(没有修改(xigi)任何信息！); return; else const string connectionString = Data Source=.;Initial Catalog=Student_Management_System;Integrated Security=True; SqlConnection m

57、yConn; myConn = new SqlConnection(); myConn.ConnectionString = connectionString; myConn.Open(); if (textBox1.Text.ToString() != ) SqlCommand SC = new SqlCommand(UPDATE AllStudents SET studnetName= + textBox1.Text + WHERE studentNO= + comboSelectStudentNO2.Text + , myConn); SC.ExecuteNonQuery(); if (

58、textBox2.Text.ToString() != ) SqlCommand SC = new SqlCommand(UPDATE AllStudents SET Grade= + textBox2.Text + WHERE studentNO= + comboSelectStudentNO2.Text + , myConn); SC.ExecuteNonQuery(); if (textBox3.Text.ToString() != ) SqlCommand SC = new SqlCommand(UPDATE AllStudents SET Sex= + textBox3.Text +

59、 WHERE studentNO= + comboSelectStudentNO2.Text + , myConn); SC.ExecuteNonQuery(); if (textBox4.Text.ToString() != ) SqlCommand SC = new SqlCommand(UPDATE AllStudents SET ID= + textBox4.Text + WHERE studentNO= + comboSelectStudentNO2.Text + , myConn); SC.ExecuteNonQuery(); if (textBox5.Text.ToString(

60、) != ) SqlCommand SC = new SqlCommand(UPDATE AllStudents SET Speciality= + textBox5.Text + WHERE studentNO= + comboSelectStudentNO2.Text + , myConn); SC.ExecuteNonQuery(); if (textBox6.Text.ToString() != ) SqlCommand SC = new SqlCommand(UPDATE AllStudents SET RoomNo= + textBox6.Text + WHERE studentN