C與SQL數(shù)據(jù)庫(kù)學(xué)生成績(jī)管理系統(tǒng)完整代碼

1、數(shù)據(jù)庫(kù)技術(shù)及應(yīng)用項(xiàng)目設(shè)計(jì)報(bào)告學(xué)生成績(jī)管理系統(tǒng)姓名：Celia Yan2015-01-07一. 設(shè)計(jì)目的及意義在如今的高校日常管理中，學(xué)生成績(jī)管理系統(tǒng)是其中非常重要的一環(huán)，特別是當(dāng)前學(xué)校規(guī)模不斷擴(kuò)大，學(xué)生人數(shù)日益增加， 課程門類多，校區(qū)分散等實(shí)際情況，學(xué)生成績(jī)統(tǒng)計(jì)功能 越來(lái)越繁重，稍有疏忽就會(huì)出現(xiàn)差錯(cuò)。因此，學(xué)生成績(jī)管理系統(tǒng)更具有非常大的實(shí)際應(yīng)用意 義。在互聯(lián)網(wǎng)快速崛起的今天，改革傳統(tǒng)的手工錄入方式，公正，準(zhǔn)確，及時(shí)反映學(xué)生的信 息和成績(jī)的情況，以適應(yīng)信息時(shí)代的要求，是學(xué)生成績(jī)管理系統(tǒng)的一個(gè)新的理念。通過(guò)成績(jī)管理可以大大提高學(xué)校的工作效率。學(xué)生成績(jī)管理系統(tǒng)應(yīng)該完成以下兩個(gè)方面的內(nèi)容：學(xué)生檔案資料

2、的管理、學(xué)生成績(jī)的管理。通過(guò)學(xué)生成績(jī)管理系統(tǒng)可以做到信息的規(guī)范管理，科學(xué)統(tǒng)計(jì)和快速查詢、修改、增加、刪除等，減少管理方面的工作量。二. 主要功能該系統(tǒng)主要用于學(xué)校學(xué)生信息管理，總體任務(wù)是實(shí)現(xiàn)學(xué)生信息關(guān)系的系統(tǒng)化、規(guī)范化和自動(dòng)化，其主要任務(wù)是用計(jì)算機(jī)對(duì)學(xué)生信息進(jìn)行日常管理，如查詢、修改、增加、刪除，另 外還考慮到用戶登錄的權(quán)限，針對(duì)學(xué)生信息和權(quán)限登錄的學(xué)生成績(jī)管理系統(tǒng)。 本系統(tǒng)主要包括注冊(cè)管理、教師管理、學(xué)生信息查詢、添加、修改、刪除等部分。其主要功 能有：(1) 學(xué)生信息的添加，包括輸入學(xué)生基本信息和成績(jī)。(2) 學(xué)生信息的查詢，包括查詢學(xué)生的基本信息和成績(jī)。(3) 學(xué)生信息的修改，包括修改學(xué)

3、生基本信息和成績(jī)。(4) 學(xué)生信息的刪除，包括刪除學(xué)生基本信息和成績(jī)。(5) 登錄用戶密碼修改，用戶登錄到系統(tǒng)可進(jìn)行相應(yīng)的用戶密碼修改。(6) 管理員用戶對(duì)用戶名的管理，包括添加新用戶、刪除用戶。學(xué)生成績(jī)管理系統(tǒng)是典型的信息管理系統(tǒng)，其開發(fā)主要包括后臺(tái)數(shù)據(jù)庫(kù)的建立和維護(hù) 以及前端應(yīng)用程序開發(fā)兩個(gè)方面。對(duì)于前者要求建立起數(shù)據(jù)一致性和完整性強(qiáng)、數(shù)據(jù)安全性好的數(shù)據(jù)庫(kù)。對(duì)于后者則要求應(yīng)用程序功能完備，易使用。該管理系統(tǒng)我使用的是Microsoft Visual Studio 2012 及 Microsoft SQLServer 2008。系統(tǒng)功能流程圖學(xué)生成績(jī)管理系統(tǒng)教師管理系統(tǒng)登錄管理員系統(tǒng)圖2.1

