<;!DOCTYPE html>;
<;html>;
<;body>;
<%
连接 sett=Server.CreateObject("ADODB.Connection")
Conn.Provider="Microsoft.Jet.OLEDB.4.0"
Conn.Open(Server.Mappath("/db/northwind.mdb"))
rs sett=Server.CreateObject("ADODB.recordset")
rs.Open "Select * from Customers", conn
“第一个数字表示要复制的记录数”
'第二个数字表示从中开始的记录号
p=rs.GetRows(2,0)
response.write("<;p>;此示例返回前两条记录中第一列的值:<;/p>;")
response.write(p(0,0))
response.write("<;br>;")
response.write(p(0,1))
response.write("<;p>;此示例返回第一条记录中前三列的值:<;/p>;")
response.write(p(0,0))
response.write("<;br>;")
response.write(p(1,0))
response.write("<;br>;")
response.write(p(2,0))
rs.close
Conn.close
%>
<;/body>;
<;/html>;