Streaming WAV files from SQL Server into a Web Page

Question

User1137346421 posted

Hi,

We are storing the WAV file into a database table as VARBINARY(MAX). We want to play the WAV file directly in a web page. We want to use PLAY, PAUSE and STOP for these WAV files.

We want the user to have a Control on the page to play the WAV file.

Here we DO NOT want to store the FILE in the Web Server's file structure. It is againt the SECURITY policy.

We tried different ways. Nothing is working. We used SoundPlayer class. Using this, we can only PLAY and STOP but can not PAUSE the WAV file.

Please help. Thanks in advance for any help.

Take care
B

Answer 1

User2130758966 posted

Hey,

You should look for a flash player to handle the playing of the wav files.

I guess you would need to set up some kind of webservice to stream the data in from the database to the flash?

Answer 2

User-952121411 posted

Silverlight, Silverlight, Silverlight!  This MSFT based approach handles everything you just mentioned between SQL Server, WCF, and a Silverlight MediaPlayer.  Using a product like Microsoft Expression Encoder (even just the trial) will allow you to generate or use a radio (still a Media Element just no video screen) template that handles all of the functionality you need.

If for any reason you need to go old school and can not use Silverlight, then you could embed a Windows Media Player <Object> tag in your web page and wire up the functionality.  Either way there is no sense in trying to do any of this from scratch as it has been done hundreds of times over and all of the code and examples are out there to get you going.  Here are some Silverlight Links to help you:

Silverlight Audio Player: (out of the box already done for you example):

http://slaudioplayer.codeplex.com/

Learn Silverlight Videos:

http://www.silverlight.net/learn/videos/all/ 

Silverlight, WCF, and Streaming My Personal Music Repository from IIS:

http://www.integratedwebsystems.com/2009/04/silverlight-wcf-and-streaming-my-personal-music-repository-on-the-go/

Silverlight Forums: (all the help you will need to get your Audio Player up and running)

http://forums.silverlight.net/default.aspx

...if you can't use Silverlight, try a Windows Media Player:

Embedding Windows Media Player into a web page: (scroll down on page there is a gap)

http://www.geekpedia.com/tutorial152_Embedding-Windows-Media-Player-into-a-web-page.html

Windows media player in asp.net:

http://forums.asp.net/p/1008929/2684077.aspx

How to embed WMP in asp.net pages:

http://dotnetsoldier.blogspot.com/2007/02/how-to-embed-wmp-in-aspnet-pages-and.html

Media Player Object Properties:

http://msdn.microsoft.com/en-us/library/dd564034(v=VS.85).aspx

 

Hope this helps!