在代码区开始处输入:ImportsSystem.DataImportsSystem.Data.OleDbAspx.Vb后台Page_l
oad事件处理代码:DimobjconnAsNewOleDbConnectionobjconn.ConnectionString="provider=Microsoft.jet.oledb.4.0;datasource="&;Server.MapPath("sample.mdb")objconn.Open()Dim
mysqlAsStringmysql="select*fromstu_info"DimmydaAsNewOleDbDataAdapter(mysql,objconn)DimmydasAsNewDataSetmyda.Fill(mydas,"学生信息表")DimmydvAsDataViewmydv=mydas.Tables("学生信息表").DefaultViewDataGrid1.DataSource=mydvDataGrid1.DataBind()objconn.Close()
4、编程实现页面功能如下:在前台页面添加一数据列表控件DataGrid(ID=DataGridEX),要求在页面加载过程中,该控件显示test.mdb数据库中Stu_info表的所有字段信息,编程完成Page_load事件处理过程。IfNotPage.IsPostBackThenDimobjconnAsNewOleDbConnectionobjconn.ConnectionString="Provider=Microsoft.JET.OLEDB.4.0;Datasource="&;Server.MapPath("test.mdb")DimmysqlAsStringmysql="select*fromStu_info"DimmydaAsNewOleDbDataAdapter(mysql,objconn)DimmydsAsNewDataSetmyda.Fill(myds,"学生信息表")DimmydvAsDataViewmydv=myds.Tables("学生信息表").DefaultViewDataGridEX.DataSource=mydvDataGridEX.DataBind()EndIfEndSub