SqlConnection conn=new SqlConnection("Initial Catalog=test;Data Source=localhost;User Id=test;password=test;"); conn.Open(); SqlCommand cmd= new SqlCommand(); cmd.CommandText="dbo.test112"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection=conn; SqlParameter parm = cmd.Parameters.Add("RETURN_VALUE", SqlDbType.Int); parm.Direction = ParameterDirection.ReturnValue; cmd.ExecuteNonQuery(); System.Console.WriteLine(parm.Value);