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

1、太原工業(yè)學(xué)院計算機(jī)工程系課程名稱C#出僉日期2015、6、21姓名r喇驗成績實驗名稱實驗四ADO、Net數(shù)據(jù)庫基本操作實驗?zāi)康眉耙?、掌握ADONet基本架構(gòu)，能夠通過Connection對象連接數(shù)據(jù)庫。2、掌握通過DataReader進(jìn)行數(shù)據(jù)查詢得基本萬法。3、掌握通過DataAdapter與DataSet進(jìn)行數(shù)據(jù)查詢彳導(dǎo)基本方法.4、掌握通過mand對象進(jìn)行數(shù)據(jù)操作得基本方法。5、能夠通過DataAdapter進(jìn)行數(shù)據(jù)庫操作。實驗環(huán)境MicrosoftVisua1Studio2010實驗內(nèi)容1 .設(shè)一個菜單系統(tǒng)；2 .建立一個數(shù)據(jù)庫，通過Connection對象連接數(shù)據(jù)庫。3 .通過Da

2、taAdaptcr與DataSet進(jìn)行數(shù)據(jù)查詢，通過mand對象進(jìn)行數(shù)據(jù)操作，通過DataAdapter進(jìn)行數(shù)據(jù)庫操作，實現(xiàn)對數(shù)據(jù)得增刪該查；4 .要求界的友好。算法描述及實驗步驟1 .設(shè)一個菜單系統(tǒng)界面;2 .建立數(shù)據(jù)庫information;3 .通過Connection對象連接數(shù)據(jù)庫；4 .通過DataAdapter與DataSet進(jìn)行數(shù)據(jù)查詢；調(diào)試過程及實驗結(jié)果添加菜品：查詢菜品02刪除菜品03總結(jié)通過本次實驗，我了解到：1.ADO、NET設(shè)計思想就是從數(shù)據(jù)庫中讀取數(shù)據(jù)到內(nèi)存中，構(gòu)成內(nèi)存中得一個數(shù)據(jù)庫。2. Connection對象：建立與特定數(shù)據(jù)源得連接3. mand對象：對數(shù)據(jù)源執(zhí)

3、行命令，公開Parameters,并且可以從ConnectiAdapteon在Transaction得范圍內(nèi)執(zhí)行4 .DataReader對象：從數(shù)據(jù)源中讀取只進(jìn)且只讀得數(shù)據(jù)流5 .DataAdapter對象：用數(shù)據(jù)源填充DataSet并解析更新,r就是數(shù)據(jù)提供程序與DataSet得接口Data附錄MenucsnamespaceForm1publicpartialclassmenu:Formstaticstringstr="server=localhost;UserId=root;password=;Database=information"MSqlConnectionmc

4、onn=newMSqlConnection(str);publicmenu()Initializeponent();privatevoidForm1Load(objcctsender,EventArgse)Stringsq1="select*fromjibenxinxi"MSqlDataAdapterda=newMSqlDataAdapter(sql,mconn)；DataSetds=newDataSet();da、Fill(ds,"information");dataGridView1、DataSource=ds;dataGridView1、DataM

5、ember="information"dataGridViewl、Columns0、HeaderText="菜號"dataGridViewl、Columns1、HeaderText="菜名"；dataGridView1、Columns2、HeaderText="價格"dataGridViewl、Columns3、Head©rText="類別dataGridViewl、Columns4、HeaderText=dataGridViewl、Co1umns5、HeaderText=mconn、Close

6、();”備注"備注”;Jprivatevoidbutton1_Click(objectsender,Enewaddmenu()、Visible=true；this、Hide();ventArgse)e)conn)Jprivatevoidbutton3_Click(objectsender,EventArgsstringno=textBox1、Text;if(no="")Stringsql1="Select*fromjibenxinxi"MSqlDataAdapterda=newMSqlDataAdapter(sqll,mDataSetds=ne

7、wDataSet();da、Fi11(ds,"emploees);dataGridView1、DataSource=ds;dataGridView1、DataMember="emploecs"meonn、Close();textBox1、Text=""e1sestringsql=string、Format("sclect*fromjibenxinxiwhereno='0'",no);MSq1DataAdaptermda=newMSqlDataAdapter(sql,mconn);DataSetds=newDa

8、taSct();mda、Fill(ds,"emploees");dataGridView1、DataSource=ds;dataGridView1、DataMlember="emploees"mconn、Close();tcxtBox1、Text=""privatevoidbutton2Click(objectsender,EventArgse)Stringname=dataGridView1、RowsdataGridView1、CurrentRowIndex、Cells1、Value、ToString();Stringsql=Str

9、ing、Format("de1etefromjibenxinxiwherename='0'",name);MSqlmandmsq1mand=newMSqlmand(sql,mconn);mconn、Open();if(msqlmand、ExecuteNonQuer()>0)MessageBox、Show("刪除成功！”)；Stringsql1="select*fromjibenxinxi"MSq1DataAdapterda=newMSqlDataAdapter(sqll,mconn);DataSetds=newDataSe

10、t();da、Fill(ds,"emploees");dataGridViewl、DataSource=ds;dataGridViewl、DataMemt)er="emploees"mconn、Close();AddmenucsnamespaceFormlpublicpartialc1assaddmenu：Formstaticstringstr="server=localhost;UserId=root;password=root;Database=information"MSqlConnectionmcon=newMSqlConne

11、ction(str);pub1icaddmenu()Initializeponent();privatevoidbuttonl_Click(objectsender,EventArgse)Stringsi=textBox1、Text;Strings2=textBox2、Text;Strings3=textBox3、Text;Strings4=textBox4、Text;Strings5=textBox5、Text;Strings6=textBox6、Text;stringconstr="server=locaIhost;UserId=root;password=;Database=i

12、nformation"MSqlConnectionmcon=newMSqlConnection(constr)；mcon、Open();stringsq1=string、Format("insertintojibenxinxivalues('0z,z1',z2/,'3','4','5/)”,si,s3,s,s4,s5,s6);MSqImandmcmd=newMSqlmand(sql,mcon);trif(memdExecuteNonQuer()>0)MessageBox、Show("添加6成功|!”);

13、this,Visible=false；newmenu()、Visible=true；catch(Exceptione1)Console>WWriteLine(e1、Message);mcon、Close();Test、csnamespaceTestclassProgramstaticvoidMain(stringargs)stringconstr="server=localhost;UserId=root;password=root;Database=information"MSqlConnectionmcon=newMSq1Connection(constr);mcon、Open();Stringsql="select*fromjibenxinxi"MSqlmandmcmd=newMSq1manc(sql,mcon);mcmdExecuteNonQuer();MSqlDataReadermsr=mcmd、ExecuteReader();trwhile(msr、Read()Conso1e、WriteLine("菜號：0菜名：1價格：2類別：3備注：4備注:5&quo