ASP Database Fundamentals (Part 2) - How Do They Work?
(Page 2 of 9 )
In essence, a recordset is a collection of records from your database. If you are looking to read data using ADO, a recordset object is what you use. After making the proper connection to the database, you create a recordset object and specify the data you would like the retrieve. You can opt to retrieve all the records in a table, in multiple tables, or even a small subset of records inside a table.
In addition to controlling the records that are to be retrieved, you can also specify precisely which columns to return as well. For example, if your table has 15 columns, but you only want to see the first two columns, it is much more efficient to only bring back the 2 columns, especially when working over a network.
Next: Lets Get Technical >>
More ASP Articles
More By Rich Smith
