ADO连接数据库实验报告

第七章任务一实验目的：学习ASP.NET网页和SQLServer数据库建立连接实验要求：1.将ASP.NET网页和SQLServer数据库建立连接2.向学生数据库中的学生表中输入数据3.使用Response输出学生表中所有数据4.使用GridView控件输出学生表中的所有数据实验步骤：第一步：建立个数据库第二步：连接起来第三步：编写处理代码实验结果：详细代码：usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;usingSystem.Data.SqlClient;publicpartialclass_Default:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){}protectedvoidButton1_Click(objectsender,EventArgse){SqlConnectionSunCon=newSqlConnection("DataSource=djsw43;InitialCatalog=学生管理;IntegratedSecurity=True");SunCon.Open();stringStuSQL;StuSQL="INSERTINTO学生(学号,姓名,性别,籍贯,班级,电话)";StuSQL=StuSQL+"VALUES('"+TextBox1.Text+"','"+TextBox2.Text;StuSQL=StuSQL+"','"+TextBox3.Text+"','"+TextBox4.Text;StuSQL=StuSQL+"','"+TextBox5.Text+"','"+TextBox6.Text+"')";SqlCommandStuIns=newSqlCommand(StuSQL,SunCon);StuIns.ExecuteNonQuery();SunCon.Close();}protectedvoidButton2_Click(objectsender,EventArgse){Response.Redirect("sun7_1a.aspx");}protectedvoidButton3_Click(objectsender,EventArgse){Response.Redirect("sun7_1b.aspx");}}sun7_1a.aspx.cs代码：usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Collections;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;usingSystem.Data.SqlClient;publicpartialclasssun7_1:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){SqlConnectionSunCon=newSqlConnection("DataSource=djsw43;InitialCatalog=学生管理;IntegratedSecurity=True");SunCon.Open();stringStuSQL;StuSQL="SELECT学号,姓名,性别,籍贯,班级,电话FROM学生";SqlCommandStuIns=newSqlCommand(StuSQL,SunCon);SqlDataReaderSunDa=StuIns.ExecuteReader();while(SunDa.Read()){Response.Write(SunDa.FieldCount);Response.Write(SunDa.GetString(0)+"");Response.Write(SunDa.GetString(1)+"");Response.Write(SunDa.GetString(2)+"");Response.Write("<br/>");}SunCon.Close();}}sun7_1b.aspx.页面中插入GridView按钮代码：usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Collections;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;usingSystem.Data.SqlClient;publicpartialclasssun7_1b:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){SqlConnectionSunCon=newSqlConnection("DataSource=djsw43;InitialCatalog=学生管理;IntegratedSecurity=True");SunCon.Open();stringStuSQL;StuSQL="SELECT学号,姓名,性别,籍贯,班级,电话FROM学生";SqlCommandStuIns=newSqlComman