How to save images in SQL Server 7 database 3

[nimsam]

I need to save a images (pictures) in SQL Server 7 database in my VB application

I used backend as Sql server database and frontend is a VB

In this case i have defined one data filed as a image type in sql server database

I would like to save & retrive the photos from my vb application.

can any body help me to how to save and retrive the photos from sql database

Please write some vb code for doing it

Thanks in advance

 

[miq]

hi,
Best way to do this is save path for files rather then storing them in database. Saving them in database would make database grow. Also, I would be more diffucult to retrieve image file.

simply store path address to a perticular image and in your vb application get field contents that contain path info. use loadpicture method to load that picture in picture box or image box.

like : picture1.picture loadpicture(path + filenme)

However, you can retrieve images stored in a database using ADO. check
for Appendchunk and getchunk methods.


For details Post this thread at Visual Basic 6 Forum.




Bye
miq

 

[tlbroadbent]

Please don't ask us write your code for you. That is not the purpose of this forum. We will try to answer specific coding questions but you need to write the code.

Here are some links that you may find helpful. You may want to post additional questions in the VB 5/6 forum.

How to upload images or binary files into SQL Server tables?

http://vyaskn.tripod.com/programming_faq.htm#q5

HOWTO: Access and Modify SQL Server BLOB Data by Using the ADO Stream Object

http://support.microsoft.com/default.aspx?scid=KB;en-us;258038

HOWTO: Read and Write BLOBs Using GetChunk and AppendChunk

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q194975

Retrieve binary data from SQL Server via ADO's Stream object

http://www.a1vbcode.com/vbtip.asp?ID=97

Return of the BLOB

http://www.storageadmin.com/Articles/Index.cfm?ArticleID=20460

Copy text or image into or out of SQL Server

http://www.mssqlcity.com/Articles/KnowHow/Textcopy.htm

DBImage.dll

http://www.chriscrawford.com/DBImage/DBImage.htm

You may also find some of the postings in the SQL Server forum to be enlightening. Do a keyword search of this forum. Here are some of those threads.

thread183-247490, thread183-32427,
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.