|
ASPDB: Databases with No
Work!
This page demonstrates the capabilities how
the third party component ASPDB from http://www.aspdb.com
makes database programming simple. Here we will show the code to display a
gorgeous table of the customers database just be starting the component and setting a few properties:
filename=/learn/test/aspdb1.asp
<% response.buffer=true %>
<HTML>
<Head><Title>ASPdb1.asp</Title></Head>
<%
Set MyDb = Server.CreateObject("ASPdb.Pro")
MyDb.dbUnit = 1000
MyDb.dbMDB=Server.MapPath("/learn/test/nwind.mdb")
MyDb.dbColor = "11"
MyDb.dbGridTableTag = "border=3"
MyDb.dbMode= "Grid"
MyDb.dbSQL = "Select * FROM Customers"
MyDb.dbNavigationItem = "top, bottom, next, prev, filter"
MyDb.ASPdbPro
set myDB=nothing
%>
</BODY>
</HTML>
Now we will display publishers:
filename=/learn/test/aspdbpub.asp
<% response.buffer=true %>
<HTML>
<Head><Title>ASPdb1.asp</Title></Head>
<%
Set MyDb = Server.CreateObject("ASPdb.Pro")
MyDb.dbUnit = 1000
MyDb.dbMDB=Server.MapPath("/learn/test/biblio.mdb")
MyDb.dbColor = "11"
MyDb.dbGridTableTag = "border=3"
MyDb.dbMode= "Grid"
MyDb.dbSQL = "Select * FROM Publishers"
MyDb.dbNavigationItem = "top, bottom, next, prev, filter"
MyDb.ASPdbPro
set myDB=nothing
%>
</BODY>
</HTML>
|