storing video in sql

You can follow this approach: File Upload with ASP.NET[^], but as videos tend to be large files, I suggest not using the database itself. SQL Server is providing a really usefull architecture, called filestream[^]. It is a combination of the database and the file system, thus you have the advantages of both. This tutorial has it flaws, but it is a good starting point: How Do I: Use SQL File Stream[^], and I would also read this one two: http://msdn.microsoft.com/en-us/magazine/dd695918.aspx[^].

I dont suggest you to store video/audio in sql server, it is not built for streaming video/audio, you will have to retrieve it from sql server to a temp folder and then stream it using IIS smooth streaming or something. so it is waste of resources.

I will suggest you to store only meta-data along with the path of the audio/video file in database, and store the files on hard drive. so that you can search the video information from database and then use the path to get the video/audio from hard drive.

I will even do not vote for storing images in database, if they are many.

But if you do not have any option then go ahead with the solutions provided by others.