📄 ch14-05-03.aspx
字号:
<%@ Page Language="VB" Debug="true" %>
<%@ 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 DSN As String, tSQL As String
Dim OBJConn As New OleDBConnection()
Dim OBJCmd As New OleDBCommand()
Dim strA As String
DSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath("ASP.NET网页数据库.mdb") & ";"
' 设置SQL语言的内容
tSQL = "Select * From UserDatas"
OBJConn = New OleDbConnection(DSN) ' 设置使用联机字符串
OBJConn.Open()
' 通过OleDbCommand对象并通过Connection对象，
' 执行SQL语言
OBJCmd = New OleDbCommand(tSQL, OBJConn)
' 声明OleDbDataReader对象
Dim OBJReader As OleDbDataReader
' 设置OleDbDataReader对象的数据源
OBJReader = OBJCmd.ExecuteReader()
Dim lRet As Boolean = True
Response.Write("<H2>用户注册信息</H2>")
Response.Write("<Table Border=1>")
Do Until Not lRet
' 输出表的字段名称
Response.Write("<Tr>")
Dim I As Integer
For I = 0 To OBJReader.FieldCount()-1
Response.Write("<Td>" & OBJReader.GetName(I) & "</Td>")
Next
Response.Write("</Tr>")
Do While OBJReader.Read()
' 输出每一条记录的内容
Response.Write("<Tr>")
For I = 0 To OBJReader.FieldCount()-1
Response.Write("<Td>" & OBJReader.GetValue(I) & "</Td>")
Next
Response.Write("<Tr>")
Loop
' 判断还有没有其他的表。如果还有的话，
' NextResult()方法的返回值是 True
lRet = OBJReader.NextResult()
Loop
Response.Write("</Table>")
OBJReader.Close()
OBJConn.Close()
End Sub
</Script>
</Head>
<Body>
</Body>
</Html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -