数据库应用系统实例

淮海工学院计算机工程学院实验报告书

课程名：数据库原理及应用

题目：实验七数据库应用系统实例

班级：D计算机081

学号：

姓名：

一、实验目的

开发学生学籍管理系统小型数据库应用系统数据库连接、数据操程作序编写，熟练使用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.Tables[0];

SRow = STable.NewRow();

SRow["SNO"] = TextBox1.Text;

SRow["SNAME"] = TextBox2.Text;

SRow["AGE"] = Convert.ToInt16(TextBox3.Text);

SRow["SEX"] = TextBox4.Text;

SRow["DNAME"] = TextBox5.Text;

STable.Rows.Add(SRow);

mySqlDA.Update(myDS);

GridView1.DataSource = myDS.Tables[0].DefaultView;

GridView1.DataBind();

myConnection.Close();

}

}