OutPut Parameter in sql server

Output parameter sample in stored procedure and how to use the output parameter.

USE [FruitsDB]

GO

/****** Object:  StoredProcedure [dbo].[GetFruitName]   *****/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[GetFruitName]

 @FruitId INT,

 @FruitName VARCHAR(30) OUTPUT

AS

BEGIN

 SELECT @FruitName = FruitName

 FROM Fruits

 WHERE FruitId = @FruitId

END

In C# code:

 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();

            }