An XML-COM+ replacement for the ASP Session object


Author:Sebastian Odin Smith
Category:ASP, HTML, and XML
Type:Classes
Difficulty:Advanced

Version Compatibility:Visual Basic 5 Visual Basic 6


More information: In order to maintain client session state within a web application that is hosted in a server farm environment a method of storing state must be designed and implemented. Within a Microsoft environment, session state can be stored in a number of ways, each with it's own pros and cons.

The use of ASP Session variables is the easiest to use, but the least scalable. Querystring and form information are the most scalable, but they can be difficult to use and are totally unsecured. In order to find a compromise between the available session persistent methods, the xmlSession component was created.

This component will provide the web developer with method to easily maintain session state without the scalability problems associated with traditional session variables. All "session" information is stored in a centrally located data store (file or database) that can be accessed by any server in the farm.


Notes: Windows 2000 and version 3.0 or higher of the Microsoft's XML object model is required. Complete documentation is included. There is also a test vb project and and project group (.vbg) included in the test directory. Running the test project and stepping through the code will give you an idea of what the module does.

Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.
code/xmlSession.zip

ADO Access 2000 VB Code Generator

Author: Carlos Vara
Category: Database
Type: Applications
Difficulty: Intermediate
Version Compatibility: Visual Basic 5 Visual Basic 6


More information: this utilitie generate code that you can use inside your apps to create an Access 2000 Database With ADO. You select the database and it generates the code to create a database with the same name and structure.
This code has been viewed 166390 times.
Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.

source/ADOCodeGen.zip

ADO Utilities Class Version 2.0

Author:Brian Gillham (Featured Developer)
Category:
Database
Type:
Classes
Difficulty:
Intermediate
Version Compatibility:Visual Basic 6


More information: This class encapsulates many routine tasks in ADO programming, which reduces the tedium and increases the reusability of your code. For example, if you pass it a valid connection string, it will automatically set up a connection, if you pass it a valid SQL string, it will return a recordset, and so on. It includes a function that returns a shaped (parent-child) recordset, without you having to deal with writing the complex SQL that is required for shaped recordsets.
Version 2.0, added 06/06/02, incorporates the SMARTSql class on this site and also adds improvements such as automatic selection of cursors. There is a sample project; you may have to modify the connection string that is included as a constant to get it the sample to work.
This code has been viewed 153273 times.
Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.
source/ADOUtils.zip