How to use ASP & Oracle List Rows Data From Table

Author: admin | Posted: 24-04-2010 | Category: ASP & Oracle

How to use ASP & Oracle List Rows Data From Table This is tutorial asp developers how to using ASP connect to Oracle and query data from table will be show result to html table.

ShotDev Focus:
- ASP & Oracle (Get data from table)

Example

asp_oracle_list_data.asp


<% Option Explicit %>
<html>
<head>
<title>ShotDev.Com Tutorial</title>
</head>
<body>
<%

Dim Conn,strSQL,objRec
Set Conn = Server.Createobject("ADODB.Connection")
Conn.Open "Driver={Oracle in OraHome92};DBQ=TCDB;UID=myuser;PWD=mypassword;"
strSQL = "SELECT * FROM CUSTOMER "
Set objRec = Server.CreateObject("ADODB.Recordset")
objRec.Open strSQL, Conn, 1,3
%>
<table width="600" border="1">
<tr>
<th width="91"> <div align="center">CustomerID </div></th>
<th width="98"> <div align="center">Name </div></th>
<th width="198"> <div align="center">Email </div></th>
<th width="97"> <div align="center">CountryCode </div></th>
<th width="59"> <div align="center">Budget </div></th>
<th width="71"> <div align="center">Used </div></th>
</tr>
<%
While Not objRec.EOF
%>
<tr>
<td><div align="center"><%=objRec.Fields("CUSTOMERID").Value%></div></td>
<td><%=objRec.Fields("NAME").Value%></td>
<td><%=objRec.Fields("EMAIL").Value%></td>
<td><div align="center"><%=objRec.Fields("COUNTRYCODE").Value%></div></td>
<td align="right"><%=objRec.Fields("BUDGET").Value%></td>
<td align="right"><%=objRec.Fields("USED").Value%></td>
</tr>
<%
objRec.MoveNext
Wend
%>
</table>
<%
objRec.Close()
Conn.Close()
Set objRec = Nothing
Set Conn = Nothing
%>
</body>
</html>

Create a asp file and save to path root-path/myasp/

Run
http://localhost/myasp/asp_oracle_list_data.asp

Screenshot

.
.
.
Download this script.