Calling a Stored Procedure from C#

In ADO.NET, put the procedure's name in a SqlCommand, set its CommandType to StoredProcedure, and add each parameter by name. Then read the results as from any query.

Updated

Cheat sheet: Calling a Stored Procedure from C#
Category
C#
Level
Journeyman
Tags
CommandType, c-sharp, Stored Procedure, t-sql