Hundreds of friends and relatives attended a memorial service for teenager Ben Manning, whose body was found in a Wakefield river.
The 17-year-old's body was recovered from the River Calder at Thornes Lane Wharfe three weeks ago.
He went missing following a night out on 22 January.
During the memorial at St Mary's Church, Swillington, mourners paid tribute to a talented musician who had hoped to become a history teacher.
Brother Lee Manning said: "He was going on to university, he had been accepted pending his results to study history with the Russian revolution in particular, and he wanted to be a history teacher.
"He was moving into a new band and learning to go from being a guitarist to a bass guitarist. He just loved it."
During a 10-day search for Ben, more than 20,000 people signed up to a Find Ben Manning Facebook page.
Reverend Lindsey Pearson said: "The family were aware that lots of people have been following the journey of Ben and lots of people have known Ben, so have been wanting to mark the end of his life in some way."
Ben's family are now setting up a charitable foundation to give less fortunate youngsters the chance to get into music.