2014110637仁青拉初實(shí)驗(yàn)七

實(shí)驗(yàn)編號：07四川師大實(shí)驗(yàn)報告2016年6月12日計算機(jī)科學(xué)學(xué)院級06班實(shí)驗(yàn)名稱：ADO連接數(shù)據(jù)庫實(shí)現(xiàn)簡單數(shù)據(jù)操作姓名：仁青拉初學(xué)號：2014110637指導(dǎo)老師：____沈莉____實(shí)驗(yàn)成績:_____ 實(shí)驗(yàn)七ADO連接數(shù)據(jù)庫實(shí)現(xiàn)簡單數(shù)據(jù)操作實(shí)驗(yàn)?zāi)康募耙笤诟呒壵Z言中通過ADO或者ADO.NET連接SQLSERVER數(shù)據(jù)庫，做一些簡單應(yīng)用。實(shí)驗(yàn)內(nèi)容在高級語言中使用ADO控件(ADO.NET控件)或ADO對象(ADO.NET對象)連接SQLSERVER數(shù)據(jù)庫，實(shí)現(xiàn)對表格的基本操作，能與數(shù)據(jù)庫交互，包括數(shù)據(jù)查詢，添加，刪除和修改,實(shí)驗(yàn)報告中呈現(xiàn)程序代碼和效果圖。實(shí)驗(yàn)主要流程、基本操作或核心代碼、算法片段（該部分如不夠填寫，請另加附頁）建立一個C#窗體應(yīng)用程序，使用ADO.NET訪問數(shù)據(jù)庫

建立數(shù)據(jù)表createtabletest(namechar(10),citychar(10));插入數(shù)據(jù)insertintotestvaluse('WW','Paris');實(shí)現(xiàn)原理：

publicvoidbutton1_Click(objectsender,EventArgse){stringreadSql="selectname,cityfromtest";stringconnectString=System.Configuration.ConfigurationSettings.AppSettings["DB"];SqlConnectionconnection=newSqlConnection(connectString);SqlCommandcommand=newSqlCommand(readSql,connection);connection.Open();SqlDataReaderreader=command.ExecuteReader();Book.CControl.AddListViewByDataReader(this.listView1,reader);connection.Close();}添加記錄:實(shí)現(xiàn)原理：privatevoidbutton1_Click(objectsender,EventArgse){nameStr=this.textBox1.Text;cityStr=this.textBox2.Text;stringinsertSql=string.Format("INSERTINTOtest(name,city)VALUES('{0}','{1}')",newobject[]{nameStr,cityStr});Console.WriteLine(insertSql);stringconnectString="server=localhost;integratedsecurity=sspi;database=db";SqlConnectionconnection=newSqlConnection(connectString);SqlCommandcommand=newSqlCommand(insertSql,connection);connection.Open();intcount=command.ExecuteNonQuery();connection.Close();f.button1_Click(null,null);this.Close();}（源自百度）?刪除記錄實(shí)現(xiàn)原理privatevoidbutton1_Click(objectsender,EventArgse){stringwhere=comboBox1.Text;stringvalue=textBox1.Text;stringdelectSql=string.Format("DELETEfromtestwhere{0}='{1}'",newobject[]{where,value});stringconnectString="server=localhost;integratedsecurity=sspi;database=db";SqlConnectionconnection=newSqlConnection(connectString);SqlCommandcommand=newSqlCommand(delectSql,connection);connection.Open();intcount=command.ExecuteNonQuery();connection.Close();f.button1_Click(null,null);this.Close();}（源自百度）?修改記錄實(shí)現(xiàn)原理

privatevoidbutton1_Click(objectsender,EventArgse){stringwhere=comboBox1.Text;stringvalue_origal=textBox1.Text;stringvalue_modify=textBox2.Text;stringdelectSql=string.Format("UPDATEtestSET{0}='{1}'where{0}='{2}'",newobject[]{where,value_modify,value_origal});stringconnectString="server=localhost;integratedsecurity=sspi;database=db";SqlConnectionconnection=newSqlConnection(connectString);SqlCommandcommand=newSqlCommand(delectSql,connection);connection.Open();intcount=command.ExecuteNonQuery();connection.Close();f.button1_Click(null,null);this.Close();}（源自百度）實(shí)驗(yàn)結(jié)果的分析與評價（該部分如不夠填寫，請另加附頁）通過本次實(shí)驗(yàn)了解ADO.NET，還不是特別的熟悉，所在運(yùn)用上還有一定的困難，需要多去看一些與高級語言相關(guān)的書籍，讓自己能夠更好的掌握高級語言，ADO.NET互操作性、可維護(hù)性、可編性、性能優(yōu)化、可伸縮性等優(yōu)點(diǎn)，ADO.NET應(yīng)用程序都使用對數(shù)據(jù)的不連接