學(xué)生成績管理系統(tǒng)設(shè)計報告

學(xué)生成績管理系統(tǒng)設(shè)計報告專業(yè)：計算機(jī)信息管理學(xué)號：102001205姓名：和坤指導(dǎo)老師：薛海燕2011年11月22日緒論1.1開發(fā)背景隨著社會信息量的與日劇增，學(xué)校需要有一很好的學(xué)生成績管理系統(tǒng)，以方便對學(xué)生的成績進(jìn)行有效的管理。系統(tǒng)應(yīng)具有既方便教師對學(xué)生成績的查詢和插入，也方便學(xué)生對自己成績和獲得的學(xué)分進(jìn)行查詢的功能。而我國大中專院校的學(xué)生成績管理水平普遍不高。在當(dāng)今的信息時代，傳統(tǒng)的管理方法必然要被以計算機(jī)為根底的信息管理系統(tǒng)所替代，而且目前很多重點院校都已經(jīng)有了自己的教務(wù)管理系統(tǒng)。已有的學(xué)生管理系統(tǒng)大都偏向?qū)W生檔案管理、學(xué)籍管理等。本案例設(shè)計的“學(xué)生成績管理系統(tǒng)〞以學(xué)生成績數(shù)據(jù)為主的管理，具有數(shù)據(jù)操作方便、高效、迅速等優(yōu)點。1.2系統(tǒng)開發(fā)工具選擇本系統(tǒng)采用.NETFramework1.1架構(gòu)為公司內(nèi)部使用，按照商業(yè)軟件模式設(shè)計，使用微軟公司的VisualStudio2023為前端開發(fā)工具，微軟公司的SQLServer2005為后臺數(shù)據(jù)庫，使用ClickOne來制作安裝程序。VisualStudio2023是一種可視化的、面對對象和條用事件驅(qū)動方式的winform前端開發(fā)工具，可用于開發(fā)Windows環(huán)境下的應(yīng)用程序。通過降低其復(fù)雜度從而使Windows軟件開發(fā)得以廣泛應(yīng)用。最近，利用VisualStudio.NET，Microsoft又為開發(fā)人員提供了輕松開發(fā)分布式應(yīng)用程序的工具與技術(shù)。SQLServer2005是新一代大型關(guān)系數(shù)據(jù)管理系統(tǒng)，它在電子商務(wù)、數(shù)據(jù)倉庫和數(shù)據(jù)庫解決方案等應(yīng)用中起著重要的核心作用，可為企業(yè)的數(shù)據(jù)管理提供強(qiáng)大的支持，對數(shù)據(jù)庫中的數(shù)據(jù)提供有效的管理，并采用有效的措施實現(xiàn)數(shù)據(jù)的完整性及數(shù)據(jù)的平安性。第2章系統(tǒng)分析與數(shù)據(jù)庫設(shè)計2.1系統(tǒng)功能需求1〕待開發(fā)軟件的功能需求學(xué)生成績管理系統(tǒng)必須能夠完成系統(tǒng)管理、成績管理、課程管理、班級管理、學(xué)生根本信息管理、專業(yè)管理、教師管理、課程表管理。系統(tǒng)管理員可實現(xiàn)所有功能。管理員無法實現(xiàn)數(shù)據(jù)庫的備份和復(fù)原功能，其他功能都可以實現(xiàn)。系統(tǒng)管理主要是維護(hù)系統(tǒng)的正常運行和平安性設(shè)置，當(dāng)?shù)卿浻脩羰枪芾韱T或系統(tǒng)管理員時能完成查詢用戶、添加用戶、刪除用戶、修改密碼、重新登錄等功能。當(dāng)?shù)卿浬矸菔墙處熀蛯W(xué)生時只能實現(xiàn)重新登錄和密碼修改。成績管理主要是學(xué)生成績的查詢、錄入、修改、刪除及統(tǒng)計個人成績的功能。用戶登錄身份是教師時可實現(xiàn)成績的錄入和查詢。登錄身份是學(xué)生時只能實現(xiàn)成績查詢和個人成績統(tǒng)計功能。課程管理主要是課程信息的查詢和操作〔添加、修改、刪除〕。用戶登錄身份是教師和學(xué)生時只能進(jìn)行查詢操作。班級管理主要是班級信息的查詢和操作〔添加、修改、刪除〕。用戶登錄身份是教師和學(xué)生時只能進(jìn)行查詢操作。學(xué)生管理主要是學(xué)生信息的查詢和操作〔添加、修改、刪除〕。用戶登錄身份是教師和學(xué)生時只能進(jìn)行查詢操作。專業(yè)管理主要是專業(yè)信息的查詢和操作〔添加、修改、刪除〕。用戶登錄身份是教師和學(xué)生時只能進(jìn)行查詢操作。教師管理主要是教師信息的查詢和操作〔添加、修改、刪除〕。用戶登錄身份是教師只能進(jìn)行查詢操作。課程表管理主要是班級信息的查詢和操作〔添加、修改、刪除〕。用戶登錄身份是教師和學(xué)生時只能進(jìn)行查詢操作。窗體：窗體層疊，水平平鋪，垂直平鋪。翻開多個窗體時后，在點擊這個功能。退出：結(jié)束操作系統(tǒng)。2.2數(shù)據(jù)描述表2.2-1用戶登錄表〔UserInfo〕字段名中文描述類型長度是否為空是否為主鍵Userid用戶名Varchar10否是Userpwd用戶密碼Varchar10否否Userlevel用戶權(quán)限Varchar10是否表2.2-2專業(yè)信息表〔SpecialtyInfo〕字段名中文描述類型長度是否為空是否為主鍵Specialtyid專業(yè)代號Varchar4否是Specialtyname專業(yè)名稱Varchar50是否表2.2-3班級信息表〔ClassInfo〕字段名中文描述類型長度是否為空是否為主鍵Classid班級名稱Varchar10否是Specialtyid專業(yè)代號Varchar4是否Stunum學(xué)生人數(shù)int是否Remark備注Varchar100是否表2.2-4教師信息表〔TeacherInfo〕字段名中文描述類型長度是否為空是否為主鍵Teaid教師編號Varchar10否是Teaname教師姓名Varchar20是否Teasex教師性別Varchar2是否Teaoffice辦公室Varchar11是否Teatel私人Varchar11是否Taddress家庭住址Varchar100是否Teabirthday出生年月Datetime是否表2.2-5學(xué)生信息表〔StudentInfo〕字段名中文描述類型長度是否為空是否為主鍵Sno學(xué)號Varchar10否是Sname姓名Varchar20是否Sex性別Varchar2是否Sbirthday出生年月Datetime是否Classid所在班級Varchar10是否Specialtyid所在專業(yè)號Varchar4是否Stel電話Varchar11是否Saddress家庭住址Varchar100是否表2.2-6成績信息表〔StuGrade〕字段名中文描述類型長度是否為空是否為主鍵Sno學(xué)號Varchar10否是Cno課程編號Varchar10否是Gradepeacetime平時成績numeric4,1否否GradeWrite筆試成績numeric4,1否否Grade總成績numeric4,1否否Time時間Varchar30否否表2.2-7課程信息表〔CourseInfo〕字段名中文描述類型長度是否為空是否為主鍵Cno課程編號Varchar10否是Cname課程名稱Varchar50是否Cpriment實驗學(xué)時int是否Cteaching講課學(xué)時int是否Credit總學(xué)分numeric4,1是否Coursetypeid課程類型號int是否表2.2-8課程類型表〔CourseType〕字段名中文描述類型長度是否為空是否為主鍵Coursetypeid課程類型編號int否是Coursetypename課程類型名Varchar20否否表2.2-9課程表〔CourseTable〕字段名中文描述類型長度是否為空是否為主鍵ID標(biāo)識列int否是Time學(xué)年Varchar30否否Termid學(xué)期int否否Classid班級名稱Varchar10否否Cno課程編號Varchar10是否Teaid教師編號Varchar10是否主界面程序源代碼privatevoidbutton1_Click(objectsender,EventArgse)//登錄{DBHelpDBhelp=newDBHelp();SqlConnectioncon=newSqlConnection(DBhelp.constr);stringsql="";if(radioButton1.Checked==true){sql=string.Format("select*fromUserInfowhereUserid='{0}'andUserpwd='{1}'andUserlevel='{2}'",textBox1.Text,textBox2.Text,radioButton1.Text);Program.x="管理員";}if(radioButton2.Checked==true){sql=string.Format("select*fromUserInfowhereUserid='{0}'andUserpwd='{1}'andUserlevel='{2}'",textBox1.Text,textBox2.Text,radioButton2.Text);Program.x="教師";}if(radioButton3.Checked==true){sql=string.Format("select*fromUserInfowhereUserid='{0}'andUserpwd='{1}'andUserlevel='{2}'",textBox1.Text,textBox2.Text,radioButton3.Text);Program.x="學(xué)生";}if(radioButton4.Checked==true){sql=string.Format("select*fromUserInfowhereUserid='{0}'andUserpwd='{1}'andUserlevel='{2}'",textBox1.Text,textBox2.Text,radioButton4.Text);}con.Open();SqlCommandcom=newSqlCommand(sql,con);SqlDataReaderred=com.ExecuteReader();if(red.Read()){Form_mainf1=newForm_main();f1.Show();}else{MessageBox.Show("信息錯誤","error");}//Form_mainf1=newForm_main();//f1.Show();}privatevoidbutton2_Click(objectsender,EventArgse)//取消{Application.Exit();}privatevoidForm_main_Load(objectsender,EventArgse){if(Program.x=="管理員"){數(shù)據(jù)庫備份ToolStripMenuItem.Enabled=false;數(shù)據(jù)庫恢復(fù)ToolStripMenuItem.Enabled=false;}if(Program.x=="教師"){用戶管理ToolStripMenuItem.Enabled=false;數(shù)據(jù)庫備份ToolStripMenuItem.Enabled=false;數(shù)據(jù)庫恢復(fù)ToolStripMenuItem.Enabled=false;成績修改ToolStripMenuItem.Enabled=false;課程信息操作ToolStripMenuItem.Enabled=false;班級信息操作ToolStripMenuItem.Enabled=false;學(xué)生信息操做ToolStripMenuItem.Enabled=false;教師信息操作ToolStripMenuItem.Enabled=false;課程表操作ToolStripMenuItem.Enabled=false;專業(yè)信息操作ToolStripMenuItem.Enabled=false;}if(Program.x=="學(xué)生"){用戶管理ToolStripMenuItem.Enabled=false;數(shù)據(jù)庫備份ToolStripMenuItem.Enabled=false;數(shù)據(jù)庫恢復(fù)ToolStripMenuItem.Enabled=false;成績修改ToolStripMenuItem.Enabled=false;課程信息操作ToolStripMenuItem.Enabled=false;班級信息操作ToolStripMenuItem.Enabled=false;學(xué)生信息操做ToolStripMenuItem.Enabled=false;課程表操作ToolStripMenuItem.Enabled=false;成績錄入ToolStripMenuItem.Enabled=false;教師管理ToolStripMenuItem.Enabled=false;專業(yè)信息操作ToolStripMenuItem.Enabled=false;}}privatevoid退出ToolStripMenuItem_Click(objectsender,EventArgse){Application.Exit();}privatevoid用戶查詢ToolStripMenuItem_Click(objectsender,EventArgse){Form_useselusesel=newForm_usesel();usesel.MdiParent=this;usesel.Show();}privatevoid用戶操作ToolStripMenuItem_Click(objectsender,EventArgse){Form_useuse=newForm_use();use.MdiParent=this;use.Show();}privatevoid成績錄入ToolStripMenuItem_Click(objectsender,EventArgse){Form_scoreintof4=newForm_scoreinto();f4.Show();}privatevoid成績修改ToolStripMenuItem_Click(objectsender,EventArgse){Form_Scoref5=newForm_Score();f5.Show();}privatevoid成績查詢ToolStripMenuItem1_Click(objectsender,EventArgse){Form_scoreself6=newForm_scoresel();f6.Show();}privatevoid密碼修改ToolStripMenuItem_Click(objectsender,EventArgse){Form_pwdpwd=newForm_pwd();pwd.MdiParent=this;pwd.Show();}privatevoid重新登錄ToolStripMenuItem_Click(objectsender,EventArgse){Loginf1=newLogin();this.Close();f1.Show();}privatevoid數(shù)據(jù)庫備份ToolStripMenuItem_Click(objectsender,EventArgse){stringpath=@"G:\102001205何坤\DB備份\student.bak";stringbackupstr="backupdatabaseStudenttodisk='"+path+"';";DBHelpDBHelp=newDBHelp();SqlConnectioncon=newSqlConnection(DBHelp.constr);SqlCommandcom=newSqlCommand(backupstr,con);try{con.Open();com.ExecuteNonQuery();MessageBox.Show("備份成功");}catch{MessageBox.Show("備份失敗");}finally{con.Close();}}privatevoid數(shù)據(jù)庫恢復(fù)ToolStripMenuItem_Click(objectsender,EventArgse){stringpath=@"G:\102001205何坤\DB備份\student.bak";stringrestorestr="restoredatabaseStudenttodisk='"+path+"';";DBHelpDBHelp=newDBHelp();SqlConnectioncon=newSqlConnection(DBHelp.constr);SqlCommandcom=newSqlCommand(restorestr,con);try{con.Open();com.ExecuteNonQuery();MessageBox.Show("恢復(fù)成功");}catch{MessageBox.Show("恢復(fù)失敗");}finally{con.Close();}}privatevoid窗體層疊ToolStripMenuItem_Click(objectsender,EventArgse){this.LayoutMdi(MdiLayout.Cascade);}privatevoid水平平鋪ToolStripMenuItem_Click(objectsender,EventArgse){this.LayoutMdi(MdiLayout.TileHorizontal);}privatevoid垂直平鋪ToolStripMenuItem_Click(objectsender,EventArgse){this.LayoutMdi(MdiLayout.TileVertical);}privatevoid教師信息查詢ToolStripMenuItem_Click(objectsender,EventArgse){Teacherselteasel=newTeachersel();teasel.MdiParent=this;teasel.Show();}privatevoid教師信息操作ToolStripMenuItem_Click(objectsender,EventArgse){Teachertea=newTeacher();tea.MdiParent=this;tea.Show();}privatevoid學(xué)生信息查詢ToolStripMenuItem_Click(objectsender,EventArgse){Stuselstusel=newStusel();stusel.MdiParent=this;stusel.Show();}privatevoid學(xué)生信息操做ToolStripMenuItem_Click(objectsender,EventArgse){Studentstu=newStudent();stu.MdiParent=this;stu.Show();}privatevoid統(tǒng)計個人成績ToolStripMenuItem_Click(objectsender,EventArgse){tongjit=newtongji();t.MdiParent=this;t.Show();}privatevoid專業(yè)信息查詢ToolStripMenuItem_Click(objectsender,EventArgse){Specialty_sels=newSpecialty_sel();s.MdiParent=this;s.Show();}privatevoid課程表查詢ToolStripMenuItem_Click(objectsender,EventArgse){Coursetableseltable=newCoursetablesel();table.MdiParent=this;table.Show();}privatevoid課程表操作ToolStripMenuItem_Click(objectsender,EventArgse){Coursetableta=newCoursetable();ta.MdiParent=this;ta.Show();}privatevoid課程管理ToolStripMenuItem1_Click(objectsender,EventArgse){Form_Courseself=newForm_Coursesel();f.MdiParent=this;f.Show();}privatevoid課程信息操作ToolStripMenuItem_Click(objectsender,EventArgse){Form_CourseC=newForm_Course();C.MdiParent=this;C.Show();}privatevoid班級查詢ToolStripMenuItem_Click(objectsender,EventArgse){Classsels=newClasssel();s.MdiParent=this;s.Show();}privatevoid班級信息操作ToolStripMenuItem_Click(objectsender,EventArgse){Classc=newClass();c.MdiParent=this;c.Show();}privatevoid專業(yè)信息操作ToolStripMenuItem_Click(objectsender,EventArgse){Specialtysa=newSpecialty();sa.MdiParent=this;sa.Show();}}}Class.csprivatevoidClass_Load(objectsender,EventArgse){try{DBHelpDBhelp=newDBHelp();SqlConnectioncon=newSqlConnection(DBhelp.constr);stringsql="selectSpecialtynamefromSpecialtyInfo";SqlDataAdaptersda=newSqlDataAdapter(sql,con);DataSetds=newDataSet();sda.Fill(ds,"a");foreach(DataRowaRowinds.Tables[0].Rows){comboBox1.Items.Add(aRow[0].ToString().Trim());comboBox2.Items.Add(aRow[0].ToString().Trim());}con.Close();}catch(Exceptionex){MessageBox.Show("出錯了?。?+ex.ToString());}}privatevoidbutton1_Click(objectsender,EventArgse){try{DBHelpDBHelp=newDBHelp();SqlConnectioncon=newSqlConnection(DBHelp.constr);con.Open();stringsql="selectClassidas班級,Specialtynameas專業(yè)名,Stunumas人數(shù),Remarkas備注fromClassInfo,SpecialtyInfowhereClassInfo.Specialtyid=SpecialtyInfo.Specialtyid";if(comboBox1.Text!=""){sql+="andSpecialtyname='{0}'";}if(textBox1.Text!=""){sql+="andClassid='{1}'";}sql=string.Format(sql,comboBox1.Text,textBox1.Text);SqlDataAdaptersda=newSqlDataAdapter(sql,con);DataSetds=newDataSet();sda.Fill(ds,"a");dataGridView1.DataSource=ds.Tables[0];con.Close();Height=Convert.ToInt32("400");}catch(Exceptionex){MessageBox.Show("出錯了?。?+ex.ToString());}}privatevoidDatashow(){DBHelpDBHelp=newDBHelp();SqlConnectioncon=newSqlConnection(DBHelp.constr);con.Open();stringsql="selectClassidas班級,Specialtynameas專業(yè)名,Stunumas人數(shù),Remarkas備注fromClassInfo,SpecialtyInfowhereClassInfo.Specialtyid=SpecialtyInfo.Specialtyid";SqlDataAdaptersda=newSqlDataAdapter(sql,con);DataSetds=newDataSet();sda.Fill(ds,"a");dataGridView1.DataSource=ds.Tables[0];con.Close();}stringa="";privatevoidbutton2_Click(objectsender,EventArgse)//添加前清空{(diào)a="add";textBox2.Enabled=true;comboBox1.Text="";textBox2.Text="";textBox3.Text="";textBox4.Text="";}privatevoidbutton3_Click(objectsender,EventArgse)//修改{a="update";textBox2.Enabled=false;}privatevoidbutton4_Click(objectsender,EventArgse){try{if(a=="add")//添加保存{DBHelpDBhelp=newDBHelp();SqlConnectioncon=newSqlConnection(DBhelp.constr);stringsql1=string.Format("selectSpecialtyidfromSpecialtyInfowhereSpecialtyname='{0}'",comboBox2.Text);SqlCommandcom=newSqlCommand(sql1,con);con.Open();SqlDataReaderdr=com.ExecuteReader();stringno="";if(dr.Read()){no=dr[0].ToString();}con.Close();//stringsql2=string.Format("selectTeaidfromTeacherInfowhereTeaname='{0}'",textBox2.Text);//SqlCommandcom0=newSqlCommand(sql2,con);//con.Open();//SqlDataReaderdr1=com0.ExecuteReader();//stringTno="";//if(dr1.Read())//{//Tno=dr1[0].ToString();//}//con.Close();stringsql=string.Format("insertintoClassInfovalues('{0}','{1}','{2}','{3}')",textBox2.Text,no,textBox3.Text,textBox4.Text);SqlCommandcom1=newSqlCommand(sql,con);con.Open();intresult=com1.ExecuteNonQuery();if(result>0){MessageBox.Show("插入成功");Datashow();}else{MessageBox.Show("插入失敗");}con.Close();}if(a=="update")//修改保存{DBHelpDBhelp=newDBHelp();SqlConnectioncon=newSqlConnection(DBhelp.constr);stringsql1=string.Format("selectSpecialtyidfromSpecialtyInfowhereSpecialtyname='{0}'",comboBox2.Text);SqlCommandcom=newSqlCommand(sql1,con);con.Open();SqlDataReaderdr=com.ExecuteReader();stringno="";if(dr.Read()){no=dr[0].ToString();}con.Close();stringsql=string.Format("updateClassInfosetSpecialtyid='{0}',Stunum={1},Remark='{2}'whereClassid='{3}'",no,textBox3.Text,textBox4.Text,textBox2.Text);SqlCommandcom1=newSqlCommand(sql,con);con.Open();intresult=com1.ExecuteNonQuery();if(result>0){MessageBox.Show("修改成功");Datashow();}else{MessageBox.Show("修改失敗");}con.Close();}}catch(Exceptionex){MessageBox.Show("出錯了?。?+ex.ToString());}}privatevoidbutton5_Click(objectsender,EventArgse)//刪除{try{if(MessageBox.Show("確定要刪除","提示信息",MessageBoxButtons.YesNo)==DialogResult.Yes){DBHelpDBhelp=newDBHelp();SqlConnectioncon=newSqlConnection(DBhelp.constr);stringsql=string.Format("deletefromClassInfowhereClassid='{0}'",textBox2.Text);SqlCommandcom=newSqlCommand(sql,con);con.Open();intresult=com.ExecuteNonQuery();if(result>0){MessageBox.Show("刪除成功");Datashow();}else{MessageBox.Show("刪除失敗");}con.Close();}}catch(Exceptionex){MessageBox.Show("出錯了??！"+ex.ToString());}}privatevoiddataGridView1_CellClick(objectsender,DataGridViewCellEventArgse){textBox2.Text=dataGridView1.CurrentRow.Cells[0].Value.ToString();comboBox2.Text=dataGridView1.CurrentRow.Cells[1].Value.ToString();textBox3.Text=dataGridView1.CurrentRow.Cells[2].Value.ToString();textBox4.Text=dataGridView1.CurrentRow.Cells[3].Value.ToString();}}}G:\102001205和坤\學(xué)生成績管理系統(tǒng)\學(xué)生成績管理系統(tǒng)\Classsel.csprivatevoidClasssel_Load(objectsender,EventArgse){DBHelpDBhelp=newDBHelp();SqlConnectioncon=newSqlConnection(DBhelp.constr);stringsql="selectSpecialtynamefromSpecialtyInfo";SqlDataAdaptersda=newSqlDataAdapter(sql,con);DataSetds=newDataSet();sda.Fill(ds,"a");foreach(DataRowaRowinds.Tables[0].Rows){comboBox1.Items.Add(aRow[0].ToString().Trim());}con.Close();}privatevoidbutton1_Click(objectsender,EventArgse){try{DBHelpDBHelp=newDBHelp();SqlConnectioncon=newSqlConnection(DBHelp.constr);con.Open();stringsql="selectClassidas班級,Specialtynameas專業(yè)名,Stunumas人數(shù),Remarkas備注fromClassInfo,SpecialtyInfowhereClassInfo.Specialtyid=SpecialtyInfo.Specialtyid";if(comboBox1.Text!=""){sql+="andSpecialtyname='{0}'";}if(textBox1.Text!=""){sql+="andClassid='{1}'";}sql=string.Format(sql,comboBox1.Text,textBox1.Text);SqlDataAdaptersda=newSqlDataAdapter(sql,con);DataSetds=newDataSet();sda.Fill(ds,"a");dataGridView1.DataSource=ds.Tables[0];con.Close();}catch(Exceptionex){MessageBox.Show("出錯了?。?+ex.ToString());}}}}G:\102001205和坤\學(xué)生成績管理系統(tǒng)\學(xué)生成績管理系統(tǒng)\Coursetable.cstry{DBHelpDBHelp=newDBHelp();SqlConnectioncon=newSqlConnection(DBHelp.constr);con.Open();stringsql="selectID,Time,Termid,Classid,Cname,TeanamefromCoursetable,CourseInfo,TeacherInfowhereCoursetable.Cno=CourseInfo.CnoandCoursetable.Teaid=TeacherInfo.Teaid";if(comboBox1.Text!=""){sql+="andTime='{0}'";}if(comboBox2.Text!=""){sql+="andTermid={1}";}if(comboBox3.Text!=""){sql+="andClassid='{2}'";}if(comboBox5.Text!=""){sql+="andCname='{3}'";}if(textBox1.Text!=""){sql+="andTeaname='{4}'";}sql=string.Format(sql,comboBox1.Text,comboBox2.Text,comboBox3.Text,comboBox5.Text,textBox1.Text);SqlDataAdaptersda=newSqlDataAdapter(sql,con);DataSetds=newDataSet();sda.Fill(ds,"a");dataGridView1.DataSource=ds.Tables[0];con.Close();//列名顯示為中文dataGridView1.Columns[0].HeaderText="編號";dataGridView1.Columns[1].HeaderText="學(xué)年";dataGridView1.Columns[2].HeaderText="學(xué)期";dataGridView1.Columns[3].HeaderText="班級";dataGridView1.Columns[4].HeaderText="課程名稱";dataGridView1.Columns[5].HeaderText="教師姓名";}catch(Exceptionex){MessageBox.Show("出錯了?。?+ex.ToString());}}privatevoiddataGridView1_CellClick(objectsender,DataGridViewCellEventArgse){textBox2.Text=dataGridView1.CurrentRow.Cells[5].Value.ToString();label6.Text=dataGridView1.CurrentRow.Cells[0].Value.ToString();comboBox4.Text=dataGridView1.CurrentRow.Cells[1].Value.ToString();comboBox6.Text=dataGridView1.CurrentRow.Cells[2].Value.ToString();comboBox7.Text=dataGridView1.CurrentRow.Cells[3].Value.ToString();comboBox8.Text=dataGridView1.CurrentRow.Cells[4].Value.ToString();}stringa="";privatevoidbutton2_Click(objectsender,EventArgse){a="add";comboBox4.Enabled=true;comboBox6.Enabled=true;comboBox7.Enabled=true;textBox2.Enabled=true;comboBox4.Text="";comboBox6.Text="";comboBox7.Text="";comboBox8.Text="";textBox2.Text="";label6.Text="";}privatevoidbutton3_Click(objectsender,EventArgse){a="update";comboBox4.Enabled=false;comboBox6.Enabled=false;comboBox7.Enabled=false;textBox2.Enabled=false;}privatevoidbutton4_Click(objectsender,EventArgse){try{if(a=="add")//添加保存{DBHelpDBhelp=newDBHelp();SqlConnectioncon=newSqlConnection(DBhelp.constr);stringsql1=string.Format("selectCnofromCourseInfowhereCname='{0}'",comboBox8.Text);SqlCommandcom=newSqlCommand(sql1,con);con.Open();SqlDataReaderdr=com.ExecuteReader();stringno="";if(dr.Read()){no=dr[0].ToString();}con.Close();stringsql2=string.Format("selectTeaidfromTeacherInfowhereTeaname='{0}'",textBox2.Text);SqlCommandcom0=newSqlCommand(sql2,con);con.Open();SqlDataReaderdr1=com0.ExecuteReader();stringTno="";if(dr1.Read()){Tno=dr1[0].ToString();}con.Close();stringsql=string.Format("insertintoCoursetablevalues('{0}','{1}','{2}','{3}','{4}')",comboBox4.Text,comboBox6.Text,comboBox7.Text,no,Tno);SqlCommandcom1=newSqlCommand(sql,con);con.Open();intresult=com1.ExecuteNonQuery();if(result>0){MessageBox.Show("插入成功");Datashow();}else{MessageBox.Show("插入失敗");}con.Close();}if(a=="update")//修改保存{DBHelpDBhelp=newDBHelp();SqlConnectioncon=newSqlConnection(DBhelp.constr);stringsql1=string.Format("selectCnofromCourseInfowhereCname='{0}'",comboBox8.Text);SqlCommandcom=newSqlCommand(sql1,con);con.Open();SqlDataReaderdr=com.ExecuteReader();stringno="";if(dr.Read()){no=dr[0].ToString();}con.Close();stringsql=string.Format("updateCoursetablesetCno='{0}'whereID='{1}'",no,label6.Text);SqlCommandcom1=newSqlCommand(sql,con);con.Open();intresult=com1.ExecuteNonQuery();if(result>0){MessageBox.Show("修改成功");Datashow();}else{MessageBox.Show("修改失敗");}con.Close();}}catch(Exceptionex){MessageBox.Show("出錯了?。?+ex.ToString());}}privatevoidCoursetable_Load(objectsender,EventArgse){try{DBHelpDBhelp=newDBHelp();SqlConnectioncon=newSqlConnection(DBhelp.constr);stringsql2="selectCnamefromCourseInfo";stringsql3="selectClassidfromClassInfo";SqlDataAdaptersda1=newSqlDataAdapter(sql2,con);SqlDataAdaptersda2=newSqlDataAdapter(sql3,con);con.Open();DataSetds=newDataSet();//sda.Fill(ds,"a");sda1.Fill(ds,"b");sda2.Fill(ds,"c");foreach(DataRowaRowinds.Tables[0].Rows){comboBox5.Items.Add(aRow[0].ToString().Trim());comboBox8.Items.Add(aRow[0].ToString().Trim());}foreach(DataRowaRowinds.Tables[1].Rows){comboBox3.Items.Add(aRow[0].ToString().Trim());comboBox7.Items.Add(aRow[0].ToString().Trim());}con.Close();}catch(Exceptionex){MessageBox.Show("出錯了?。?+ex.ToString());}}privatevoidbutton5_Click(objectsender,EventArgse){try{if(MessageBox.Show("確定要刪除","提示信息",MessageBoxButtons.YesNo)==DialogResult.Yes){DBHelpDBhelp=newDBHelp();SqlConnectioncon=newSqlConnection(DBhelp.constr);stringsql=string.Format("deletefromCoursetablewhereID='{0}'",label6.Text);SqlCommandcom=newSqlCommand(sql,con);con.Open();intresult=com.ExecuteNonQuery();if(result>0){MessageBox.Show("刪除成功");Datashow();}else{MessageBox.Show("刪除失敗");}con.Close();}}catch(Exceptionex){MessageBox.Show("出錯了?。?+ex.ToString());}}}}G:\102001205和坤\學(xué)生成績管理系統(tǒng)\學(xué)生成績管理系統(tǒng)\Coursetablesel.csprivatevoidCoursetablesel_Load(objectsender,EventArgse){DBHelpDBhelp=newDBHelp();SqlConnectioncon=newSqlConnection(DBhelp.constr);stringsql1="selectdistinctTimefromCoursetable";stringsql2="selectCnamefromCourseInfo";stringsql3="selectClassidfromClassInfo";SqlDataAdaptersda=newSqlDataAdapter(sql1,con);SqlDataAdaptersda1=newSqlDataAdapter(sql2,con);SqlDataAdaptersda2=newSqlDataAdapter(sql3,con);con.Open();DataSetds=newDataSet();sda.Fill(ds,"a");sda1.Fill(ds,"b");sda2.Fill(ds,"c");foreach(DataRowaRowinds.Tables[0].Rows){comboBox1.Items.Add(aRow[0].ToString().Trim());}foreach(DataRowaRowinds.Tables[1].Rows){comboBox5.Items.Add(aRow[0].ToString().Trim());}foreach(DataRowaRowinds.Tables[2].Rows){comboBox3.Items.Add(aRow[0].ToString().Trim());}con.Close();}privatevoidbutton1_Click(objectsender,EventArgse)//查詢{DBHelpDBHelp=newDBHelp();SqlConnectioncon=newSqlConnection(DBHelp.constr);con.Open();stringsql="selectTime,Termid