Vise hele indholdet af databasetabel

Et eks på hele koden du kan rette database connection og tabel navn til:



<html>
<head></head>
<body>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.recordset") 
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& server.mappath("db5.mdb")

SQL = "SELECT * FROM gardere"
Set rs = Conn.Execute(SQL)

Response.Write "<table>"

'Udskriv kolonnenavne
if not rs.EOF then
  Response.Write "<tr>"
  for each f in rs.Fields
    Response.Write "<td>"
    Response.Write f.name
    Response.Write "</td>"
  next
  Response.Write "</tr>"
end if
'Udskriv indhold af kolonnerne
do while not rs.EOF
  Response.Write "<tr>"
  for each f in rs.Fields
    Response.Write "<td>"
    Response.Write f
    Response.Write "</td>"
  next
  Response.Write "</tr>"
  rs.MoveNext
loop

Response.Write "</table>"
Conn.Close

%>
</body>
</html>

Fuldstændig utestet.
Select * from tabel henter det hele så kan du bruge noget med
for i=1 to rs.fields.count
  Response.Write "Kolonnenavn: " & rs.Fields(i).Name
  Response.Write "Værdi: " & rs.Fields(i).Value
next

Hmm eagleeye du er nu hurtig :-)