Workshop

These quiz questions are designed to test your knowledge of the material covered in this chapter. The answers to the quiz questions can be found in Appendix A, “Answers to Quizzes.”

Quiz

1:True or false: You can execute any valid SQL statement in a stored procedure.
2:What is the purpose of parameters in the context of a stored procedure?

Exercise

Choose a few examples from previous hours such as Hour 9, “Binding Data to List Controls,” or Hour 6, “Retrieving Data from the Data Source,” where the SQL query is built dynamically. Modify the examples to use stored procedures instead.

Get Sams Teach Yourself ADO.NET in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.