C#實(shí)驗(yàn)四數(shù)據(jù)庫基本操作C#實(shí)驗(yàn)四數(shù)據(jù)庫基本操作C#實(shí)驗(yàn)四數(shù)據(jù)庫基本操作xxx公司C#實(shí)驗(yàn)四數(shù)據(jù)庫基本操作文件編號：文件日期：修訂次數(shù)：第1.0次更改批準(zhǔn)審核制定方案設(shè)計(jì)，管理制度太原工業(yè)學(xué)院計(jì)算機(jī)工程系太原工業(yè)學(xué)院計(jì)算機(jī)工程系實(shí)驗(yàn)報(bào)告課程名稱C#班級實(shí)驗(yàn)日期姓名學(xué)號實(shí)驗(yàn)成績實(shí)驗(yàn)名稱實(shí)驗(yàn)四數(shù)據(jù)庫基本操作實(shí)驗(yàn)?zāi)康募耙?、掌握基本架構(gòu)，能夠通過Connection對象連接數(shù)據(jù)庫。2、掌握通過DataReader進(jìn)行數(shù)據(jù)查詢的基本方法。3、掌握通過DataAdapter和DataSet進(jìn)行數(shù)據(jù)查詢的基本方法。4、掌握通過Command對象進(jìn)行數(shù)據(jù)操作的基本方法。5、能夠通過DataAdapter進(jìn)行數(shù)據(jù)庫操作。實(shí)驗(yàn)環(huán)境MicrosoftVisualStudio2010實(shí)驗(yàn)內(nèi)容設(shè)計(jì)一個菜單系統(tǒng)；建立一個數(shù)據(jù)庫，通過Connection對象連接數(shù)據(jù)庫。通過DataAdapter和DataSet進(jìn)行數(shù)據(jù)查詢，通過Command對象進(jìn)行數(shù)據(jù)操作，通過DataAdapter進(jìn)行數(shù)據(jù)庫操作，實(shí)現(xiàn)對數(shù)據(jù)的增刪該查；要求界面友好。算法描述及實(shí)驗(yàn)步驟設(shè)計(jì)一個菜單系統(tǒng)界面；建立數(shù)據(jù)庫information；通過Connection對象連接數(shù)據(jù)庫；通過DataAdapter和DataSet進(jìn)行數(shù)據(jù)查詢；調(diào)試過程及實(shí)驗(yàn)結(jié)果添加菜品：查詢菜品02刪除菜品03總結(jié)通過本次實(shí)驗(yàn)，我了解到：設(shè)計(jì)思想是從數(shù)據(jù)庫中讀取數(shù)據(jù)到內(nèi)存中，構(gòu)成內(nèi)存中的一個數(shù)據(jù)庫。Connection對象：建立與特定數(shù)據(jù)源的連接Command對象：對數(shù)據(jù)源執(zhí)行命令，公開Parameters，并且可以從Connection在Transaction的范圍內(nèi)執(zhí)行DataReader對象：從數(shù)據(jù)源中讀取只進(jìn)且只讀的數(shù)據(jù)流DataAdapter對象：用數(shù)據(jù)源填充DataSet并解析更新，DataAdapter是數(shù)據(jù)提供程序與DataSet的接口附錄namespaceForm1{publicpartialclassmenu:Form{staticstringstr="server=localhost;UserId=root;password=;Database=information";MSqlConnectionmconn=newMSqlConnection(str);publicmenu(){InitializeComponent();}privatevoidForm1_Load(objectsender,EventArgse){Stringsql="select*fromjibenxinxi";MSqlDataAdapterda=newMSqlDataAdapter(sql,mconn);DataSetds=newDataSet();(ds,"information");=ds;="information";[0].HeaderText="菜號";[1].HeaderText="菜名";[2].HeaderText="價格";[3].HeaderText="類別";[4].HeaderText="備注";[5].HeaderText="備注";();}privatevoidbutton1_Click(objectsender,EventArgse){newaddmenu().Visible=true;();}privatevoidbutton3_Click(objectsender,EventArgse){stringno=;if(no==""){Stringsql1="Select*fromjibenxinxi";MSqlDataAdapterda=newMSqlDataAdapter(sql1,mconn);DataSetds=newDataSet();(ds,"emploees");=ds;="emploees";();="";}else{stringsql=("select*fromjibenxinxiwhereno='{0}'",no);MSqlDataAdaptermda=newMSqlDataAdapter(sql,mconn);DataSetds=newDataSet();(ds,"emploees");=ds;="emploees";();="";}}privatevoidbutton2_Click(objectsender,EventArgse){Stringname=[Stringsql=("deletefromjibenxinxiwherename='{0}'",name);MSqlCommandmsqlcommand=newMSqlCommand(sql,mconn);();if()>0){("刪除成功！！！");}Stringsql1="select*fromjibenxinxi";MSqlDataAdapterda=newMSqlDataAdapter(sql1,mconn);DataSetds=newDataSet();(ds,"emploees");=ds;="emploees";();}}}namespaceForm1{publicpartialclassaddmenu:Form{staticstringstr="server=localhost;UserId=root;password=root;Database=information";MSqlConnectionmcon=newMSqlConnection(str);publicaddmenu(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){Strings1=;Strings2=;Strings3=;Strings4=;Strings5=;Strings6=;stringconstr="server=localhost;UserId=root;password=;Database=information";MSqlConnectionmcon=newMSqlConnection(constr);();stringsql=("insertintojibenxinxivalues('{0}','{1}','{2}','{3}','{4}','{5}')",s1,s3,s,s4,s5,s6);MSqlCommandmcmd=newMSqlCommand(sql,mcon);tr{if()>0){("添加ó成功|！");=false;newmenu().Visible=true;}}catch(Exceptione1){;}();}}}namespaceTest{classProgram{staticvoidMain(string[]args){stringconstr="server=localhost;UserId=root;password=root;Database=information";MSqlConnectionmcon=newMSqlConnection(constr);();Stringsql="select*fromjibenxinxi";MSqlCommandmcmd=newMSqlCommand(sql,mcon);();MSqlDataReadermsr=();tr{while()){("菜號:{0}菜名:{1}價格:{2}類別:{3}備注:{4}備注:{5}",msr["no"],msr["name"],msr[