Workshop

IOTA^_^    

Sams Teach Yourself ASP.NET in 21 Days, Second Edition
By Chris Payne
Table of Contents
Day 12.  Employing Advanced Data Techniques


This workshop will help reinforce the concepts you've learned in today's lesson. Answers can be found in Appendix A.

Quiz

1:

Specify a SQL statement to create an empty stored procedure (one that doesn't execute any SQL statement) that accepts one input parameter and one output parameter of your choice.

2:

What are the four parameter directions?

3:

True or false: You use output parameters if you want to return multiple rows of data.

4:

Will the following code work?

 Response.Write("ID = " & objCmd.Parameters("@ID"). _    Value.ToString()) objReader.Close() 
5:

What's the difference between XPathNavigator and XmlDocument?

6:

What is an XSL stylesheet used for, and how is it related to XPath queries?

7:

How do you return data from an XSL transform with XmlReader? With XmlTextWriter?

Exercises

[click here]

Create a stored procedure that inserts a new row into your tblUsers table using parameters. Build an ASP.NET page that allows users to enter this data, and execute this procedure with parameters.


    IOTA^_^    
    Top


    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

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