4、 系統(tǒng)功能流程三. 數(shù)據(jù)庫(kù)設(shè)計(jì)3.1本系統(tǒng)的數(shù)據(jù)庫(kù)采用的是SQL Server2008 。該數(shù)據(jù)庫(kù)包括學(xué)生成績(jī)表、用戶登錄 表用于紀(jì)錄學(xué)生的基本信息數(shù)據(jù)庫(kù)表結(jié)構(gòu)如下：成績(jī)表物理結(jié)構(gòu)p DELL4-330342SQLE.ntfiCore "dboxjb*列名數(shù)據(jù)類型哀許Nui值學(xué)號(hào)char(10)|H|姓名|而餉B計(jì)算機(jī)同縮m口教據(jù)庫(kù)實(shí)用教程rt面向?qū)ο蟪绦蛟O(shè)計(jì)En高數(shù)r.tn英語(yǔ)B總分ht回圖3.1口結(jié)果上消息學(xué)號(hào)姓名計(jì)算機(jī)網(wǎng)絡(luò)融攜庫(kù)買用教程響寸象程序設(shè)訐高藏賣語(yǔ)總分12 季二即B2537896a23李三4527BS938Q31李一E5637G6S62046552&345就0

5、54劉四£278S98263foi HI II I5姬75S494K75077區(qū)七B2S531就的08弓RA6332818778c圖3.2用戶登錄表物理結(jié)構(gòu):DELL4-330S42SQLE.ntscore dbo.dlb列名教據(jù)類型允許Null值用戶名varcharO)n密碼var：har(50)B甥varchar(50).卜科目I vane har(5O)10圖3.3口滁_!消息用戶名密碼科目11234567B計(jì)算機(jī)網(wǎng)絡(luò)2屈顫23456789頗故鋸犀實(shí)用勒強(qiáng)2育思英G121M2S英語(yǔ)A曜平1235fi7B9頗面聞勺象程庠律肝s李一1234567B學(xué)生6孚二D0DM000字生S11

