dotnet academic: I want to allow teachers who use my web application to upload videos that
demonstrate a skill. I would like to store these videos in a SQL Server
database and display them on a page for students to view. These videos would
obviously be in different formats. Any ideas on how to do this? Thanks,
David

Hi David,

I've done something similar, but with audio files. I used the Windows Media
SDK to create a component for reading the meta data from the file, then
store the meta + the binary audio file in SQL Server. In addition, I would
store the mime-type of the file so I new how to send it to the client. The
audio file was stored in VarBinary field.

I would present the meta data to the user to allow them to create play
lists, where the play list was a list of requests to a web form designed to
take a unique identifier, query the database for the particular file, then
stream it back out. When streaming out the file, you need to specify the
mime-type prior to sending the data. It will then be up to the user to
determine how to play the file.

Jeff.

[quoted text, click to view]