|
|
|
|
|
| | |
| |
Active Server Pages ASP control controls class classes module script Scripts applet 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
