Database Tutorials & Articles
-
Encapsulating ODBC in ASP .NET
by Jason G. WilliscroftHotQuant, LLC, builds on their previous ODBC article by demonstrating how to use encapsulation to isolate an application's data access layer and significantly streamline the code.
-
PowerBuilder 9 in review
by Kay EwbankAs Microsoft strides on with its .NET vision, developers who don't feel like tagging along are finding their range of options fairly limited. PowerBuilder 9 offers one escape route.
-
Identifying Your New Records
by Bruce JohnsonWhile the use of AutoNumber and Identity fields in tables is greatly applauded by database designers the world over, they can be annoying for developers to use. This article reveals two techniques for retrieving the value of an AutoNumber/Identity field.
-
Searching articles for hand-picked keywords
by James ShawJames Shaw demonstrates how he implemented a keyword-searching page for his site.
-
Implementing ODBC in ASP .NET
by Jason G. WilliscroftWith Microsoft's ODBC data server controls, .NET finally supports ODBC... but not very well. HotQuant, LLC, has published an in-depth technical article demonstrating an effective workaround.
-
Using PHP and IIS to Create a Discussion Forum
by Jayesh JainLearn how to use PHP on windows and IIS to create a basic discussion forum that makes use of a powerful database.
-
MySQL table options
by Kay EwbankThere's more than one type of table in MySQL, so Kay Ewbank explains the range of possibilities, and gives us a practical introduction to transactions.
-
Using Triggers to track database action history
by Super TalTal Kelley demonstrates how to use triggers in SQL Server in order to keep track of who is modifying your database tables.
-
Eocene: An OO Web Development Framework
by Deepak DuttaEocene is a simple and easy to use Object Oriented Web development framework for PHP. It is based on the Front Controller design pattern and the Model View Controller (MVC) architecture. It incorporates many proven software development practices to provide a foundation for building Web applications. It uses PHP for foundation classes and xml-based text files for application configurations. It is a simple and easy to use framework that can be used to solve a large number of Web development projec
-
Creating tables in HTML
by baillieThis tutorial will take you through the process of creating tables in HTML, from the easy, ones to the more complex.
-
Building XML Web Services Using C# and ASP.NET
by James YangThe term web service has been used quite frequently lately: you hear people saying how good web services are and how they will dominate the future of software development, but what exactly are web services and how can we create them? In this article James shows us how to build two web services and also unravels all of the lingo surrounding web services.
-
Creating a database connection
by Tony HoCreating connections and all your data objects are really easy Design-Time, but what if you need it for runtime? Here's how.
-
Sessions in PHP
by amitabh doctorA brief overview of using sessions in PHP 4.0.
-
ADO and Unicode
by David NishimotoHow to use Microsoft ADO to add and update unicode code points stored in an Oracle UTF8 database.
-
DAO 3.6 Library
by Louis RoseLearn how to use MS Access 2000 with VB and the DAO library. Includes a module for handling simple databases.
-
Classic Guestbook made with Flash and ASP/PHP
by Pradeep MamgainPradeep Mamgain demonstrates creating a guestbook with a Flash interface, and an ASP or PHP back-end to store the data.
-
Remote Scripting With JavaScript and ASP
by Mitchell HarperRemote scripting is an extremely powerful feature available in both Netscape Navigator and Internet Explorer. It allows us to use a combination of scripting languages to call server side ASP code from the client using JavaScript. In this article Mitchell shows us how to install remote scripting as well as two examples of using it to interact with ASP scripts using client-side JavaScript code.
-
XML Strengths & Weakness’ with DOM, ASP & XSL
by Nakul GoyalNakul Goyal introduces the XML technology, and how it can be used in your ASP and Visual Basic programs.
-
Beginning Active Server Pages
by James CrowleyExpand your VB skills to the web - learn how to create Active Server Pages in this extensive tutorial
-
Using SQL-DMO To Backup and Verify a Database
by Carvin WilsonThe SQL Distributed Management objects (SQL-DMO) extend the functionality of SQL Server by providing developers a way to execute common tasks using programming and scripting languages. This article shows you how to use SQL-DMO to create an Active Server Page application to backup and verify a SQL Server database.