|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: search and display data from database |
|
From: |
Jordi |
|
Date: |
12/24/2003 5:26:27 AM |
|
IP: |
195.77.33.58 |
Your question is too general... You only need a system with an Microsoft IIS 7.0 that executes ASP.
The ASP code may open a connection to the database using ADO. You will use a code like this:
<%
set con = CreateObject("ADODB.Connection")
con.open strConnection
set rst = CreateObject("ADODB.RecordSet")
SQL = "SELECT * FROM Data "
rst.open SQL, con
while not rst.eof
'Show each record%>
Name: <%=rst("Name")%><br>
Surname: <%=rst("Surmane")%>
<%rst.movenext
wend
rst.close
%> |
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
