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.....