Database
  Home arrow Database arrow Manipulating ADO Recordsets
Iron Speed
ASP Free Forums 
.NET  
ASP  
ASP Code  
ASP.NET  
ASP.NET Code  
BrainDump  
C#  
Code Examples  
Database  
Database Code  
IIS  
Microsoft Access  
MS SQL Server  
Visual Basic.NET  
Windows Scripting  
Windows Security  
XML  
ASP Web Hosting  
ASP.NET Web Hosting 
Dedicated Servers 
Download TestComplete 
Windows Web Hosting
 
IBM® developerWorks 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
DATABASE

Manipulating ADO Recordsets
By: Jayaram Krishnaswamy
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 3 stars3 stars3 stars3 stars3 stars / 6
    2006-06-21

    Table of Contents:
  • Manipulating ADO Recordsets
  • Sorting the recordset
  • Filtering the Recordset
  • Using the Filter property of the recordset
  • Recordset's Find() method

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    Iron Speed
     
    ADVERTISEMENT

    Create a Highly Available Database Solution. Advantage Database Server can provide the availability to keep your data safe and ready for your application and users.

    Manipulating ADO Recordsets
    (Page 1 of 5 )

    In previous tutorials we only looked at some of the recordset properties and methods. However, it's useful to stop and consider how we may put some of these already considered methods and properties to use. Some of the most important aspects of data retrieval concern how the data is going to be used and how it may be manipulated. We will be looking at these issues, building upon the previous tutorials.

    You will find it beneficial to review the previous tutorials, which you can reach at the links shown below, with the most recent one listed first:

    With the recordset open, we may want to manipulate the recordset rows to accomplish sorting, filtering and finding. Sorting refers to reordering the rows either in descending or ascending order in such a fashion that one or more of their columns (fields) gets rearranged (aka sorted). Filtering, on the other hand, involves using criteria such that only the record or records meeting the criteria are selected for display or other use. Finding is searching through the recordset to locate the rows, one of whose columns satisfies a certain criteria. Sort and Filter properties are dependent on the data provider.

    For the purposes of this tutorial, a table named "Employees" has been imported into a Microsoft Access (MS Access 2003) application, manip.mdb. Some extra data (a couple of rows) has been added to the table to make the examples more useful. The table design is as shown in the next picture.

    More Database Articles
    More By Jayaram Krishnaswamy


       · Getting information out of a database without the help of Sorting, Filtering, and...
     

    DATABASE ARTICLES

    - Database Programming in C# with MySQL : Usin...
    - Formatting Techniques for Data Access from E...
    - Data Access from Excel VBA
    - Generating a Multiple Table Crystal Report u...
    - ADO and the Command Object
    - On Wiring Up an ADO Data Control
    - Reading and Writing to Files on the Intranet
    - Using ADO Record to Create and Navigate Intr...
    - Using Data Access Pages to Access Data on a ...
    - Using ADO with the SQL Native Client
    - ADO`s Stream Object
    - Opening a Record Object Referencing an Open ...
    - Introducing Jasper (SQL Anywhere 10 Beta)
    - Creating a Database Project in VS 2005
    - Manipulating ADO Recordsets

     
    Accelerating Trading Partner Performance
     
    Competing on Analytics
     
    Cost Effective Scaling with Virtualization and Coyote Point Systems
     
    Five Checkpoints to Implementing IP Telephony
     
    Hosted Email Security: Staying Ahead of New Threats
     




    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway