Find Data in Procedure with Out Paramer in Procedure

 Step (A) ||
------------
string OldPR = objDAHeaderFactory.GetDATOPRNumber(Convert.ToInt32(DAID));


 Step (B) ||
------------  Class DAHeaderFactory

  public string GetDATOPRNumber(int DANo)
        {
            return this._dataObject.GetDATOPRNumber(DANo);
        }


Step (C) ||
-----------  class DAHeaderDAL

public string GetDATOPRNumber(int DANo)
        {
            string PRNo = "";
            SqlCommand sqlCommand = new SqlCommand();
            sqlCommand.CommandText = "dbo.[GETPRNumberFromDA]";
            sqlCommand.CommandType = CommandType.StoredProcedure;
            sqlCommand.Connection = this.MainConnection;
            try
            {
                sqlCommand.Parameters.Add(new SqlParameter("@DANo", SqlDbType.Int, 10, ParameterDirection.Input, false, (byte)0, (byte)0, "", DataRowVersion.Proposed, (object)DANo));
                sqlCommand.Parameters.Add(new SqlParameter("@PRNo", SqlDbType.VarChar, 20, ParameterDirection.Output, false, (byte)0, (byte)0, "", DataRowVersion.Proposed, (object)PRNo));
                this.MainConnection.Open();
                sqlCommand.ExecuteNonQuery();
                PRNo = Convert.ToString(sqlCommand.Parameters["@PRNo"].Value);
                return PRNo;
            }
            catch (Exception ex)
            {
                throw new Exception("GETPRNumberFromDA::GETPRFROMDA::Error occured.", ex);
            }
            finally
            {
                this.MainConnection.Close();
                sqlCommand.Dispose();
            }
        }


Step (D) ||
-----------  Create Procedure

Create PROCEDURE [dbo].[GETPRNumberFromDA]
@DANo int,@PRNo varchar(20) output
AS

select @PRNo=SIMPraPRNumber from PRHeader where PRID=( select PRID from DADetails where DAID=@DANo)
select @PRNo as PRNo


  ----  Check Procedure
declare @PRNo varchar(20)
exec GETPRNumberFromDA 485996,@PRNo

select len('CSDS1917053901')