recordsetsql.asp

来自「《动态网页设计基础教程》,胡杰,科学出版社」· ASP 代码 · 共 29 行

ASP
29
字号
<html>
<head><title>Connection对象应用实例</title></head>
<body>
<%
Dim db,rs
Set db=Server.CreateObject("ADODB.Connection")
db.Open "Dsn=pers"
Set rs=Server.CreateObject("ADODB.Recordset")
strSql="Select * From grade"
rs.Open strSql,db
Do While Not rs.Eof
      Response.Write rs("Id")&"  "&rs("name")&"  "&rs("English")&"  "&rs("Chinese")&"<br>"
   rs.MoveNext
Loop
rs.Close
Set rs=nothing
db.Close
Set db=nothing
%>
</body>
</html>







⌨️ 快捷键说明

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