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

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

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

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

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

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us