Stored Procedures and other queries with parameter - Using ADO.NET with SQL Server - De... - 0 views
-
// add a new parameter, we need to get the name right this time! SqlParameter sqlParam = com.Parameters.Add("@Identity", SqlDbType.Int); // set the direction flag so that it will be filled with the return value myParm.Direction = ParameterDirection.Output;
-
com.Parameters["@Identity"].Value will contain the value that was set in the stored procedure
-
using stored procedures that return a value