|
|
|
|
|
Total Hits: 369 | Today: 0 |
Author: David Morgan
|
Rating:
|
|
|
This function provides you with ability to input the max number of character’s of a records from a database before truncation. And the ability to input the text you would like to be placed after the truncated text....
|
|
|
|
Total Hits: 2418 | Today: 0 |
Author: Faisal Khan
|
Rating:
|
|
|
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....
|
|
|
|
Total Hits: 848 | Today: 0 |
|
Rating:
|
|
|
This article discusses the performance differences between ADO’s various types of cursors and locktypes and shows you the importance of using the correct cursor and locktype....
|
|
|
|
Total Hits: 569 | Today: 0 |
Author: Evagoras Charalambous
|
Rating:
|
|
|
I showed how to create a class which returns your recordset as an array using the GetRows function. In this article, I will expand on the class, adding two more functions......
|
|
|
|
Total Hits: 975 | Today: 0 |
|
Rating:
|
|
|
This FAQ describes the process of displaying data on a Web page through arrays instead of the traditional Recordset method. The way we've all likely used to display arrays involves opening a Recordset object and then using a Do While Not objRS.EOF ... Loop......
|
|
|
|
Total Hits: 702 | Today: 0 |
Author: James Shaw
|
Rating:
|
|
|
All I had to do is create an object, and use "expando properties" to fill it with recordsets. The function DBGetNamedRecords takes the name of the recordset and the SQL to fill it....
|
|
|
|
Total Hits: 562 | Today: 0 |
Author: Charles Carroll
|
Rating:
|
|
|
This article covers the topic of GetRows including several coding examples....
|
|
|
|
Total Hits: 1046 | Today: 0 |
Author: John F.
|
Rating:
|
|
|
This tutorial shows how to use the GetRows Method of the ADO Recordset object to return and write out records. This method is a lot faster and easier than using . Movenext method. There are many benefits to using the technique and its very easy to use....
|
|
|
|
Total Hits: 905 | Today: 0 |
|
Rating:
|
|
|
In this Example you have a DIS-CONNECTED RecordSet. You can then Add, Update, Delete or do whatever you please because the RecordSet is not Closed, it just does not have a connection. When you want to update the Database you merely restore the connection....
|
|
|
|
Total Hits: 350 | Today: 0 |
Author: Gabriel Garcia
|
Rating:
|
|
|
The purpose of this code is to read a text file and put it into a record set. The code does not depend on DNS and programmer has full control of record set properties....
|
|
|
|
Total Hits: 1416 | Today: 0 |
Author: Nannette Thacker
|
Rating:
|
|
|
Don't hard code your data connections every time you need them! Use these functions to open and close a Database Connection and Record Set....
|
|
|
|
Total Hits: 1005 | Today: 1 |
Author: Brett Burridge
|
Rating:
|
|
|
This article demonstrates the use of ADO Recordset paging. Paging is invaluable for splitting up the results of database queries into manageable screens of data....
|
|
|
|
Total Hits: 1969 | Today: 0 |
Author: Antonin Foller
|
Rating:
|
|
|
You can use GetString method of recordset object to convert recordset (SQL query) to csv file......
|
|
|
|
Total Hits: 3058 | Today: 0 |
Author: Serkan Polat
|
Rating:
|
|
|
you have an xml document and maybe want to convert it to a recordset, but how? this article shows how you can do it....
|
|
|
|
Total Hits: 1687 | Today: 0 |
Author: Robert Chartier
|
Rating:
|
|
|
This is a very simple introduction to the .SAVE and .OPEN Methods of the Recordset object of ADO. These are two functions that will convert an ADO Recordset object into an XML document, and SAVE it to the File System and convert that same XML document and OPEN it back into a Recordset Object....
|
|
|
|
Total Hits: 982 | Today: 0 |
Author: John Pragnell
|
Rating:
|
|
|
Shows how to get recordset data into a VB (or other) application from remote databases on the web, edit it, and put back the changes - all from simple ASP pages on the server via HTTP using ADO + XML - 1 line of code in VB to retrieve, 3 to return (+ not more than 25 lines of ASP on the server) for the simplest case....
|
|
|
|
Total Hits: 403 | Today: 0 |
Author: LINE9
|
Rating:
|
|
|
Display your recordsets sideways! Instead of displaying recordsets on your page one, then a line break, then another one, etc, why not display your records in a fashion that will more effectively use your available screen space? Horizontally!...
|
|
|
|
Total Hits: 933 | Today: 0 |
|
Rating:
|
|
|
For retrieving and manipulating data, ADO provides the Recordset object. As its name implies, the Recordset object is used to contain a set of database records, which can be the entire set of records from a table, or the results of a specified query command....
|
|
|
|
Total Hits: 1288 | Today: 0 |
Author: microsoft.com
|
Rating:
|
|
|
This article includes step-by-step instructions to set up an ASP client that demonstrates the use of the OLEDB Simple Provider for XML to access hierarchical XML data....
|
|
|
|
Total Hits: 1303 | Today: 0 |
|
Rating:
|
|
|
To populate a dropdown list from a database table, first open a recordset and read from it one record at a time and dynamically write a html dropdown list....
|
|
|
|
|
|
|
