I stumbled across this great tutorial by Brad Adams, titled ‘Islands of Richness with Silverlight on an ASP.NET page‘. Step by step it walks you through using and customising the ASP.NET MediaPlayer control and shows your how video can be added to an ASP.NET website.
Addendum: On the subject of Silverlight, this is an interesting development from Microsoft.