Output Parameter Return Value

Question

My project using 3tier layer . insert Data output parameter Value how to get my Business layer and presentation Layer.....And send me sample this mail ID :nmdineshnmdinesh@yahoo.com

Narayanan Dinesh Kumar · Answer

My Stored Procedure: ALTER PROCEDURE [dbo].[ApplicantRequestInsert] (@periodID int @RequestTypeID int @ApplicationNumber Varchar(100) output  @ApplicantName Varchar(100) output @ProgramID int @statusID int @RequestID int OUTPUT @EstimateAmount Money @RegulationID int) My Class public object InsertApplicationRequest( AdmissionRequestDAL admiRequest) { bool isInsert = false; SqlParameter[] parms = { new SqlParameter (@periodIDSqlDbType.Int) new SqlParameter (@RequestTypeIDSqlDbType.Int) new SqlParameter (@ApplicationNumberSqlDbType.VarChar 50) new SqlParameter (@ApplicantNameSqlDbType.VarChar100) new SqlParameter (@ProgramID SqlDbType.Int) new SqlParameter (@statusIDSqlDbType.Int) new SqlParameter (@EstimateAmountSqlDbType.Money) new SqlParameter (@RegulationID SqlDbType.Int) new SqlParameter(@RequestID SqlDbType.Int) }; parms[0].Value = admiRequest.periodID; parms[1].Value = admiRequest.RequestTypeID; parms[2].Value = admiRequest.ApplicationNumber; parms[2].Direction = ParameterDirection.Output; parms[3].Value = admiRequest.@ApplicantName; parms[3].Direction = ParameterDirection.InputOutput; parms[4].Value = admiRequest.ProgramID; parms[5].Value = Convert.ToInt32(1); parms[6].Value = admiRequest.EstimateAmount; parms[7].Value = admiRequest.RegulationID; parms[8].Value = Convert.ToInt32(0); parms[8].Direction = ParameterDirection.InputOutput; SQLHelper.ExecuteNonQuery(SQLHelper.conection CommandType.StoredProcedure ApplicantRequestInsert parms); string[] returnparm = new string[3]; returnparm[0] = parms[2].Value.ToString(); returnparm[1] = parms[3].Value.ToString(); returnparm[2] = parms[8].Value.ToString(); return isInsert ; } how to get my output parameter in my presentation Layer Please Help Me

Lakshmanan Sethu · Answer

Code Sample using ( SqlConnection con = new SqlConnection ( Data Source=localhost\SQLEXPRESS;Initial Catalog=answers;Integrated Security=True )) using ( SqlCommand cmd = new SqlCommand ( dbo.GetRowCount  con )) { cmd . CommandType = CommandType . StoredProcedure ; cmd . Parameters . Add ( new SqlParameter ( @count  SqlDbType . Int )); cmd . Parameters [ @count ]. Direction = ParameterDirection . Output ; con . Open (); cmd . ExecuteNonQuery (); // *** since you don't need the returned data - just call ExecuteNonQuery int ans = ( int ) cmd . Parameters [ @count ]. Value ; con . Close (); Console . WriteLine ( ans ); }

Narayanan Dinesh Kumar · Answer

Stored Procedure Ok But how to i get C# Presentation layer Procedure Result Value

Lakshmanan Sethu · Answer

Hi. Please refer the link for output parameter http://www.c-sharpcorner.com/UploadFile/rohatash/stored-procedure-with-a-return-value-in-sql-server-2012/

Narayanan Dinesh Kumar · Answer

1.HOW TO USE OUTPUT PARAMETER IN MY PROJECT 2.How to create Business Layer Class for Stored Procedure Output parameter 3.How to get Output Parameter value in my presentation Layer

Lakshmanan Sethu · Answer

Hi Narayanan Please be clear with your requirement.