Edit records with sql statements - Learn how to edit records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection. Price: Editing and Updating Records in the Database - Complete tutorial on editing and updating records in the database. Each and every step explained in detail for ASP beginners. Both Connection and Recordset Objects discussed. Price: Free Excel Data - This is a simple ASP script demonstrating how to connect and display Excel data using ADO From ASP. Price: Free Executing Transact-SQL DELETE statement - In this example, we will delete some records from a database. This source code helps us to deleting records to database without slowing down database. Price: Executing Transact-SQL INSERT statement - In this example, we will add some records to a database. This source code helps us to adding records to database without slowing down database. Price: Executing Transact-SQL UPDATE statement - In this example, we will edit some records from a database. This source code helps us to edit records to database without slowing down database Price: Fastest way of Database Access : Caching Records in Memory - A step by step tutorial on caching data in memory. This tutorial goes one step further from simply caching data in memory to allow you to set a time limit in seconds after which it refreshes the data in memory. Extremely useful technique. Online demo available. Price: File DSNs - Use and Reuse - Many a time, you are confronted with creating a system DSN for use with ASP. If you have an ISP account, this might take time and more than sometimes - money. This article describes how to use File DSNs and save time and money. Also, you can reuse these DSNs and thus, with some modifications, use the same DSN for as many database connections. Price: Free Filtering and Sorting of Records in a Database - Learn how to search and sort the records through the database. Step by step tutorial with Sample code and database available for download. Online demo also available. Price: Free Fun With Stored Procedures... - This is a brief and very useful tutorial on creating and using stored procedures with your asp applications. A stored procedure is nothing more than an sql statement stored inside a database. The database can be SQL Server or MS Access as well as others. A stored procedure is compiled by your database (for the most part) one time, when it is entered. This results in faster database executions and overall performance updates, and it further separates the sql statement from your asp leaving you with more readable code. This tutorial describes: What is a stored procedure?, Writing stored procedures, Getting the stored procedure into the database, Calling stored procedures in ASP pages, and Modifying and removing stored procedures. Price: Free Generating random records from the Database - This article shows how to generate random records from the database. Also explains how to generate random numbers. Sample Database and Code available for download. Price: Free GenericDB - GenericDB is an open source tool which allows developers to put nearly any database on the web for viewing and/or editing with very little code. The GenericDB engine is written with Microsoft Acti Active Server Pages (ASP) for IIS 4. It has been tested successfully on NT 4, Personal Web Server (recommend update to MDAC 2.0) and ChiliASP for UNIX. Price: Free/$28 Get the ID of the record entered - How do I get the Unique ID or Auto ID of the record I just entered? The solution is really quite simple. Price: Get Your Data Faster with a Data Cache - Storing frequently used lookup data in a database is a great idea (e.g. order status codes, state names, etc.) that saves tremendous amounts of time in design and maintenance. However, retrieving that data from the database every time it is needed is very inefficient. This article describes how to use Application variables to cache frequently used lookup data in memory to achieve lightning fast access times. Price: Free Getting Your Quotes Right In SQL For ASP - It is somewhat ironic that the most confusing part of creating and executing a SQL statement from ASP is determining where to put the quotes. When is a single quote used? When is a double quote used? When are they used together? Which takes precedence? This article will answer these questions. Price:
|
Javascript
PHP
Java
ASP
CGI & Perl
Site Management
Webdesign Tools
HTML Editors
Site Builders
FTP
Flash Tools
More...
| 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. |
