ch15-03-06.aspx

来自「深入浅出ASP.NET程序设计-源代码 书籍语言: 简体中文 」· ASPX 代码 · 共 24 行

ASPX
24
字号
<%@ Import NameSpace="System.Data" %>
<%@ Import NameSpace="System.Data.OleDb" %>
<% Response.Expires = 0 %>
<Html>
<Head>
<Title>Ch15-03-06.aspx SELECT表达式的Top关键字</Title>
<Script Language="VB" Runat="Server">
Sub Page_Load(Obj As Object, e As EventArgs)
Dim DSN As String, tSQL As String
' 设置使用联机字符串 
DSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
     Server.MapPath("/ASP/Chap14/ASP.NET网页数据库.mdb") & ";"
' 设置SQL语句
tSQL = "SELECT Top 3 UserName As 姓名, " & _
     "EMail As 电子邮件地址 FROM UserDatas ORDER BY UID"
ShowResultSet(DSN, tSQL)
End Sub
</Script>
<!-- #Include Virtual="ShowResultSet.inc" -->
</Head>
<Body>
</Body>
</Html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?