Retrieving a Stored Procedure Output Parameter : SqlConnection Stored Procedure « ADO.Net « C# / CSharp Tutorial






/*
CREATE PROCEDURE Person.GetContacts
    @RowCount int OUTPUT
AS
    SET NOCOUNT ON
    SELECT * FROM Person.Contact
    SET @RowCount = @@ROWCOUNT
    RETURN @RowCount
*/

using System;
using System.Data;
using System.Data.SqlClient;

    class Program
    {
        static void Main(string[] args)
        {
            string sqlConnectString = "Data Source=(local);Integrated security=SSPI;Initial Catalog=AdventureWorks;";

            using (SqlConnection connection = new SqlConnection(sqlConnectString))
            {
                SqlCommand command = new SqlCommand("Person.GetContacts", connection);
                command.CommandType = CommandType.StoredProcedure;
                command.Parameters.Add("@RowCount", SqlDbType.Int).Direction =
                    ParameterDirection.Output;
                connection.Open( );
                SqlDataReader dr = command.ExecuteReader( );
                int rowCount = 0;
                while (dr.Read( ))
                {
                    rowCount++;
                }
                dr.Close( );
                connection.Close( );
            }
        }
    }








32.15.SqlConnection Stored Procedure
32.15.1.Call a stored procedure
32.15.2.Call stored procedure with no parameter
32.15.3.Call stored procedure with parameter and return value
32.15.4.Call storedprocedure and pass in the parameter
32.15.5.Call stored procedure with parameters using SqlCommand
32.15.6.Call StoredProcedure with input and output parameters
32.15.7.Catch exception when calling stored procedure
32.15.8.Retrieving a Return Value from a Stored Procedure
32.15.9.Retrieving a Stored Procedure Output Parameter
32.15.10.Retrieving Data Using a SQL Server Stored Procedure
32.15.11.Retrieves stored procedure parameter information
32.15.12.Call stored procedure
32.15.13.Call stored procedure with SqlCommand
32.15.14.Raising and Handling Stored Procedure Errors