get the output parameters of stored procedure using methods

hadoop hadoop

I've many stored procedures in my project. Stored procedures are for selecting data, updating data , inserting data etc. Some of the stored procedures have output parameters too.

For eg.

CREATE PROCEDURE [dbo].[proc_sales_profiling]

@p_SalesPerson varchar(50),

@p_SalesTarget money OUTPUT

SET NOCOUNT ON;

SELECT @p_SalesTarget = SalesTarget, @p_SalesProfile = SalesProfile

FROM Sales.SalesPerson

WHERE LastName = @p_SalesPerson;

Now how to write C# method to execute such procedures having multiple input parameters and output parameters. Also how to implement such methods in other methods in Data Access Layer.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

hadoop hadoop11y ago
Any help regarding this.
0
hadoop hadoop11y ago
Thanks for the reply. I need to create a method for ExecuteNonQuery. Please refer to this ,

public string ExecuteNonQuery(string commandText, SqlParameter[] sqlParameter)
{
try
{
SqlCommand cmd = new SqlCommand(commandText, this.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddRange(sqlParameter);
this.con.Open();
cmd.ExecuteNonQuery();
return "success";
}
catch (SqlException ex)
{
return ex.Message;
}
finally
{
if (con.State == ConnectionState.Open)
this.con.Close();
this.con.Dispose();
}
}
// con for connection string

Now how to make this method get the output parameters from the stored procedure. Please suggest.
Thanks!
0
Vignesh Mani11y ago
Hi please refer below link. i hope it will help you.

http://www.aspsnippets.com/Articles/How-to-return-Output-parameter-from-Stored-Procedure-in-ASPNet-in-C-and-VBNet.aspx
0