Stored Procedure: OUT parameter

Question

How to use OUT parameter in stored procedure? and how to use that OUT parameter in code behind?..................

Subhendu De · Answer

This is my sample SQL Procedure CREATE PROCEDURE prcTest @pIn nvarchar(50), @pOut nvarchar(50) OUT AS BEGIN Select @pOut = 'Hello' + @pIn END GO This is code-behind string _connectString = @"Data Source=.\SQLEXPRESS;Initial Catalog=TestDB;Integrated Security=True"; using(SqlConnection _connection = new SqlConnection(_connectString)) { SqlCommand _command = new SqlCommand(); _command.Connection = _connection; _command.CommandText = "prcTest"; _command.CommandType = CommandType.StoredProcedure; SqlParameter[] _parameters = new SqlParameter[2]; _parameters[0] = new SqlParameter(); _parameters[0].ParameterName = "@pIn"; _parameters[0].SqlDbType = SqlDbType.NVarChar; _parameters[0].Size = 50; _parameters[0].Direction = ParameterDirection.Input; _parameters[0].Value = "World"; _parameters[1] = new SqlParameter(); _parameters[1].ParameterName = "@pOut"; _parameters[1].SqlDbType = SqlDbType.NVarChar; _parameters[1].Size = 50; _parameters[1].Direction = ParameterDirection.Output; _command.Parameters.AddRange(_parameters); _connection.Open(); _command.ExecuteNonQuery(); _connection.Close(); Console.WriteLine(_command.Parameters["@pOut"].Value); } Thanks.....

Stored Procedure: OUT parameter

Answers (1)