1、面向?qū)ο蟪绦蛟O(shè)計綜合作業(yè)報告專業(yè)班級：類19-7班 姓名：劉學(xué)號:190702140509時間：2020.06.20一、作業(yè)題目要求:基于面向?qū)ο蟮某绦蜷_發(fā)思想，結(jié)合 C#W體應(yīng)用程序開發(fā)步驟，采用 ADO.NETW問數(shù)據(jù)庫相應(yīng)組 件，構(gòu)建完成一套學(xué)生成績系統(tǒng)。 學(xué)生成績系統(tǒng)是學(xué)校教務(wù)系統(tǒng)中不可缺少的一個子系統(tǒng)，它涉及到學(xué)生、課程等信息的結(jié)合。本套學(xué)生成績系統(tǒng)主要包括以下四個功能模塊，具體功能要求如下：1、登錄模塊登錄模塊提供用戶登錄界面，用戶輸入正確的用戶名和密碼后，則可進(jìn)入系統(tǒng)主窗口（即導(dǎo)航頁 面），從而可以選擇進(jìn)入相應(yīng)的子系統(tǒng)。2、學(xué)生信息模塊學(xué)生信息模塊主要用戶管理學(xué)生的基本信息，包括

2、學(xué)號、姓名、性別、年齡和所在系，能對學(xué)生信 息進(jìn)行添加、刪除和修改等操作。3、課程信息模塊課程信息模塊主要用于管理課程信息，包括課程號、課程名、學(xué)分和學(xué)時，能對課程信息進(jìn)行添 加、刪除和修改等操作。4、成績信息模塊成績信息模塊主要用于管理學(xué)生成績的錄入及查詢。二、數(shù)據(jù)庫設(shè)計:本節(jié)根據(jù)前面對學(xué)生成績系統(tǒng)的分析，介紹創(chuàng)建SqlServer數(shù)據(jù)庫、數(shù)據(jù)表以及數(shù)據(jù)表之間的關(guān)系的方法和步驟。2.1數(shù)據(jù)表結(jié)構(gòu)基于SQLServer2008數(shù)據(jù)庫管理系統(tǒng)構(gòu)建數(shù)據(jù)庫，根據(jù)作業(yè)題目要求共設(shè)計實現(xiàn)了四張表，分別是系統(tǒng)用戶表、學(xué)生信息表、課程信息表以及成績信息表。首先，我們登錄數(shù)據(jù)庫。如圖2-1圖2-1其次，在數(shù)據(jù)

3、庫中建表，如圖 2-2圖2-21、系統(tǒng)用戶表系統(tǒng)用戶表 tbl_User ”用于存放系統(tǒng)用戶的相關(guān)數(shù)據(jù)。其結(jié)構(gòu)如圖2.3所示。r列名數(shù)據(jù)類型允許null值節(jié) userNameovardnar(l-yftvB-ZEJlflci.aau. IrftHTLCLWIhfl WltdL 叼juri& Sfxt-nu m-ijwkhiThrd hriLif. fmi.UU-ihig %/1工 由 dti;yj-anel*lLimLj-raiiE l-rltw-l 13143n. ai*uhFWU -中工* m.Civzri-r l -n awtaJmacrlLia Em . crcdc1： l :，口jD

4、b! 1j; r . I.#|工 l;91甌 dit ui-mFttnxrnipiidu . tii JD*mdnWiff&r * n*m! .iipri iihF. *WgiCi，MdEfe2ai: rurr D*.uair idh倘哪則由看 dC4fEfiMtl31OCdl 0 ：“美愛森J aH-Dh EjaiEiaiE.世) I 1, I，I t m *d:* n*北 mdl川時I.masod. xjnr:afodj】t；tfrilK4MX-l0,。英&E1 W*bI D+fir/&h b rrfoirrtO.ijdLi$H mNah Hrpc：rti!-g 臺ifvllgH WCFW

5、undksrM.日二Workflow S t Vkul C* 4 v vshjj4i r*口口Ban姬如律遍如pmwor k .15正一住空.聯(lián)亭.0-t=Wirnrt同布 不Viwal干VJP-應(yīng)用哩學(xué)vai 二g|占EAM亨MX *AEP.NET Wb應(yīng)引怛?qū)iul七萃盟比Vkajl C.I*Vi-b-ial Jbilv-fflight fi,用在寧MbuR CSilwdFghf 絲與Viial Wird二后時出件充iiL電旄IVijal七璋室廠小斤欣麗悵/口可蛆力1VibajI C#SBC：trl+ E)fiR處訴sW C*用于副冠亙M Windows轉(zhuǎn)除用L可互歸 立釗L*fty5!

