Search Search

#1 worldwide
FREE Coding Lessons
since 1996
   THE BEST WAY to learn ASP & Asp.net!
Advertise Here!
click for details 		Credits Host:
DiscountASP.net 		Server Admin:
The "Team" 		Contact Info.
Charles M. Carroll
my Blog
[prev. Lesson]  Essential Commercial Components
     [next Lesson]  ASPDB: Editing, Adding Data

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

<Test Script Below>


<% 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

<Test Script Below>


<% 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>

There are many worthy charities!!. But perhaps help starving children in Africa or South America AND help Charles too. a $5 tip buys him lunch at McDonalds, a $20 tip buys his kid Hitoshi a new computer game, a $39 tip buys his daughter Michiko a few nice outfits. See our donor list.