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.
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.