|
|
|
|
|
| | |
| |
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: Retrieving data from a table into a dynamically created form |
|
From: |
sai |
|
Date: |
6/21/1999 8:30:37 AM |
|
IP: |
202.54.68.238 |
i have a code with me which we used to retrieve the data dynamically from data base using ms access i hope this may help you
<html>
<body>
<center>
<font color="maroon">
<h2> Menu Items </h2></font>
<% Set con=Server.CreateObject("ADODB.Connection")
con.open"menu_dynamiDSN"
Set RS=con.Execute("select * from menu")
%>
<table border=1 bgcolor="lightyellow">
<tr>
<% For i=0 to RS.Fields.Count-1%>
<th bgcolor="green"><font color="yellow"><%=RS(i).Name %></font></th>
<% Next%>
</tr>
<% while Not RS.EOF %>
<tr align="center">
<% For i=0 to RS.Fields.count-1%>
<td><%=RS(i)%></td>
<% Next %>
</tr>
<%
RS.MoveNext
WEND
RS.close
con.close
%>
</table>
<center>
</body>
</html>
|
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
