3.18. Retrieving Data Using a SQL Server Stored Procedure

Problem

You need to execute a SQL Server stored procedure to retrieve a result set.

Solution

Use a SqlCommand object with its CommandType property set to StoredProcedure.

The solution executes the stored procedure dbo.uspGetEm...