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

Get ASP.NET Developer's JumpStart 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.