Storing a full mp3 song in MS Access database using c sharp

[coollife]

In an ASP.net Application (windows or web)

can i write code to store the song into MS Access database .

Please Help

[textbox]

I believe storing an MP3 file in a database as a blob would be similar to storing an image file in a database. Neither would I recommend unless you are worried about someone finding the directory and downloading them. Usually it is best practice to store the path to the file in the database and then upload all the files to a directory.

If you have the means, most hosts offer a SQL Server database for 5 or 10 bucks a month. Much better than using Access.

[dnanetwork]

my friend you are really cool just like u r ID..

but its a bad idea storing binary data in the database..

yes it is possible....but it will slow down u r application heavily..

so use u r mp3 wisely....

[Ramesh S]

You can download a sample code from the following link which helps you store binary data into MS Access Database.

http://programming.top54u.com/post/Store-and-Display-Images-from-MS-Access-Database-Using-C-Sharp.aspx

The data type of the column to store binary data in MS Access should be OLE Object.