ASP.NET Developer's JumpStart
By Paul D. Sheriff, Ken Getz
Table of Contents
Chapter 14.  Working with Data

In this chapter, you began your exploration of ADO.NET's data-management objects. Here's what you learned:

  • The DataReader (OleDbDataReader or SqlDataReader) is great at retrieving data quickly and efficiently. Because it only provides forward-only, read-only access to data (and in many cases, you must retrieve columns in a particular order), it can make your work a little harder when coding. But you will find that the performance benefits are well worth the extra coding you may have to do. A DataSet is made up of one or many DataTable objects, and you can set relationships between these data tables. You may also want to add primary keys to each data table so that you can search within the tables later on.

  • You can use a DataRelation object to allow you to retrieve multiple related data tables and look up child rows based on a selected parent row. This allows you to make one request for data to the database server but show specific data from the data tables on request.


    ASP. NET Developer's JumpStart
    ASP.NET Developers JumpStart
    ISBN: 0672323575
    EAN: 2147483647
    Year: 2002
    Pages: 234 © 2008-2017.
    If you may any questions please contact us: