A db grid control using ASP
A grid control for editing databases on the web. It is written for ASP with JavaScript, but should be fully usable from VBScript as well. With just a few lines of code, you will, with this control, be able to edit your data.
ADO: Displaying Data
Covers Viewing information from a database, Dynamically retrieving a Recordset's data , Selecting records from a database, Retrieving properties of a database.
ADO: Letting users find data
Covers Letting users search for information, Using SQL to query and return search results, Using a Filter to screen out search results, ADO Find Method.
Clone ADO Recordsets The Right Way
Contrary to popular belief, Recordset.Clone doesn't actually clone the recordset. It doesn't actually create a new object in memory - it simply returns a reference to the original recordset with the option of making the reference read-only. This article explains on how to create a true independent clone.
Easy ADO RecordSet Paging
The article demonstrates the use of ADO Recordset paging. Paging is invaluable for splitting up the results of database queries into manageable screens of data
Randomizing a Recordset
This article shows several ways to use a SQL calculated field and the ORDER BY clause to arrange a recordset in random order. A simple tool is provided for verifying that the results are uniformly random. A technique for bubbling records with certain attributes to the top of an otherwise randomized list is also shown.
Using Disconnected Recordsets
This article examines what disconnected Recordsets are, how to use them, and what advantages they offer over connected Recordsets.
Using Multiple Recordsets
This article examines how to increase the performance of your ASP pages that rely on gathering data through several different Recordsets.
InfoWorld is a enterprise-level publication that focuses on technology and HOW to use it to achieve higher revenues, more efficient operations and greater profits.
subscribe now
Files
