Following example, extracts all of the records in a database table and stores into a 2-dimensional array. This gives you an advantages to modify and work on data.
In the tutorials so far we have learned from connecting to the database via ASP to inerting, updating and selecting data from the database.
The area we waste a lot of database time is when we show records to the user and in the mean time keep our database connection open. Following example illustrates this point :
I actually had some trouble naming this article. I started out with something like "It Don't Mean A Thing If You Ain't Got That String" since quite often people have everything else in their code fine, but can't get connected. I decided that wouldn't work since I wanted you to be able to tell what the heck the article was going to cover and I wasn't sure people would get the Duke Ellington reference. Then I started thinking about something along the lines of "Get Yourself Connected." Again I found the lack of descriptiveness (if that's a word) troublesome and I didn't want people who don't get HBO to miss all the Sopranos references I would have been forced to make.
This article covers two advanced ADO topics: creating hierarchical Recordsets (via data shaping) and creating custom Recordsets. Specifically, this article looks at how to create custom hierarchical Recordsets. Therefore, it is essential that the reader have a fluid understanding of both data shaping and custom Recordsets, topics that this article doesn't aim at teaching. To learn about these topics, be sure to read the following articles
By centralizing database code within ActiveX DLL's, you can simplify your development efforts, and decrease the learning curve for new developers. In this article, we will create a Visual Basic ActiveX DLL that controls database functionality for our Active Server Page (ASP) demo.
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.