開設(shè)外語或雙語講授類專業(yè)基礎(chǔ)課程-dotnet程序設(shè)計chapter

-DatabaseConnectionApril2Whatis?isapartofthe.NETFrameworkconsistsofasetofclassesusedtohandledataaccess3CreateaDatabaseConnection<%@ImportNamespace="System.Data"%><%@ImportNamespace="System.Data.OleDb"%>//ConnectionObjectOleDbConnectionconn=newOleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;DataSource="+Server.MapPath("wwwlink.mdb"));4CreateaDatabaseCommand//建立Command對象mandcmd=newmand("select*fromlinkwheregrade=5",conn);//打開數(shù)據(jù)庫連接conn.Open();5CreateaDataReader//建立DataReader對象OleDbDataReaderdr=cmd.ExecuteReader();6Displaythedata//下面開始顯示數(shù)據(jù)，先顯示標(biāo)題message.Text="<tablewidth='90%'border='1'><trbgcolor='#CDCDCD'><td>ID</td><td>名稱</td><td>網(wǎng)址</td><td>簡介</td><td>評分</td><td>提交時間</td></tr>";7while(dr.Read()){ message.Text+="<tr>"; message.Text+="<td>"+dr["link_id"]+"</td>"; message.Text+="<td>"+dr["siteName"]+"</td>"; message.Text+="<td>"+dr["URL"]+"</td>"; message.Text+="<td>"+dr["intro"]+"</td>";8

message.Text+="<td>"+dr["grade"]+"</td>";

message.Text+="<td>"+dr["submit_date"]+"</td>";

message.Text+="</tr>"; } message.Text+="</table>"; //關(guān)閉數(shù)據(jù)庫

conn.Close();}9DemoDefault.aspx1011Demoquery2.aspxprivatevoidPage_Load(objectsender,EventArgse){ //建立Connection對象 OleDbConnectionconn=newOleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;DataSource="+ Server.MapPath("wwwlink.mdb")); //建立Command對象 mandcmd=newmand("select*fromlink",conn); //建立DataAdapter對象 OleDbDataAdapteradp=newOleDbDataAdapter(cmd);12

//建立DataSet對象

DataSetds=newDataSet(); //填充DataSet對象

adp.Fill(ds,"ourlink"); //綁定數(shù)據(jù)對象

GridView1.DataSource=ds.Tables["ourlink"].DefaultView;GridView1.DataBind();}13DemoInsert2.aspxprivatevoidEnter_Click(objectsender,EventArgse){ //建立Connection對象

OleDbConnectionconn=newOleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;DataSource="+Server.MapPath("wwwlink.mdb")); //建立Command對象

stringstrSql;

strSql="InsertIntolink(sitename,URL,intro,grade,submit_date)Values('"+sitename.Text+"','"+URL.Text+"','"+intro.Text+"',"+Convert.ToInt16(grade.SelectedItem.Text)+",#"+System.DateTime.Now+"#)";

14mandcmd=newmand("InsertIntolink(sitename,URL,intro,grade,submit_date)Values('貓樸網(wǎng)站','','有許多有意思的事',4,#"+System.DateTime.Now+"#)",conn);15mandcmd=newmand(strSql,conn); //執(zhí)行操作，插入記錄 conn.Open();//打開數(shù)據(jù)庫 cmd.ExecuteNonQuery(); conn.Close();//關(guān)閉數(shù)據(jù)庫 message.Text="已經(jīng)成功添加，請自己打開數(shù)據(jù)庫查看結(jié)果,也可以繼續(xù)添加。";}16DemoDelete.aspxprivatevoidPage_Load(objectsender,EventArgse){ //建立Connection對象OleDbConnectionconn=newOleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;DataSource="+Server.MapPath("wwwlink.mdb")); //建立Command對象 mandcmd=newmand("DeleteFromlinkWherelink_id=21",conn);

17

//執(zhí)行操作，刪除記錄

conn.Open();//打開數(shù)據(jù)庫

cmd.ExecuteNonQuery(); conn.Close();//關(guān)閉數(shù)據(jù)庫

message.Text="已經(jīng)成功刪除，請自己打開數(shù)據(jù)庫wwwlink.mdb查看結(jié)果";}18DemoUpdate.aspxprivatevoidPage_Load(objectsender,EventArgse){ //建立Connection對象OleDbConnectionconn=newOleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;DataSource="+Server.MapPath("wwwlink.mdb")); //建立Command對象 mandcmd=newmand("UpdatelinkSetintro='一個不錯的網(wǎng)站',grade=4Wherelink_id=21",conn);19

//執(zhí)行操作，更新記錄

conn.Open();//打開數(shù)據(jù)庫

cmd.ExecuteNonQuery(); conn.Close();//關(guān)閉數(shù)據(jù)庫

message.Text="已經(jīng)成功更新，請自己打開數(shù)據(jù)庫wwwlink.mdb查看結(jié)果";}20如何在程序中連接sql數(shù)據(jù)庫usingSystem.Data.SqlClient;publicpartialclassDemoSqlServer:System.Web.UI.Page{protectedvoidButton1_Click(objectsender,EventArgse){//建立Connection對象SqlConnectionconn=newSqlConnection("server=.;uid=sa;pwd=sa;database=pubs;");

//建立Command對象mandcmd=newmand("select*fromauthors",conn);//建立DataAdapter對象SqlDataAdapteradp=newSqlDataAdapter(cmd);

21

//建立DataSet對象

DataSe