|
Turn foreign keys into list boxes - The author writes "CoverYourASP's original database administration tool didn't look for foreign keys, and just displayed a confusing list of primary key values. Now, it's been improved with automatically generated list boxes." This tutorial explains how to turn those foreign keys into list boxes automatically.
Price:
Two Table Join - Outputting data from two tables is almost as easy as displaying from one. This example utilizes two
tables with state information on them. The first table (state_order) contains state abbreviations (state), state names (statename) the year each state was admitted into the union (year) and the numeric order they entered in (entered). The second table (state_capitals) contains state abbreviations (state), state names (state) and state capitals (capital). The where statement looks to make a match on the field that each table has in common to ouput the correct capital with all the info from the state_order table.
Price: Free
Two Ways To Connect To SQL Server 2000 Via ASP - This article will show you two different methods that you can use to connect to a Microsoft SQL Server 2000 database: System DSN's and the OLEDB connection string. It will also explain the positives and negatives of each method, along with some examples to get you started.
Price:
U.S. Database - U.S. database system that includes area codes, zip codes, county and state info. The samples include the ability to measure distances between Zip Codes and a full Search system. The package (download) contains the Database with several tables and queries, source code for the sample pages from below and a graphic of each State Flag. Version 3 includes additional Zip and Area Codes including information for extended US Areas.
Price: $9.95
Universal Table Editor - Universal Table Editor is an ASP (Active Server Pages) application and can be used for every table in every database you can reach from your IIS on Win NT-Server or PWS on Win NT-WS / Win9x. It features: Insert, Edit and Delete Records
Export complete Table as CSV file (e.g. readable by Excel); Show Field Definitions; Sorting of each Column; Automatic Primary Key detection; Some Basic Error Management; and Data Types like Binary will not be displayed and are not editable.
Price: Free
Uploading and inserting files (binary data) to the database - Step-by-step tutorial on how to upload files (images, text, other documents, etc) using plain ASP pages to the database. Every step has been explained in detail. Downloadable source code available.
Price:
Uploading and Inserting Images (binary data) into Database - This is a step by step tutorial on uploading and inserting binary data (images, files, etc.) into Access Database. Online demo, and sample code available for download.
Price:
Uploading Images to Database Using Persist AspUpload - You can upload your images to MS-SQL server with this simple script. To upload a picture to sql database, be sure Persist AspUpoad installed in you server.
Price: Free
Using ASP pages to page through Recordset - In depth article on showing records in a page by page fashion with 'first page','next','back' and 'last page' links at the bottom to navigate through the records. Sample code and database available for download. Online demo also available.
Price: Free
Using ASP to create, edit, or delete information in a database. - This is a set of ASP examples/tutorials that demonstrate exactly how to use ASP with a database. Topics include: Using ADO To Add A New Record, Using ADO To Update An Existing Record, Using An Update Query To Modify An Existing Record, Using Delete Statement to Delete Records, Using A Select Statement (With A Loop), and ACCESS DATABASES ( DSN vs DSN-LESS).
Price: Free
Using Disconnected Recordsets - This article covers rarely discussed feature of ADO Recordsets, disconnected Recordsets. It examines what disconnected Recordsets are, how to use them, and what advantages they offer over connected Recordsets. Also examines how to create custom, disconnected Recordsets.
Price:
Using Multiple Recordsets - This article explains a solution on how to increase the performance of your ASP pages that rely on gathering data through several different Recordsets. Specially, using a nifty feature of the ADO Recordset object, Multiple Recordsets, you can store multiple SQL query results in one Recordset object, requiring fewer communications with the database.
Price:
Using MyODBC To Access Your MySQL Database Via ASP - MySQL is the most popular open source database system available today, and is currently installed on over two million servers worldwide. This article takes a look at using the free MyODBC driver to talk to a MySQL database from an ASP script.
Price:
Using SQL-DMO To Backup and Verify a Database - This article shows you how to use SQL-DMO to create an Active Server Pages application to backup and verify a SQL Server database. The SQL Distributed Management Objects (SQL-DMO) extend the functionality of SQL Server by providing developers a way to execute common tasks.
Price:
Using Triggers to Track Database Action History - This article describes how to use Microsoft SQL Server triggers to automatically record all updates and inserts for a particular database table in a customized history table.
Price:
|
|
Link Exchange Manager
 Link Exchange Manager is a software program that manages your website's links pages. It is a time-saving way to reduce HTML coding and manual scanning for reciprocal links and dead links on your link partners websites. Link Exchange Manager is perfect for managing an organized links page, or a resource directory, and you can send off link request emails to website prospects. Also called link swapping, its a great way to increase your search engine rankings and boost your google rankings. Find out more
Make Games Run Faster
 Release RAM is a great little memory management utility which is designed to make computers run faster and be more stable. It can be very useful with gaming as it can eliminate lag caused games with high graphics, especially on older PCs. Try it Today
|