You need to execute a SQL Server stored procedure to retrieve a result set.
Use a SqlCommand object with its CommandType property set to StoredProcedure.
SqlCommand
CommandType
StoredProcedure
The solution executes the stored procedure dbo.uspGetEm...
dbo.uspGetEm