ch15-05-01.aspx
来自「深入浅出ASP.NET程序设计-源代码 书籍语言: 简体中文 」· ASPX 代码 · 共 31 行
ASPX
31 行
<%@ Import NameSpace="System.Data" %>
<%@ Import NameSpace="System.Data.OleDb" %>
<% Response.Expires = 0 %>
<Html>
<Head>
<Script Language="VB" Runat="Server">
' 在这里设置联机字符串的内容
Dim DSN As String
Dim tSQL As String
' 用户单击“执行”按钮
Sub Button1_Click(Obj As Object, e As EventArgs)
Dim lRet As Boolean = False
DSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath("/ASP/Chap14/ASP.NET网页数据库.mdb") & ";"
tSQL = "Select Count(*) As 注册数据总数 From UserDatas"
ShowResultSet(DSN, tSQL)
End Sub
</Script>
<!-- #Include Virtual="/ASP/Chap15/ShowResultSet.inc" -->
<!-- #Include Virtual="/ASP/Chap15/OPCommand.inc" -->
</Head>
<Body>
<H2>执行SQL语言的聚合函数</H2>
<Form Method="Post" Runat="Server">
<asp:Button ID="Button1" Text="执行"
OnClick="Button1_Click" Runat="Server" />
<Span ID="Show1" Runat="Server" />
</Form>
</Body>
</Html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?