output parameter in stored procedure

Stored Procedure

CREATE PROCEDURE [dbo].[GetFruitName]

      @FruitId INT,

      @FruitName VARCHAR(30) OUTPUT

AS

BEGIN

      SET NOCOUNT ON;

     

      SELECT @FruitName = FruitName

      FROM Fruits

      WHERE FruitId = @FruitId

END

Now Sql Code

string constring = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;

    using (SqlConnection con = new SqlConnection(constring))

    {

        using (SqlCommand cmd = new SqlCommand("GetFruitName", con))

        {

            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.AddWithValue("@FruitId", int.Parse(txtFruitId.Text.Trim()));

            cmd.Parameters.Add("@FruitName", SqlDbType.VarChar, 30);

            cmd.Parameters["@FruitName"].Direction = ParameterDirection.Output;

            con.Open();

            cmd.ExecuteNonQuery();

            con.Close();

            lblFruitName.Text = "Fruit Name: " + cmd.Parameters["@FruitName"].Value.ToString();

        }

    }