public static void GetFruitName(out SqlString fruitName, SqlByte fruit_nbr )
    {
        SqlConnection connection = new SqlConnection("Context connection=true");
        connection.Open();

        SqlCommand command = new SqlCommand();
        command.Connection = connection;

        string sql = "SELECT [FruitName] FROM [dbo].[Fruit] WHERE [Fruit_nbr] = @Fruit_nbr";

        command.CommandText = sql;

        SqlParameter param = new SqlParameter("@Fruit_nbr", SqlDbType.TinyInt);
        param.Value = fruit_nbr;
        command.Parameters.Add(param);

        try
        {
            string scalarValue = (string)command.ExecuteScalar();
            fruitName = (SqlString)scalarValue;
        }
        catch 
        {
            fruitName = string.Empty;
        }

        connection.Close();
    }