2014110637仁青拉初实验七

1、2014110637仁青拉初实验七实验编号：_07_ 四川师大实验报告 2016年_6_月V2日计算机科学学院 级06班 实验名称：ADO 连接数据库实现简单数据操作姓名：仁青拉初学号：2014110637 指导老师：沈莉_实验成绩:实验七ADO连接数据库实现简单数据操作一. 实验目的及要求在高级语言中通过ADO或者ADO.NET连 接SQL SERVER数据库，做一些简单应用。二. 实验内容在高级语言中使用ADO控件（ADO.NET控件） 或 ADO 对象（ADO.NET 对象）连接 SQLSERVER数据库，实现对表格的基本操作， 能与数据库交互，包括数据查询，添加，删除 和修改，实验报告

2、中呈现程序代码和效果图。三. 实验主要流程、基本操作或核心代码、算法 片段（该部分如不够填写，请另加附页）建立一个C#窗体应用程序，使用ADO.NET访问 数据库建立数据表create table test(name char(10),city char(10);插入数据insert into test valuse(WW，Paris);实现原理：public void butt on 1_Click( object sen der, Eve ntArgs e)string readSql = select name, city from test;stri ng conn ectStri n

3、g =System.C on figurati on. Con figurati on Sett ings .AppSett in gs DB;SqlConnection connection = new SqlConnection (connectString); SqlComma nd comma nd = new SqlComma nd (readSql, connection); conn ecti on. Ope n();SqlDataReader reader = comma nd.ExecuteReader();Book.CControl .AddListViewByDataRe

4、ader(this.listView1,reader); connection. Close();添加记录:r aj AddForm2丨 口 叵 肚、buttcnlCity HldEOnILL J-实现原理：private void button1_Click( object sender, EventArgs e)string insertSql = string .Format(INSERT INTOtest(name,city)VALUES(0,1), new object nameStr, cityStr );Con sole .WriteLi ne(i nsertSql);stri

5、ng conn ectStri ng = server = localhost; in tegrated security = sspi; database = db;SqlConnection connection = new SqlConnection (connectString);SqlComma nd comma nd = new SqlComma nd (in sertSql, conn ecti on); conn ecti on. Ope n();int count = comma nd.ExecuteN on Query();conn ecti on. Close();f.b

6、utto n1_Click( null, n ull);this.Close();（源自百度）删除记录呼 Forml- h .| 三回 S3修改记录CityLHew Yoirk实现原理private void button1_Click( object sender, EventArgs e)stri ng where = comboBox1.Text;stri ng value = textBox1.Text;string delectSql = string.Format(DELETE from test where 0=1, new object where, value );stri

7、ng conn ectStri ng = server = localhost; in tegrated security = sspi; database = db;SqlConnection connection = new SqlConnection (connectString);SqlComma nd comma nd = new SqlComma nd (delectSql, connection);conn ecti on. Ope n();int count = comma nd.ExecuteN on Query(); conn ecti on. Close();f.butt

8、on1_Click(null, null); this.Close();（源自百度）?修改记录：召Form!亠J二詈购FRangeWaneCity邂记录1实现原理Nt* Yorkprivate void button1_Click( object sender. EventArgs e)stri ng where = comboBox1.Text;stri ng value_origal = textBox1.Text;stri ng value_modify = textBox2.Text;string delectSql = string.Format(UPDATE test SET 0=

9、1 where 0=2, new object where, value_modify,value_origal );stri ng conn ectStri ng = server = localhost; in tegrated security = sspi; database = db;SqlConnection connection = new SqlConnection (connectString);SqlComma nd comma nd = new SqlComma nd (delectSql, connection);conn ecti on. Ope n();int co

10、unt = comma nd.ExecuteN on Query();conn ecti on. Close();f.butto n1_Click( null, n ull);this.Close();(源自百度)四. 实验结果的分析与评价(该部分如不够填 写，请另加附页)通过本次实验了解ADO.NET，还不是 特别的熟悉，所在运用上还有一定的困难，需要 多去看一些与高级语言相关的书籍，让自己能够 更好的掌握高级语言，ADO.NET互操作性、可 维护性、可编性、性能优化、可伸缩性等优点， ADO.NET应用程序都使用对数据的不连接访 问，因此它不会在较长持续时间内保留数据库锁 或活动数据库连接。