Database Code Articles

     Dump Table Example by Ben McLendon
     Example of how to Create Records w/Unique ID # without using Identify Datatype
     Portuguese Upload component
     Barcode database driven application
     Paging certain # of records using Stored Procedure, Command Object and MS-SQL Server
     Calling Stored Procedure through the Recordset Object
     How to add records using ASP and ADO
     Tell A Friend code that is used on ASPFree.com
     Chapter 6 Objects Have Class Reference Have Type
     Various code examples of calling a stored procedure from an ASP Page.
     Adhoc ASP Search page
     CDONTS and DHCP email example by Manikantan
     Replacing Single Quotes when formatting SQL
     Using Stored Procedures to write records and retrieve ALL DATA
     Discussion & Listserv Module by Mike Eckelkamp
     Recordset Paging with a twist! A little DHTML to allow users to change the record count per page
     Execute stored proc having input and output params, returned recordset and return value
     How to update records using ASP and ADO
     Demo on how to insert records into Multiple tables with one html form and one asp form.
     An ASP include that exposes a class to generate an SQL statements
     Using Command Object with Parameters syntax example
     Write records to a SQL 7.0 database, return the unique id # ( Working Demo try it out!)
     Saving multilingual text inside SQL Server by M. Vadivel
     DSN-less Connection String syntax!
     Efficient way to Get an ADO RecordSet
     Passing Single Parameters, Returning Records and writing to an asp page
     Grouping Data by Adrian Forbes
     Accessing an Excel Spreadsheet in ASP.NET (VB and C#) by Alex Lowe
     How to update records using ASP and and formatted Sql
     ASP Database Search Engine by Mark Alexander
     Properly encoding a SQL statement through a Function
     How to setup a stored procedure to be automatically run!
     Memo and Text Fields Demo Writing out the data using ASP!
     How to add records to a database using ASP and formatted SQL
     Paging certain # of records using Access, Command Object
     Inserting records with into a database with the Command Object
     Timing and Benchmarking ASP Scripts by Robert Chartier
     Adding new records example by David Lohmann
     Getting A List of Tables From SQL Server
     ADO Recordset Paging
     Multilingual entries into a DB and to be displayed on IIS
     Two combos, one textbox example
     SQL Server Database Creator - .NET Version
     Constraints In Microsoft SQL Server 2000
     Code Snippets: Counting Records
     Using ADO to Communicate with the Database, Part 1
     A Closer Look at ADO.NET: The Connection Object
     A Closer Look at ADO.NET: The Command Object
     Using the AccessDataSource Control in VS 2005
     MobiLink Synchronization Wizard in SQL Anywhere 10
     Finding Matching Records in Data Access Pages
     Deployment of the MobiLink Synchronization Model Wizard in SQL Anywhere 10