ASP.NET 4 Unleashed

Executing Stored Procedures

The SqlDataSource control can represent SQL stored procedures just as easily as it can represent inline SQL commands. You can indicate that a command represents a stored procedure by assigning the value StoredProcedure to any of the following properties:

• SelectCommandType

• InsertCommandType

• UpdateCommandType

• DeleteCommandType

You can create a new stored procedure in Visual Web Developer by opening the Database Explorer window, expanding a Data Connection, right-clicking Stored Procedures, and clicking Add New Stored Procedure (see Figure 9.4).

Figure 9.4. Creating a new stored procedure in Visual Web Developer.

The stored procedure in Listing 9.8 returns a count of the number of movies in each movie category. ...