System Development Tools

C# Language Reference
C# Programming Guide
C# AS for type conversions
C# IS for testing types

Reading an SQL Stored Procedures Return Value into C#

  1. Update, Insert, and Delete SQL Statement return an integer value indicating the number of rows affected by the statement and will be returned by the ExecuteNonQuery method.
  2. For queries (using the ExecuteNonQuery method) create a Parameter with the Direction Property set to ReturnValue
  3. The Parameter object for the return value must be the first item in the Parameters collection.