How to use ASP & Oracle List Rows Data From Table (ODBC)

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

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

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

Example

asp_oracle_odbc.asp


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

Dim Conn,strSQL,objRec
Set Conn = Server.Createobject("ADODB.Connection")
Conn.Open "mydatabase","sa" , ""
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_odbc.asp

Screenshot

.
.
.
Download this script.