How to save Video, Audio, Image and text files into a database(sql server 2005)?

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

I Want to save a Video, Audio, Image and text files into a sql server 2005 database???
is it possible???and also possible for retriving it?? ans me asap.........

Posted 31-Jan-12 23:10pm

Gopinath1005

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rajesh Anuhya · Answer 1 · 2012-01-31T23:13:00

Solution 1

Use the BLOB data type to store the Video,Audio, Image files in the Database.
go through the below links.

http://msdn.microsoft.com/en-us/library/ms378813.aspx[^]
http://databases.about.com/b/2007/10/24/sql-server-binary-large-object-blob-data-types.htm[^]

Thanks
--RA

Posted 31-Jan-12 23:13pm

Rajesh Anuhya

Comments

Abhinav S 1-Feb-12 5:17am

5 of course. I tool longer to find some links.

Rajesh Anuhya 1-Feb-12 5:17am

Thanks Abhinav
--RA

Gopinath1005 1-Feb-12 5:21am

Hi Mr.Rajesh first of all thanx for yur ans...
if yu don mind,can yu pls give me some samples for storing this kinda files in database(sql server 2005)

thatraja 1-Feb-12 11:42am

Didn't you check those links? It'll work in SQL server 2005 too

Rajesh Anuhya 2-Feb-12 1:12am

Sure it will work..
--RA

Member 14733954 8-Sep-20 10:14am

Thanks

thatraja 1-Feb-12 11:41am

5!

Rajesh Anuhya 2-Feb-12 1:11am

Thanks Raja
--SA

Abhinav S · Answer 2 · 2012-01-31T23:16:00

Solution 2

You need to use a BLOB type field.
Go through
http://support.microsoft.com/kb/326502[^]
http://www.akadia.com/services/dotnet_read_write_blob.html[^]
http://www.akadia.com/services/dotnet_load_blob.html[^]
Store and retrieve objects as BLOBs in SQL Server 2000 and 2005 using ASP.NET 2.0[^]

Posted 31-Jan-12 23:16pm

Abhinav S

Comments

Gopinath1005 1-Feb-12 5:42am

Hi Mr.Abhinav first of all thanx for yur ans...
if yu don mind,can yu pls give me some samples for storing this kinda files in database(sql server 2005)

thatraja 1-Feb-12 11:42am

Didn't you check those links? It'll work in SQL server 2005 too

thatraja 1-Feb-12 11:41am

5!

Abhinav S 1-Feb-12 22:28pm

Thank you thatraja.

Member 12855697 · Answer 3 · 2017-02-12T18:48:00

Solution 3

<code><big>t6t</big>

Posted 12-Feb-17 18:48pm

Member 12855697

Updated 12-Feb-17 18:50pm