数据库应用系统实例.doc

淮海工学院计算机工程学院实验报告书课程名： 数据库原理及应用 题 目： 实验七 数据库应用系统实例 班 级： D计算机081 学 号： 姓 名： 评语：成绩： 指导教师： 批阅时间： 年 月 日 数据库原理及应用实验报告 - 7 -一、实验目的开发学生学籍管理系统小型数据库应用系统数据库连接、数据操程作序编写，熟练使用Microsoft Visual Studio 2005开发平台。二、实验内容和要求1后台为SQL server2000,2前台为面向对象编程语言（可选择）3完成数据库连接4完成对前面实验所建立的studb109学籍数据库中的数据通过应用系统界面进行更新和查询等操作。三、实验步骤和实验结果1连接SQL Server的数据库访问编程实例。编写一个应用程序来连接数据库名为studb109的SQL Sever数据库，并根据连接结果输出一些信息。（1）.运行Microsoft Visual Studio 2005（2）.新建网站（3）.设计网站using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;namespace web public partial class _Default : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) protected void Button1_Click(object sender, EventArgs e) try SqlConnection coon = new SqlConnection(); coon .ConnectionString = Server =localhost; uid = sa;pwd=; database=studb109; coon .Open (); Label1 .Text =连接成功; catch Label1 .Text =连接失败; 设计界面运行结果2.读取和操作数据using System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class _Default : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) protected void Button1_Click(object sender, EventArgs e) try string createdb = use studb109 Select count(*)from S9; string ConnectionString = server = localhost; uid=sa;pwd=; SqlConnection conn = new SqlConnection(); conn.ConnectionString = ConnectionString; SqlCommand cmd = new SqlCommand(createdb, conn); conn.Open(); string number = cmd.ExecuteScalar().ToString(); conn.Close(); Label2.Text = number; catch Label2.Text = 查询失败; 设计界面运行结果3.使用数据集在数据库studb109的S9表中插入一条新纪录。using System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class _Default : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) protected void Button1_Click(object sender, EventArgs e) string SQL = use studb109 select * from S9; string myStr = server=localhost;database=studb109;uid=sa;pwd= ; SqlConnection myConnection = new SqlConnection(myStr); myConnection.Open(); SqlDataAdapter mySqlDA = new SqlDataAdapter(SQL, myConnection); SqlCommandBuilder mySqlCB = new SqlCommandBuilder(mySqlDA); DataSet myDS = new DataSet(); DataTable STable; DataRow SRow; mySqlDA.Fill(myDS); STable = myDS.Tables0; SRow = STable.NewRow(); SRowSNO = TextBox1.Text; SRowSNAME = TextBox2.Text; SRowAGE = Convert.ToInt16(TextBox3.Text); SRowSEX = TextBox4.Text; SRowDNAME = TextBox5.Text; STable.Rows.Add(SRow); mySqlDA.Update(myDS); GridView1.DataSource =