📄 adonet2.aspx

📁 《精通ASP.NET网络编程》附带实例

💻 ASPX

字号:

<!--
引入名字空间 
-->
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<html>
<Script Language=VB Runat=Server>
   Sub Page_Load(Sender As Object, e As EventArgs)
      Dim dtConn As OleDbConnection
      Dim dtCmd As OleDbDataAdapter
      dim dtSet As DataSet
      dim dtTable As DataTable
      dim iLoop, iNumRows As Integer
      dim sSQL As String
      sSQL = "Select * From 学生成绩表;"
     ' 建立数据库链接 
      dtConn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("Sample.mdb"))

      '用SQL语句建立一个Command对象
      dtCmd = New OleDbDataAdapter(sSql, dtConn)

      '用返回的结果填充DataSet
      dtSet = New DataSet
      dtCmd.Fill(dtSet)
      
      '建立一个DataTable对象，并赋值
      dtTable = New DataTable
      dtTable = dtSet.Tables(0)
      '查询dtTable有多少记录
       iNumRows = dtTable.Rows.Count
       Response.Write("语文成绩列表<br>")
       If iNumRows = 0 then
         Response.Write("对不起，数据库中没有记录!")
      Else
         Response.Write("<p>共有" & Cstr(iNumRows) & " 条记录.</p>")
'用For语句显示查询结果
         For iLoop = 0 To iNumRows - 1
             Response.Write(dtTable.Rows(iLoop).Item("语文")&"<br>")
         Next iLoop
      End If
      Response.Write("查询完毕。")   

      dtConn.Close

   End Sub
</Script>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -