In an ASP.net Application (windows or web)
can i write code to store the song into MS Access database .
Please Help
coollife -4 Junior Poster in Training
textbox 0 Light Poster
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 18 Practically a Master Poster Banned
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....
sknake commented: You're an idiot. There is nothing else that can be said. -2
serkan sendur commented: moron vs idiot i dont remember the precedence -1
Ramesh S 129 Posting Pro
You can download a sample code from the following link which helps you store binary data into MS Access Database.
The data type of the column to store binary data in MS Access should be OLE Object.
sknake commented: very helpful +9
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.