Day 12. Employing Advanced Data Techniques


Sams Teach Yourself ASP.NET in 21 Days, Second Edition
By Chris Payne
Table of Contents
Week 2.  At a Glance

You've been rapidly learning different methods of data access. Now that you have a strong foundation, it's time to move to a more advanced level. Today's lesson will focus on more complex techniques than the ones you've been using up till now. You'll examine new database and XML I/O techniques that will help you develop master-level applications.

First, you'll look at a few new ways to retrieve data by using parameters and stored procedures. Parameters allow you to create your queries more efficiently. Stored procedures are prebuilt SQL statements that provide many benefits to your application, including speed and readability. You'll also learn how to use transactions to ensure that SQL commands are executed properly.

Next, you'll learn more about XML. Today's lesson will introduce the XmlNavigator object, which can be used to read an XML file, similar to the XmlDocument object. With this new object, you'll be able to use XPath queries and XSL transforms. The former is a query language used with XML (like SQL is to databases), and the latter allows you to transform XML files into other types of structured documents, such as HTML files. An important part of becoming an expert in ASP.NET is learning many different ways to do one thing. After today's lesson, you'll know several different ways to access data from both databases and XML files.

Today's lesson will cover the following:

  • What a parameterized query is and how to use it

  • What stored procedures are and how to use them

  • How to use transactions

  • Another way to read XML documents

  • How to query XML files

  • How to transform XML files


    Sams Teach Yourself ASP. NET in 21 Days
    Sams Teach Yourself ASP.NET in 21 Days (2nd Edition)
    ISBN: 0672324458
    EAN: 2147483647
    Year: 2003
    Pages: 307
    Authors: Chris Payne

    Similar book on Amazon © 2008-2017.
    If you may any questions please contact us: