Chapter 9: Working with Relational Data


Overview

In the last chapter, you saw how easy it is to access both relational and XML data using the .NET data access libraries. In this and the next chapter, we will concentrate on what has traditionally been the major use of data access in ASP “ working with relational data “ and will see some of the more advanced features that .NET provides. This chapter is mainly concerned with the ways the DataReader , DataSet , and DataTable objects are used. In the next chapter, you'll look at how to update data sources using .NET.

While simple data access through a DataReader object will fulfill many of the tasks previously accomplished with ADO Connection and Recordset objects in earlier versions of ASP, you will regularly want to build more complex data structures. Plus, the fundamentally disconnected nature of the .NET data access techniques means that you will often decide to use a DataSet to implement a selection of information as a package that can be easily stored and transported between application tiers “ including across the network.

The DataSet object is at the heart of the .NET disconnected data access strategy, so let's look at all the important aspects of using one in this chapter.

The topics covered in this chapter are:

  • Accessing complex data with DataReader and DataSet objects.

  • Using stored procedures with DataReader and DataSet objects.

  • Building and editing data in a DataTable object.

  • Sorting and filtering data with DataTable and DataView objects.




Professional ASP. NET 1.1
Professional ASP.NET MVC 1.0 (Wrox Programmer to Programmer)
ISBN: 0470384611
EAN: 2147483647
Year: 2006
Pages: 243

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net