6、目君除讓05一口叫上1uj.rwbofa、ma0.1 siu id ZOT SPrajpwckB唱:亍右主田翎0Wi理左右上口 堂HS國代行三理|碗晶 | |用ifa圖4-32、默認(rèn)選中為解決方案創(chuàng)建目錄。3、在frmUserLogin.cs窗體上添加標(biāo)簽、文本框及按鈕，并對窗體屬性進(jìn)行修改，最終效果如下圖4-4：圖4-4學(xué)生信息管理窗體設(shè)計1、添加Windows窗體:在BOOKUITSXS 類庫中添加一個新的 Windows窗體frmStudent.cs。2、設(shè)計窗體外觀在窗體添加控件，調(diào)整各個控件的大小和位置，設(shè)計窗體的屬性；設(shè)計效果如圖4-5圖4-5課程信息管理窗體設(shè)計1、添加 Wind

7、ows窗體:在 BOOKUITSXS!庫中添力口一個新的 Windows 窗體 frmCourse.cs 。2、設(shè)計窗體外觀在窗體添加控件，調(diào)整各個控件的大小和位置，設(shè)計窗體的屬性；設(shè)計效果如圖4-6所示。圖4-64.4成績管理窗體設(shè)計1、添加 Windows窗體：所用部分控件- menuStripltoolStripl IstatusStripl在BOOKUITSX類庫中添力口一個新的 Windows窗體frmSC.cs。2、設(shè)計窗體外觀在窗體添加控件，調(diào)整各個控件的大小和位置，設(shè)計窗體的屬性；設(shè)計效果如圖4-7所示血接* ULI成徜錄入全部演出吉田臼絲；早牛牛E 三香同侑：1001查詢圖4

8、-74.5代碼設(shè)計登錄代碼namespace學(xué)生選課系統(tǒng)(public partial class Login : Form (public Login()InitializeComponent();private void btnOK Click( object sender, EventArgs e) ( try (DataSet ds = new DataSet ();DataBase db = new DataBase。；string sqlStr = string .Format( Select userPassword,userPurview from tbl User where

9、 UserName = 0, txtUserName.Text.Trim();ds = db.GetDataFromDB(sqlStr);if (ds.Tables0.Rows0.ItemArray0.ToString() = txtUserPassword.Text.Trim()/10判斷輸入的賬戶名密碼是否相同(frmMain ob_FrmMain = new frmMain ();LoginUser ._userName = this .txtUserName.Text.Trim();LoginUser ._userPassword = ds.Tables0.Rows0 userPass

10、word .ToString();LoginUser ._userPurview = ds.Tables0.Rows0 userPurview .ToString();ob_FrmMain.Show();this .Hide();Else/如果不相同，則提示錯誤(MessageBoxShow(用戶名或密碼錯誤，請重新輸入！); TOC o 1-5 h z txtUserName.Text =;txtUserPassword.Text =;txtUserName.Focus();Icatch(MessageBoxShow(用戶名或者密碼錯誤,錯誤)；private void btnClose_C

11、lick( object sender, EventArgs e) Application .Exit();private void txtUserPassword KeyDown( object sender, KeyEventArgs e) if (e.KeyCode = Keys.Enter)(btnOK_Click(sender, e);_ I主窗體代碼namespace學(xué)生選課系統(tǒng)(public partial class Login : Form(public Login()11(InitializeComponent();)private void btnOK_Click( ob

12、ject sender, EventArgs e)(try(DataSet ds = new DataSet ();DataBase db = new DataBase();/string sqlStr = Select userPassword,userPurview from tbl_User where UserName =+ txtUserName.Text.Trim() + ;string sqlStr = string .Format( Select userPassword,userPurview from tbl_User where UserName = 0, txtUser

13、Name.Text.Trim();ds = db.GetDataFromDB(sqlStr);if (ds.Tables0.Rows0.ItemArray0.ToString() = txtUserPassword.Text.Trim() frmMain ob_FrmMain = new frmMain ();/ClassShared.userInfo0 = txtUserName.Text.Trim();/ClassShared.userInfo1 = ds.Tables0.Rows0.ItemArray1.ToString();LoginUser .userName = this .txt

14、UserName.Text.Trim();LoginUser ._userPassword = ds.Tables0.Rows0 userPassword .ToString();LoginUser ._userPurview = ds.Tables0.Rows0 userPurview .ToString();ob FrmMain.Show();this .Hide();elseMessageBoxShow(用戶名或密碼錯誤，請重新輸入！);txtUserName.Text =;txtUserPassword.Text =;txtUserName.Focus(); catchMessageB

15、oxShow(用戶名或者密碼錯誤,錯誤)；private void btnClose Click(object sender, EventArgs e) Application .Exit();12private void txtUserPassword_KeyDown( object sender, KeyEventArgs e) (if (e.KeyCode = Keys.Enter)btnOK_Click(sender, e);學(xué)生信息管理代碼;namespace學(xué)生選課系統(tǒng) (public partial classfrmStudentForm(public frmStudent()I

16、nitializeComponent();void objOpen()/ i殳置標(biāo)簽為可輸入(txtNo.Enabled =true ;txtName.Enabled =true;1txtAge.Enabled =true ;cmbSex.Enabled =true ;txtDept.Enabled =trueJtxtNo.Focus();r void objClose()/設(shè)置標(biāo)簽為不可輸入txtNo.Enabled =false ;txtName.Enabled =false；txtAge.Enabled =false；cmbSex.Enabled =false；txtDept.Enabl

17、ed =false；void Clear()/ 清除標(biāo)簽中輸入的內(nèi)容L txtNo.Text =;txtName.Text =;txtAge.Text =;cmbSex.SelectedIndex=-1;txtDept.Text =void RefreshData() (string comStr;13DataBase db = new DataBase();DataSet ds = new DataSet ();comStr =select * from tbl_Student;ds = db.GetDataFromDB(comStr);if (ds = null )(MessageBoxS

18、how(沒有任何學(xué)生記錄！);) else(dgrdvStudent.DataSource = ds.Tables0;SetHeaderText();)void SetHeaderText()/將DataGridView數(shù)據(jù)控件(dgrdvStudent )中顯示的學(xué)生信息具有更好的表達(dá)效果，將各列的標(biāo)題改成相應(yīng)的中文。因此編寫SetHeaderText()方法，然后在修改dgrdvStudent控件的DataSource屬性后立即調(diào)用此方法，已達(dá)到修改列標(biāo)題的效果(dgrdvStudent.Columns0.HeaderText =學(xué)號；dgrdvStudent.Columns1.Heade

19、rText =姓名;dgrdvStudent.Columns2.HeaderText =性別;dgrdvStudent.Columns3.HeaderText =年齡；dgrdvStudent.Columns4.HeaderText =所在系;j)private void frmStudent_Load( object sender, EventArgs e) (objClose();RefreshData();)private void dgrdvStudent RowHeaderMouseClick( object sender, DataGridViewCellMouseEventArg

20、se) /選擇不同的學(xué)生記錄時，將學(xué)生信息顯示在相應(yīng)的文本框中int n = this .dgrdvStudent.CurrentCell.RowIndex;txtNo.Text =this .dgrdvStudent0, n.Value.ToString();txtName.Text =this .dgrdvStudent1, n.Value.ToString();cmbSex.SelectedItem =this .dgrdvStudent2, n.Value.ToString();txtAge.Text =this .dgrdvStudent3, n.Value.ToString();t

21、xtDept.Text =this .dgrdvStudent4, n.Value.ToString();)private void btnAdd Click( object sender, EventArgs e)/ 添加學(xué)生信息 (14tryif (btnAdd.Text.Trim()=添力口)btnAdd.Text =確定；objOpen(); Clear(); btnUpdate.Enabled =false ;btnDelete.Enabled =false ;btnClose.Enabled =false ;dgrdvStudent.Enabled =false ; else (

22、btnAdd.Text =添加；if (txtNo.Text.Trim() != null & txtName.Text.Trim() != null )/ 向數(shù)據(jù)庫中注入學(xué) 生信息 ( string sqlStr; sqlStr =insert into tbl_Student values (+ txtNo.Text.Trim() +,+txtName.Text.Trim() +,+ cmbSex.Text.Trim() +,+ txtAge.Text.Trim() +,+1txtDept.Text.Trim() +);DataBase db = new DataBase(); bool

23、b; b = db.UpdateDB(sqlStr); if (b = true ) (if ( MessageBoxShow(添力口成功！繼續(xù)添加嗎？，添力口， MessageBoxButtons.YesNo, MessageBoxIcon.Question) = DialogResult .Yes) (Clear(); | objOpen(); btnAdd.Text =確定；objClose();btnClose.Enabled =true ;btnDelete.Enabled =true ;btnUpdate.Enabled =true ;dgrdvStudent.Enabled =t

24、rue ; else(return ;15)elseMessageBoxShow(學(xué)號與姓名不能為空！);txtNo.Focus();btnAdd.Text =確定；) RefreshData(); txtNo.SelectAll(); ) ) catch ( Exception ex) MessageBoxShow(ex.Message);Clear();objClose();dgrdvStudent.Enabled =false ;)private void btnUpdate_Click( object sender, EventArgs e)/ 修改學(xué)生信息 tryif (btnUpd

25、ate.Text.Trim()=修改)btnUpdate.Text =確定；btnAdd.Enabled =false ;btnDelete.Enabled =false ;btnClose.Enabled =false ;txtName.Enabled =true ;txtAge.Enabled =true ;cmbSex.Enabled =true ;txtDept.Enabled =true ;txtName.Focus();) elsebtnUpdate.Text =修改；btnAdd.Enabled =true ;btnDelete.Enabled =true ;btnClose.E

26、nabled =true ;objClose();string sqlStr;16sqlStr =Update tbl_Student set Sname= + txtName.Text.Trim() +,Ssex=+cmbSex.Text.Trim() +,Sage=+ txtAge.Text.Trim() +,Sdept=+ txtDept.Text.Trim() + whereSno= + txtNo.Text.Trim() +;DataBase db = new DataBase。；db.UpdateDB(sqlStr);RefreshData();catch ( Exception

27、ex)private void btnDelete_Click( object sender, EventArgs e)/ 刪除學(xué)生信息tryif (txtNo.Text.Trim() !=)if ( MessageBoxShow(確定要刪除學(xué)生嗎？，刪除，MessageBoxButtons.YesNo, MessageBoxIcon.Question) = DialogResult .Yes)string sqlStr;sqlStr =delete from tbl Student where Sno=+ txtNo.Text.Trim() +DataBase db = new DataBa

28、se();db.UpdateDB(sqlStr);RefreshData();else -MessageBoxShow(沒有可刪除的記錄！，提示)；private void btnClose Click(object sender, EventArgs e)this .Hide();174.5.3課程信息管理代碼void SetHeaderText()/ 將DataGridView數(shù)據(jù)控件(dgrdvStudent )中顯示的學(xué)生信息具有更好的表達(dá)效果， 將各列的標(biāo)題改成相應(yīng)的中文。因此編寫SetHeaderText()方法，然后在修改dgrdvStudent控件的DataSource屬性后立

29、即調(diào)用此方法，已達(dá)到修改列標(biāo)題的效果dgrdvCourse.Columns0.HeaderText =課程號;dgrdvCourse.Columns1.HeaderText =課程名;dgrdvCourse.Columns2.HeaderText =學(xué)分;dgrdvCourse.Columns3.HeaderText =學(xué)期;dgrdvCourse.Columns4.HeaderText =學(xué)時;)private void frmCourse_Load( object sender, EventArgs e) ObjClose();RefreshData();private void dgrd

30、vCourse_RowHeaderMouseClick( object sender, DataGridViewCellMouseEventArgse)/選擇不同的課程記錄時，將課程信息顯示在相應(yīng)的文本框中int n = this .dgrdvCourse.CurrentCell.RowIndex;txtNo.Text =this .dgrdvCourse0, n.Value.ToString();txtName.Text =this .dgrdvCourse1, n.Value.ToString();txtCredit.Text =this .dgrdvCourse2, n.Value.To

31、String();cmbSemester.SelectedItem =this .dgrdvCourse3, n.Value.ToString();txtPeriod.Text =this .dgrdvCourse4, n.Value.ToString();)private void btnAdd_Click( object sender, EventArgs e)/ 添加課程信息 tryif (btnAdd.Text.Trim()=添力口)btnAdd.Text =確定；ObjOpen();Clear();18btnUpdate.Enabled =false ;btnDelete.Enabl

32、ed =false ;btnClose.Enabled =false ;dgrdvCourse.Enabled =false ;)else(btnAdd.Text =添加；if (txtNo.Text.Trim() != null & txtName.Text.Trim() != null )(string sqlStr; TOC o 1-5 h z sqlStr =insert into tbl_Course values (+ txtNo.Text.Trim() +,+txtName.Text.Trim() +,+ txtCredit.Text.Trim() +,+ cmbSemester

33、.Text.Trim() +,+txtPeriod.Text.Trim() +);DataBase db = new DataBase(); bool b;b = db.UpdateDB(sqlStr); if (b = true )if ( MessageBoxShow(添力口成功！繼續(xù)添加嗎？,添加MessageBoxButtons.YesNo, MessageBoxIcon.Question) = DialogResult .Yes) (Clear();ObjOpen();btnAdd.Text =確定；)else(ObjClose();btnClose.Enabled =true ;b

34、tnDelete.Enabled =true ;btnUpdate.Enabled =true ;dgrdvCourse.Enabled =true ;一 else( return ; elseMessageBoxShow(課程號與課程名不能為空！); txtNo.Focus();19btnAdd.Text =確定) RefreshData();|txtNo.SelectAll();)catch ( Exception ex)(MessageBoxShow(ex.Message);Clear();ObjClose();dgrdvCourse.Enabled =false)private voi

35、d btnUpdate_Click( object sender, EventArgs e)/ 修改課程信息 (try if (btnUpdate.Text.Trim()=修改)( btnUpdate.Text =確定；btnAdd.Enabled =false ;btnDelete.Enabled =false ;btnClose.Enabled =false ;txtName.Enabled =true ;txtPeriod.Enabled =true ;cmbSemester.Enabled =true ;txtCredit.Enabled =true ;txtName.Focus();

36、 一 else ( btnUpdate.Text =修改；btnAdd.Enabled =true ;btnDelete.Enabled =true ;btnClose.Enabled =true ;ObjClose(); string sqlStr; sqlStr =Update tbl Course set Cname= + txtName.Text.Trim()+,Credit= +txtCredit.Text.Trim() + ,Csemester= +cmbSemester.Text.Trim() + ,Cperiod= +txtPeriod.Text.Trim() +;DataBa

37、se db = new DataBase(); db.UpdateDB(sqlStr);|20RefreshData();)catch ( Exception ex)二MessageBoxShow(ex.Message);)private void btnDelete_Click( object sender, EventArgs e)/ 刪除課程信息 tryif (txtNo.Text.Trim() !=)if ( MessageBoxShow(確定要刪除課程嗎？，刪除，MessageBoxButtons .YesNo, MessageBoxIcon.Question) = DialogRe

38、sult .Yes)string sqlStr;sqlStr =delete from tbl_Course where Sno= + txtNo.Text.Trim() +DataBase db = new DataBase();db.UpdateDB(sqlStr); RefreshData();) else MessageBoxShow(沒有可刪除的記錄！，提示)； catch ( Exception ex)MessageBoxShow(ex.Message);private void btnClose Click( object sender, EventArgs e)this .Hi

39、de();匚b4.5.4成績錄入系統(tǒng)代碼namespace學(xué)生選課系統(tǒng)21( public partial class frmSC : Form ( public frmSC() 丁(InitializeComponent(); ) string selectcondition;private void frmSC_Load( object sender, EventArgs e) (DataBase dbStudent = new DataBase();DataSet dataSetStudent = new DataSet ();#region /提取學(xué)生信息string sqlStr =

40、 select Sno,Sname from tbl Student;dataSetStudent = dbStudent.GetDataFromDB(sqlStr); if (dataSetStudent.Tables0.Rows.Count 0) ( cmbStudent.Items.Clear();/ 清空for ( int i = 0; i 0) (cmbCourse.Items.Clear(); for ( int i = 0; i dataSetCourse.Tables0.Rows.Count; i+)/課程號(4位)-課程名cmbCourse.Items.Add(dataSet

41、Course.Tables0.RowsiCno.ToString() +- +dataSetCourse.Tables0.RowsiCname.ToString(); 一 ) #endregion private void btnGradeIn Click(object sender, EventArgs e) / 成績錄入22(try(if (cmbSelcondition.SelectedIndex = -1 | txtSelText.Text =)/ 當(dāng)標(biāo)簽為空時，錄入失敗(MessageBoxShow(錄入成功);cmbCourse.SelectedIndex = -1;cmbStud

42、ent.SelectedIndex = -1;txtGrade.Text =;)Else/滿足條件，將學(xué)生成績插入數(shù)據(jù)庫中string sqlStr = SELECTtbl SC.Sno,tbl Student.Sname,tbl SC.Cno,tbl Course.Cname,tbl SC.grade FROMtbl_Student,tbl_Course,tbl_SC where tbl_Course.Cno=tbl_SC.Cno and tbl_Student.Sno=tbl_SC.Sno and + selectcondition += + txtSelText.Text.Trim()

43、+;sqlStr =string .Format( SELECTtbl_SC.Sno,tbl_Student.Sname,tbl_SC.Cno,tbl_Course.Cname,tbl_SC.grade FROMtbl Student,tbl Course,tbl SC where tbl Course.Cno=tbl SC.Cno and tbl Student.Sno=tbl SC.Sno and0=1, selectcondition, this .txtSelText.Text.Trim();DataBase db = new DataBase。；DataSet dataSetSele

44、ct = new DataSet ();dataSetSelect = db.GetDataFromDB(sqlStr);if (dataSetSelect.Tables0.Rows.Count = 0) MessageBoxShow(沒有符合條件的成績記錄！); else dgrdvResult.DataSource = dataSetSelect.Tables0;SetHeaderText();catch ( Exception ex)MessageBoxShow(ex.Message);private void btnSelect_Click( object sender, EventA

45、rgs e)/ 查詢課程號或者學(xué)號 try23if (cmbSelcondition.SelectedIndex=-1|txtSelText.Text=)( MessageBoxShow(請選擇查詢條件并輸入查詢值！); 口 else(/ string sqlStr = SELECTtbl_SC.Sno,tbl_Student.Sname,tbl_SC.Cno,tbl_Course.Cname,tbl_SC.grade FROMtbl Student,tbl Course,tbl SC where tbl Course.Cno=tbl SC.Cnoand tbl Student.Sno=tbl

46、 SC.Snoand +selectcondition + = + txtSelText.Text.Trim() + ;string sqlStr = string .Format( SELECTtbl SC.Sno,tbl Student.Sname,tbl SC.Cno,tbl Course.Cname,tbl SC.grade FROM tbl_Student,tbl_Course,tbl_SC where tbl_Course.Cno=tbl_SC.Cno and tbl_Student.Sno=tbl_SC.Sno and 0=1, selectcondition, this .tx

47、tSelText.Text.Trim();DataBase db = new DataBase。； DataSet dataSetSelect = new DataSet (); dataSetSelect = db.GetDataFromDB(sqlStr);if (dataSetSelect.Tables0.Rows.Count = 0)MessageBoxShow(沒有符合條件的成績記錄！);elsedgrdvResult.DataSource = dataSetSelect.Tables0;SetHeaderText();catch ( Exception ex)MessageBoxS

48、how(ex.Message); Ivoid SetHeaderText()/ 將DataGridView數(shù)據(jù)控件(dgrdvStudent )中顯示的學(xué)生信息具有更好的表達(dá) 效果，將各列的標(biāo)題改成相應(yīng)的中文。因此編寫SetHeaderText()方法，然后在修改dgrdvStudent控件的DataSource屬性后立即調(diào)用此方法，已達(dá)到修改列標(biāo)題的效果dgrdvResult.Columns0.HeaderText =學(xué)號;dgrdvResult.Columns1.HeaderText =姓名;dgrdvResult.Columns2.HeaderText =課程號;dgrdvResult.

49、Columns3.HeaderText =課程名;dgrdvResult.Columns4.HeaderText =成績;24private void cmbSelcondition_SelectedIndexChanged( object sender, EventArgsswitch (cmbSelcondition.SelectedIndex) case 0: selectcondition =tbl_SC.Sno;break; case 1: selectcondition =tbl_SC.Cno;break; private void btnSelAll_Click( object sender, EventArgs e)/ ；將 sc表中數(shù)據(jù)全部顯示 trystring sqlStr = string .Format( SELECTtbl SC.Sno,tbl Student.Sname,tbl SC.Cno,tbl Course.Cname,tbl SC.grade FROMtbl_Student,tbl_Course,tbl_SC where tbl_SC.Sno=tbl_Student.Sno and tbl_SC.Cno= tbl_Course.Cnoselectcondition, this .txtSelText.Text.Trim();