How to display a table (Access)

xiaoxiao2021-03-05  25

Prerequisites Using this process are to write the code for the database connection before calling.

General

<% Sub Table_Show (TableName)%>

<%

SET RS = Server.createObject ("AdoDb.Recordset")

SQL = "Select * from" & Tablename

RS.Open SQL, CONN, 1, 1

%>

<% for i = 0 to rs.fields.count-1%>

<% for i = 0 to rs.fields.count-1%>

<% = rs.fields (i) .Name%>

<% next%>

<% do while not rs.eof%>

<% = rs (i)%>

<% next%>

<% rs.movenext

loop

Rs.close

SET RS = NOTHING%>

<% end sub%>

转载请注明原文地址:https://www.9cbs.com/read-35913.html

New Post(0)
CopyRight © 2020 All Rights Reserved
Processed: 0.042, SQL: 9