Setting Up the Sample Stored Procedures
In this chapter, you'll import a new page, shown in Figure 15.1, that allows you to work with the Employees table in the Northwind sample database. (There's too much code here to ask you to create it yourself—this time, you'll just inspect it.) You'll list all employees, add a new employee, and delete an employee. In each case, you'll use a stored procedure to do your work. In addition, to demonstrate the similarities (and the differences), you'll look at the code that calls the “add” stored procedure twice—first using the OleDb namespace and then using the SqlClient namespace.
Figure 15.1. Use this Web page to input a new employee, list employees, and delete employees using stored procedures.
In order ...