check this
sql server - Using stored procedure output parameters in C# - Stack Overflow[
^]
to read the value from out parameter in c#, you will have to change the
ExecuteProc
method.
refer this sample code:
public int executeDonor()
{
int lastID = 0;
SqlConnection con = new SqlConnection("Your Conn string");
SqlCommand cmd = new SqlCommand("spDonor ", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@flag", _flag));
cmd.Parameters.Add(new SqlParameter("@donorcode", _dnrCode));
cmd.Parameters.Add(new SqlParameter("@donor", _donor));
SqlParameter paramOutId = new SqlParameter("@lastid", System.Data.SqlDbType.Int);
cmd.Parameters.Add(paramOutId);
paramOutId.Direction = System.Data.ParameterDirection.Output;
con.Open();
cmd.ExecuteNonQuery();
lastID = (int)paramOutId.Value;
con.Close();
}