|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
