📄 ch16-01-02.aspx
字号:
<%@ Import NameSpace="System.Data" %>
<%@ Import NameSpace="System.Data.OleDb" %>
<% Response.Expires = 0 %>
<Html>
<Head>
<Script Language="VB" Runat="Server">
' 在这里设置联机字符串的内容
Sub Page_Load(Obj As Object, e As EventArgs)
Dim OBJConn As OleDbConnection
Dim OBJDataAdapter As OleDbDataAdapter
Dim DSN As String
Dim tSQL As String = "Select * From UserDatas"
DSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath("/ASP/Chap14/ASP.NET网页数据库.mdb") & ";"
OBJConn = New OleDbConnection(DSN)
OBJDataAdapter = New OleDbDataAdapter(tSQL, DSN)
' 声明DataSet对象
Dim OBJDataSet As DataSet = New DataSet()
' 将UserDatas表填入DataSet对象
OBJDataAdapter.Fill(OBJDataSet, "UserDatas")
' 声明DataTable、DataRow、DataRow对象
Dim OBJDataTable As DataTable
Dim OBJDataRow As DataRow
Dim OBJDataColumn As DataColumn
' 设置DataTable的表来源
OBJDataTable = OBJDataSet.Tables("UserDatas")
Response.Write("<Center><H2>显示DataSet对象的所有记录</H2>")
Response.Write("<Table Border=1>")
' 显示DataColumn每一个字段的名称
For Each OBJDataColumn In OBJDataTable.Columns
Response.Write("<TD>" & OBJDataColumn.ColumnName & "</TD>" )
Next
' 返回每一行数据列
For Each OBJDataRow In OBJDataTable.Rows
Response.Write("<TR>")
' 显示在数据列之中的每一个数据列
For Each OBJDataColumn In OBJDataTable.Columns
Response.Write("<TD>" & OBJDataRow(OBJDataColumn) & "</TD>" )
Next OBJDataColumn
Response.Write("</TR>")
Next OBJDataRow
Response.Write("</Table>")
OBJConn.Close()
End Sub
</Script>
</Head>
<Body>
</Body>
</Html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -