how to store image, music and video files in database

[odejide]

hey guys i am working on a project that invovles storing image, music and video files in a database. i would appreciate if anybody can tell me how to save and retrieve the files to and from the database. thanks
i use VS 2008, WPF C sharp.
thanks in advance.

[dannystommen]

You need to use a BLOB (Binary Large Object) field.

[zips]

We store such files in one column of a database table. The column has type varbinary(max).

[kabben]

Just a thought, but alternatively you can store the data elsewhere and just store the path to the data in the DB. Not sure what your application is but thought it worth mentioning. I've had horrible problems with storing large media files in a DB, it slow's things down far too much over a network and is even more of a pain to backup.

Just a thought, please take no offence.

Regards