6、 _.J7李三3G07Q7QQ學(xué)生8制四030W200學(xué)生9D55600CM學(xué)生10泌1oeowiM學(xué)生11區(qū)七09140000宇生12張川BOOTOO&a學(xué)生13弓時(shí)L(K0CW9Q管理員14碰2DDSOOOOISA15a 瞄oa官理員圖3.43.2觸發(fā)器刪除DLB中的記錄時(shí)同時(shí)刪除 CJB中姓名相同的記錄USEstudentscoreGO/* Object:Trigger dbo.dlb_delete Script Date: 01/07/2015 12:42:17 */SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOALTERtrigger db

7、o .dlb_deleteon dbo .dlb after deleteasbegindeclare leib varchar(50)select leib='學(xué)生'from deleteddelete from cjbwhere 姓名 in (select 用戶名 from deleted)End3.3數(shù)據(jù)庫(kù)連接string constr = "Password=617804;Persist Security Info=True;User ID=ywj;InitialCatalog=studentscore;Data Source=YANJING” ; |SqlC

8、onnection conn = new SqlConnection (constr);string sqlstr = "select * from cjb" ;SqlCommanotmd = new SqlCommandsqlstr, conn);SqlDataReader reader = cmd.ExecuteReader();DataSet ds = new DataSet ();while (reader.Read()(string id = reader"學(xué)號(hào)".ToString();string name = reader"姓名&

9、quot;.ToString();MessageBoxShow(string .Format( "id=0,name=1, 學(xué)號(hào)，姓名”);)四. 系統(tǒng)實(shí)現(xiàn)4.1.登錄界面圖4.1該界面是學(xué)生成績(jī)管理系統(tǒng)的登錄界面，可以選擇作為學(xué)生，管理員或者教師身份登錄。每一個(gè)進(jìn)入系統(tǒng)的人都會(huì)看到當(dāng)前的時(shí)間，在登錄時(shí)只有用戶名，密碼，與身份相符合時(shí)才能進(jìn)入系統(tǒng)，否則登錄無(wú)法成功。using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawin

10、g;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;using System.Data.SqlClient;namespace WindowsFormsApplication1public partial class Form1 : Form static public string sn, sub;public Form1()InitializeComponent();Form2 fr2 = new Form2(); Form3 fr3 = new Form

11、3(); Form4 fr4 = new Form4();private void Form1_Load( object sender, EventArgs e)(timer1.Start();private void label1_Click( object sender, EventArgs e)(private void button1_Click( object sender, EventArgs e)(string constr= "Password=617804;Persist Security Info=True;UserID=ywj;Initial Catalog=s

12、tudentscore;Data Source=YANJING"SqlConnectionconn = new SqlConnection (constr);conn.Open();if (textname.Text ="" | textpassword.Text ="")MessageBoxShow（"信息不全，請(qǐng)不要遺漏信息！"）; |if (rbtnmanager.Checked)(string cstr = "select * from dlb where類別='管理員'and 用戶名=&#

13、39;"+ textname.Text.Trim() + "'and 密碼='"+ textpassword.Text.Trim() +""'SqlCommancfcomm = new SqlCommandcstr, conn);SqlDataReader dr = comm.ExecuteReader();if (dr.Read()(sn = textname.Text.Trim(); fr4.Show();this .Visible = false :;e(lseMessageBoxShow（"笞碼或用戶名

14、出錯(cuò)，請(qǐng)重新輸入！"）;textname.Text ="" ; textpassword.Text =""if (rbtnteacher.Checked)(string cstr = "select * from dlb where 類別='教師'and 用戶名='"+ textname.Text.Trim() + "'and 密碼='"+ textpassword.Text.Trim() +""'SqlCommancfcomm = ne

15、w SqlCommandcstr, conn);SqlDataReader dr = comm.ExecuteReader();if (dr.Read()(sn = textname.Text.Trim(); sub = dr.GetValue(3).ToString();fr3.Show(); this .Visible = false ; elseMessageBoxShow("密碼或用戶名出錯(cuò)，請(qǐng)重新輸入！");textname.Text ="" ; textpassword.Text =""if (rbtnstudent.Ch

16、ecked)string cstr = "select * from dlb where 類別='學(xué)生'and 用戶名='" + textname.Text.Trim() + "'and 密碼='"+ textpassword.Text.Trim() +""'SqlCommancComm = new SqlCommandcstr, conn);SqlDataReader dr = comm.ExecuteReader(); if (dr.Read() sn = textname.Text

17、.Trim(); fr2.Show();this .Visible = false ; else MessageBoxShow("密碼或用戶名出錯(cuò)，請(qǐng)重新輸入！");textname.Text ="" ; textpassword.Text =""conn.Close(); conn.Dispose();private void button2 Click(object sender, EventArgs e)Application .Exit(); |private void timer1 Tick(object sender, E

18、ventArgs e)label4.Text =”當(dāng)前時(shí)間："+ DateTime .Now.ToLongDateString() +"" +DateTime .Now.ToLongTimeString();4.2學(xué)生成績(jī)管理心 Form2詳汨信息分?jǐn)?shù)修改密碼逗出李二同學(xué)，歡迎你進(jìn)入成績(jī)管理系鄉(xiāng)當(dāng)前時(shí)間：2015年1月7日11:03:46圖4.2設(shè)計(jì)過(guò)程：此部分主要針對(duì)學(xué)生信息的管理，可以查詢學(xué)生的所有成績(jī)信息，實(shí)現(xiàn)成績(jī)的添加、刪除、修改、計(jì)算平均分等功能。還可以修改當(dāng)前用戶下的密碼。private void Form2 Load( object sender,

19、EventArgs e)Form1.sn + ”同學(xué)，歡迎你進(jìn)入成績(jī)管理系統(tǒng)!falsefalselabell.Text = timer1.Start();groupBox1.Visible =groupBox2.Visible =private void button1 Click(object sender, EventArgs e) private void button3_Click( object sender, EventArgs e)(/ string constr = "Password=null;Persist Security Info=True;UserID=B

20、INIANDOUKOUadministrator;Initial Catalog=studentscore;DataSource=BINIANDOUKOUSQLEXPRESS”;/SqlConnection conn = new SqlConnection(constr);/conn.Open();/SqlDataAdapter da = new SqlDataAdapter("Select * from cjb where姓名="+textBox1 .Text , conn);/DataSet ds = new DataSet();/da.Fill(ds, "u

21、sertable");/dataGridView1.DataSource =;private void toolStripButton1_Click( object sender, EventArgs e)(dataGridView1.Visible =true ; groupBox1.Visible = false ;groupBox2.Visible = false ;string constr ="Password=617804;Persist Security Info=True;UserID=ywj;Initial Catalog=studentscore;Dat

22、a Source=YANJING"SqlConnectionconn = new SqlConnection (constr);conn.Open();SqlDataAdapterda = new SqlDataAdapter ("select * from cjb where姓名='"+ Form1.sn.Trim() +，"" , conn); /-詳細(xì)信息DataSet ds = new DataSet (); da.Fill(ds,"usertable");dataGridViewl.DataSource =

23、 ds.Tables"usertable" .DefaultView;conn.Close(); conn.Dispose();private void toolStripButton2 Click(object sender, EventArgs e)(private void toolStripButton4 Click(object sender, EventArgs e)(groupBox1.Visible =true ;private void button1_Click_1( object sender, EventArgs e) (string constr

24、= "Password=617804;Persist Security Info=True;UserID=ywj;Initial Catalog=studentscore;Data Source=YANJING"SqlConnection conn = new SqlConnection (constr);conn.Open();if (textnpd.Text != textpassword.Text) (MessageBoxShow("密碼輸入有誤，請(qǐng)重新輸入");if (textnpd.Text = "" &&

25、textpassword.Text = "") ( MessageBoxShow(密碼不允許為空！"); if (textnpd.Text=textpassword.Text && textnpd.Text !="")(SqlCommancfcom = new SqlCommand "update dlb set密碼='"+textpassword.Text.Trim() +"'where 用戶名='"+ Form1.sn.Trim() +”,conn);if (c

26、om.ExecuteNonQuery() = 1)(MessageBoxShow("密碼更改成功");groupBox1.Visible =false ;conn.Close(); conn.Dispose();private void dataGridView1_CellContentClick( object sender, DataGridViewCe llE ventArgse)(privatevoid toolStripButton5_Click(objectsender,EventArgse)(this.Close(); Form1 l = new Form1(

27、); l.Visible =true ;privatevoid toolStripButton6_Click(objectsender,EventArgse)(/ string constr = "Password=null;Persist Security Info=True;UserID=BINIANDOUKOUadministrator;Initial Catalog=studentscore;Data Source=BINIANDOUKOUSQLEXPRESS”;/SqlConnection conn = new SqlConnection(constr);/conn.Ope

28、n();/SqlDataAdapter da = new SqlDataAdapter("Select * from cjb where姓名="+textBox1 .Text , conn);/DataSet ds = new DataSet();/da.Fill(ds, "usertable");/string s;/for(int i=2;i <=6;i+)/(/ if (int.Parse(ds.Tables"usertable".Rows0i.ToString() <60)/ s=int.Parse(ds.Tabl

29、es"usertable".Rows0i.ToString();/private void groupBox2_Enter( object sender, EventArgs e) (dataGridView1.Visible =false ; groupBox1.Visible = falseprivate void toolStripButton3_Click( object sender, EventArgs e) (groupBox2 .Visible=true ;string constr ="Password=617804;Persist Securi

30、ty Info=True;UserID=ywj;Initial Catalog=studentscore;Data Source=YANJING"SqlConnectionconn = new SqlConnection (constr);conn.Open();SqlDataAdapterda = new SqlDataAdapter ("Select * from cjb where姓名='"+Form1 .sn .Trim ()+”m , conn);DataSet ds =new DataSet ();da.Fill(ds,"userta

31、ble");int max=0,min=1001;double ave =0.0;for (inti=2;i <=6;i+)(if (int .Parse(ds.Tables "usertable" .Rows0i.ToString()>max)max=nt .Parse(ds.Tables "usertable" .Rows0i.ToString(); if(int .Parse(ds.Tables "usertable" .Rows0i.ToString()<min )min=int .Parse(ds

32、.Tables "usertable" .Rows0i.ToString();Itxthscore.Text=max.ToString();txtlscore.Text=min.ToString();txtall.Text=ds.Tables"usertable" .Rows0"總分".ToString();ave=int .Parse(ds.Tables"usertable" .Rows0"總分”.ToString()/(double )5;txtave.Text=ave.ToString();conn

33、.Close();conn.Dispose();privatevoid timer1_Tick(object sender, EventArgs e)(label2.Text=”當(dāng)前時(shí)間："+DateTime .Now.ToLongDateString()+DateTime.Now.ToLongTimeString();4.3教師管理界面圖4.3設(shè)計(jì)過(guò)程:此部分主要針對(duì)教師信息管理，可以查詢學(xué)生的所有成績(jī)信息，實(shí)現(xiàn)成績(jī)的添加、刪除、修 改、成績(jī)升序排序等功能。還可以修改當(dāng)前用戶下的密碼。private void button1 Click(object sender, EventAr

34、gs e) /查找ID=ywj;Initial Catalog=studentscore;Data Source=YANJING”string constr = "Password=617804;Persist Security Info=True;User5SqlConnection conn= new SqlConnection (constr);conn.Open();if (comboBox1.Text="學(xué)號(hào)")SqlCommandcm=newSqlCommand "select學(xué)號(hào)，"+Form1 .sub + "from

35、 cjbwhere 學(xué)號(hào)='"+ textBox1.Text+""' ,conn );if (cm.ExecuteScalar ()= null ) MessageBoxShow("用戶名不存在”); elseSqlDataAdapter da = new SqlDataAdapter ("select 學(xué),conn);號(hào),"+Form1.sub+ " from cjb where 學(xué)號(hào)='"+textBox1.Text+DataSet ds = new DataSet ();da.Fill

36、 (ds ,"chaxun");dataGridView1.DataSource=ds.Tables"chaxun" .DefaultView;if (comboBox1.Text="姓名")SqlCommanccm=new SqlCommand "select姓名,"+ Form1.sub + "fromcjb where 姓名='"+ textBox1.Text+""' ,conn );if (cm.ExecuteScalar()= null ) Mess

37、ageBoxShow("該用戶不存在"); elseSqlDataAdapter da = new SqlDataAdapter ("select 姓 名,"+Form1.sub + " from cjb where 姓名='"+ textBox1.Text +""' ,conn );DataSet ds = new DataSet ();da.Fill (ds,"table");dataGridView1.DataSource=ds.Tables"table"

38、; .DefaultView;conn.Close();conn.Dispose();private void textBox1_TextChanged( object sender, EventArgs e)groupBox3private void toolStripButton2 Click(object sender, EventArgs e) / 查找.Visible =false ; groupBox1.Enabled = true ; groupBox2.Enabled=false ;private void toolStripButton1 Click(object sende

39、r, EventArgs e)/所有成績(jī)groupBox3.Visible =true ;string constr = "Password=617804;Persist Security Info=True;UserID=ywj;Initial Catalog=studentscore;Data Source=YANJING"SqlConnection conn = new SqlConnection (constr);conn.Open();SqlDataAdapter da = new SqlDataAdapter ("select 學(xué)號(hào)，姓名,"

40、+ Form1.sub + " from cjb " ,conn);DataSet ds = new DataSet ();da.Fill(ds,"table");dataGridViewl .DataSource =ds.Tables "table" .DefaultView;conn.Close ();conn .Dispose(); private void button2_Click( object sender, EventArgs e) / 修改成績(jī) string constr = "Password=61780

41、4;Persist Security Info=True;User ID=ywj;Initial Catalog=studentscore;Data Source=YANJING"SqlConnection conn = new SqlConnection (constr);conn.Open();SqlCommandcom = new SqlCommand "update cjb set "+ Form1.sub + "='"+ textBox3.Text + "'where 姓名='"+ text

42、Box4.Text +""' , conn);if (com.ExecuteNonQuery() = 1)MessageBoxShow("修改成功");else MessageBoxShow("信息有誤，請(qǐng)重新輸入");conn.Close(); conn.Dispose(); private void toolStripButton3_Click( object sender, EventArgs e) / 修改 學(xué)生成績(jī)groupBox3 .Visible =false ; groupBox2.Enabled = true

43、 ;groupBox1.Enabled = false ; groupBox3.Visible = false ;private void textBox3_TextChanged( object sender, EventArgs e) private void groupBox2_Enter( object sender, EventArgs e)private void button3_Click( object sender, EventArgs e) / 確認(rèn)修改密碼 string constr = "Password=617804;Persist Security Inf

44、o=True;UserID=ywj;Initial Catalog=studentscore;Data Source=YANJING"SqlConnection conn = new SqlConnection (constr);conn.Open();if (txtnpd.Text != txtnpassword.Text) MessageBoxShow("兩次輸入密碼不一致，請(qǐng)重新輸入");if (txtnpd.Text ="" && txtnpassword.Text ="" ) MessageBoxS

45、how("密碼不允許為空，請(qǐng)輸入密碼");if (txtnpd.Text = txtnpassword.Text && txtnpd.Text !="")(SqlCommancfcom = new SqlCommand "update dlb set密碼='" +txtnpassword.Text.Trim() +"'where 用戶名='"+ Form1.sn.Trim() +""' , conn);if(com.ExecuteNonQuery(

46、) = 1)(MessageBoxShow("密碼更改成功");groupBox1.Visible =true ;conn.Close(); conn.Dispose();private void toolStripButton5_Click( object sender, EventArgs e)(groupBox4.Visible =true ; groupBox3.Visible =true ;dataGridView1.Visible =false ;private void toolStripButton4_Click(object sender,EventArg

47、s e)/升序排序(groupBox3.Visible =true ;string constr ="Password=617804;Persist Security Info=True;UserID=ywj;Initial Catalog=studentscore;Data Source=YANJING"SqlConnectionconn = new SqlConnection (constr);conn.Open();SqlDataAdapterda = new SqlDataAdapter ("select 學(xué)號(hào)，姓名,"+ Form1.sub+

48、" from cjb order by "+Form1.sub + "desc " , conn);DataSet ds =new DataSet ();da.Fill(ds,"table");dataGridView1.DataSource = ds.Tables"table" .DefaultView; |conn.Close(); conn.Dispose();private void toolStripButton6_Click( object sender, EventArgs e) ( this .Cl

49、ose(); Form1 l = new Form1(); l.Visible = true ;private void timer1_Tick( object sender, EventArgs e) (label8.Text ="當(dāng)前時(shí)間:"+ DateTime .Now.ToLongDateString() +DateTime .Now.ToLongTimeString();4.4管理員管理界面圖4.4設(shè)計(jì)過(guò)程：此部分主要針對(duì)管理員的，可以添加和刪除所有用戶的賬號(hào)和密碼。private void Form4_Load( object sender, EventArgs

50、 e) (timer1.Start();label1.Text =Form1.sn + ”管理員，歡迎進(jìn)入成績(jī)管理系統(tǒng)！"groupBox2.Enabled =false ;private void label1 Click(object sender, EventArgs e) private void radioButton1_CheckedChanged( object sender, EventArgs e) (if (radioButton1.Checked) ( groupBox2.Enabled = true ; txtkm.Enabled = true ; priva

51、te void radioButton2 CheckedChanged(object sender, EventArgs e)(if (radioButton2.Checked) ( groupBox2.Enabled = true ; txtkm.Enabled =false ; private void txtyhm_TextChanged( object sender, EventArgs e)""-;private void button2_Click( object sender, EventArgs e) (txtkm.Text = txtmm.Text = t

52、xtyhm.Text =private void button3 Click(object sender, EventArgs e)(this .Close(); Form1 l = new Form1(); l.Visible = true private void label5_Click( object sender, EventArgs e) (private void timer1 Tick(object sender, EventArgs e)(label5.Text =”當(dāng)前時(shí)間："+ DateTime.Now.ToLongDateString() +DateTime

53、.Now.ToShortTimeString();private void button1_Click( object sender, EventArgs e) (string constr = "Password=617804;Persist Security Info=True;UserID=ywj;Initial Catalog=studentscore;Data Source=YANJING”;SqlConnection conn = new SqlConnection (constr);conn.Open();if (radioButton1 .Checked )(Syst

54、em.Console .Out.WriteLine("");if (txtyhm .Text !="" &&txtmm .Text != "" && txtkm .Text !="")(SqlCommancfcom = new SqlCommand( "select * from dlb where用戶名='"+ txtyhm .Text .Trim ()+""' ,conn);if (com.ExecuteScalar ()

55、!=null ) ( MessageBox .Show ("用戶已存在");else(SqlCommandcm = new SqlCommand( "insert into dlb (用戶名，密碼，類別，科目)values ('"+ txtyhm .Text +"','"+ txtmm .Text +"',' 教師,'"+txtkm .Text +"')" ,conn );if (cm.ExecuteNonQuery ()=1)(MessageBoxShow(&q