C#實(shí)驗(yàn)四數(shù)據(jù)庫基本操作

1、太原工業(yè)學(xué)院計(jì)算機(jī)工程系課程名稱C#實(shí)級驗(yàn)僉報(bào)牡驗(yàn)日期201 5、6、21姓名:孕號丿汕J人r實(shí)驗(yàn)成績實(shí)驗(yàn)名稱實(shí)驗(yàn)四 A DO、Net數(shù)據(jù)庫基本操作實(shí) 驗(yàn) 目 得 及 要 求1掌握A DO Net基本架構(gòu)，能夠通過 Conne cti o n對象連接數(shù)據(jù)庫。2、掌握通過D ata Re a d e r進(jìn)行數(shù)據(jù)查詢得基本方法。3、掌握通過 Da taAd a p ter與Dat aS et進(jìn)行數(shù)據(jù)查詢得基本方法4、掌握通過m and對象進(jìn)行數(shù)據(jù)操作得基本方法。5、能夠通過Data Ada pt e r進(jìn)行數(shù)據(jù)庫操作。實(shí) 驗(yàn) 環(huán) 境Mi c ro s of t Vi s ual St u dio

2、2010實(shí) 驗(yàn) 內(nèi) 容1. 設(shè)計(jì)一個(gè)菜單系統(tǒng)；2. 建立一個(gè)數(shù)據(jù)庫，通過Conn ection對象連接數(shù)據(jù)庫。3. 通過Data Ad apt e r與DataS e t進(jìn)行數(shù)據(jù)查詢，通過mand對象進(jìn)行數(shù)據(jù)操作，通過DataAda pt er進(jìn)行數(shù)據(jù)庫操作，實(shí)現(xiàn)對數(shù)據(jù)得增刪該查；4. 要求界面友好。算 法 描 述 及 實(shí) 驗(yàn) 步 驟1. 設(shè)計(jì)一個(gè)菜單系統(tǒng)界面；2. 建立數(shù)據(jù)庫in f ormatio n;3. 通過Co nnec t i on對象連接數(shù)據(jù)庫；4. 通過Da taAdapter與DataSet進(jìn)行數(shù)據(jù)查詢；調(diào) 試 過 程 及 實(shí) 驗(yàn) 結(jié) 果添加菜品：查詢菜品02刪除菜品03總

3、結(jié)通過本次實(shí)驗(yàn)，我了解到：1. ADO、NET設(shè)計(jì)思想就是從數(shù)據(jù)庫中讀取數(shù)據(jù)到內(nèi)存中，構(gòu)成內(nèi)存中得一個(gè)數(shù)據(jù)庫。2. Co nn ecti o n對象：建立與特定數(shù)據(jù)源得連接3. ma nd對象：對數(shù)據(jù)源執(zhí)行命令，公開Pa r am eters,并且可以從 Co nn ection在T ransaction4. Data R e a der5. D at aAdar就是數(shù)據(jù)提供程序與得范圍內(nèi)執(zhí)行對象:從數(shù)據(jù)源中讀取只進(jìn)且只讀得數(shù)據(jù)流 pter對象：用數(shù)據(jù)源填充 DataSet并解析更新,Dat aSe t 得接口Dat a A d a pteMe nucsn amespace Form1Ipub

4、 1 i c p arti a l c la s s me nu : Fo r mstati c str ing s tr = s er v e r=1o c a lh os t;U s er Id = ro ot;passwo rd =;Database=in f or mat i on” ；M SqlCo nne ct io n mconn = n ew MSq lC o nn e ctio n(st r);publicmenu ()tInit i a li z ep on en t ();p r ivatefv o id F or m 1 Lo ad (obj e ct s e n de

5、r,Ev entA rgs e)Strn g s q 1 = ”s ele c t * from jiben x inX i;MSq lDa ta A dapter da = n ew MSql Dat a A dapter (sql,mconn);DataS et ds = new Da ta S et ();d a、Fi 1 l (ds, inf orm a ti on );da t aGrid V ie w 1、D ataSou rc e = d s;dataG ridV ie w1、DataMember = info r mati o n;附dataGridView1 、Col u m

6、ns 0、Head er T e x t =”菜號附錄d a t aGr idView1、Columns1 、Hea derText=菜名;da ta Gr idV i ewl、Co lu m ns 2、Head erText =價(jià)格”；d a taGr i dVi ewl、C ol u mns3、HeaderText =”類別d ataGri d V i ew1、Co 1 u m ns4 、 Hea derText =”備注data Grid V iew1、Co 1 um ns5、Hea derT e x t =備注”Im co nn、Close ();Jp r i v a t ev oid

7、 butt on l _Click (obj ec t sende r , Ev ent Arg s e)n ewadd m enu ()、Vis i bl e = t r u e ;Jthis、Hide();priva te void b ut t on3_C lick ( o bject s ender, E ve ntArgse)str i ng n o = tex t Box1、T e xt ;i f(no =”)ISt r ing sql l = Se lec t * f r om j ibenxin xi;MS qlD at aAdap t e r da = new MSqlDat

8、aAdapter (sqll,mc onn);Da taSet ds = ne w Dat aSet ();da、Fi 11( ds, e m ploee s”);dat a GridVi ew 1、Dat aSo u r ce = ds;dataG r i d View 1、DataM em be r = empl o e es” ; me onn、C1os e();te xt Box 1、Text = ” ;e 1 sestr i ng s ql = s tring 、Format( ” s e lect * fro m j ib enxinxiw h e re n o = 0 , no)

9、;MS q 1 DataAd a pt e r m da = new MSqlData A da pt e r( s ql , mco nn);DataSe t ds = n ew Data Set ();mda、Fill (ds, emploees ” );dat a GridV i ew1、D ataSourc e = ds;d a taGr i dV iew1、DataM em ber = emplo e es; m e onn、C1o se();t e xtB o x1、T e xt =;pri v ate v o id b u tton 2 Cli e k( obj e c t se

10、nder,Ev ent A rg se)Str in g n ame= dataGr id View1、R o w s dataGr i dVi e w1、 Current R ow Index 、Cell s 1、V a 1u e、ToString ();St ri ng s ql = S t ri n g、For m at (de 1 ete fr o m j i ben x i n xi where name=0 , name);MSql m a n d msq 1m a n d = ne w MSqlm and (sql , mconn); me o nn、O pen ();if (m

11、 sq l man d、Exec u teNo nQ uer () 0)MessageB ox、Sh ow (刪除成功！ ！);St r ing sqll = s ele e t * from j ibe n xinxi ” ;MSq1 DataA d ap t e r d a = new MSqlDataA d ap t e r (sqll, mconn );Data Set ds = new DataSet ();da、F ill(ds , empl o ees);da t aG ridViewl 、D a t aSou r e e = ds;dat a GridViewl、Data M

12、ember =” empl o e es;mconn、C1o s e();Addmenu csnamespac e F ormlp u blic partial c 1 as s addme nu : Fo rmst a tic string str = ” server=l o calhos t; Use r Id = root ; passw o r d =r oot ; Da ta b ase=infor m ati on;MS qlC onne e tionmco n = n e w MS qlC o n n ectio n ( s tr);pu b 1 ic a d dmenu ()

13、In i ti a lizeponent( );str i n g cons t r = serv er =loc a Ihost ; Use r I d =root;passwor d = ;Databa se= inf o rm at MSqlConnecti o n mconi o n;=n e w MSql Con n eet ion ( e on str);mco n、Open();stri n g s ql = strin g、Forma t ( ins erti nt o jibenx i nx ivalues( 0 z ,z 1 , z2 3,4,5),s1, s3 , s,s

14、4 , s5, s 6 );MSq lman d mcmd =n e w MSqlm and(sql ,mcon);s e)pri v ate void button1Clic k (o b ject se nd e r, Eve nt Ar gStr i n gs1= t ex t Box1、T e xt ;S t r i ng s2=t e x tBox2、T ext;St ri n gs3=tex t Box3、Text;St ri ng s4=text B ox4、Text;Str i ng s5 =textB o x5、T e xt;Str ings 6=textBox 6、Te x

15、t ;t rif( me md Exe cute N on Que r ()0)Mes sage B ox、Show (添力口6成功 |! ”)；this、Vi s i bl e = f a l se ;n e w me nu ()、Visible = t r ue ;e atch (Exceptione1)Co ns ol e、W iteLi ne(e1 、Messa g e );m con、Clos e();Te s t、csnames pac e Testclass Prog ra ms tat i e v oid M a in( stri n g ar gs )stri ng con

16、str = serv e r=local h ost ; User Id=roo t;p as sword=ro o t;D ata b a se=i n form a tion ;MSqlCon ne e t i on mcon = new MSql Connecti o n(c o ns t r); m eo n、Op en ();S tring sq l = select * from jibenxi n xi” ;M Sql m a n d me md = new MS q l mand s ql ,mcon);mcmd Exe cu te NonQu er();MSqlDataRea der msr = mcmd、Execute Rea der ();trwhile (ms r、Rea d (