Forum     

Go Back   Digit Technology Discussion Forum > Portables, Peripherals and Electronics > QnA (read only)
Register FAQ Calendar Mark Forums Read

QnA (read only) Mods please help transfer the contents of this forum to proper sections. :)


 
 
LinkBack Thread Tools Search this Thread Display Modes
Old 10-12-2005, 09:10 PM   #1 (permalink)
Right Off the Assembly Line
 
Join Date: Dec 2005
Location: kerala
Posts: 13
Default picture in database


can we store pictures in sql database.. if yes how?
rkharikrishnan is offline  
Advertisements. Register and be a member of the community to get rid of them.
Advertisement

Old 10-12-2005, 11:06 PM   #2 (permalink)
Broken In
 
Join Date: Sep 2004
Location: Mangalore, Karnataka
Posts: 180
Default Re: picture in database

Quote:
Originally Posted by rkharikrishnan
can we store pictures in sql database.. if yes how?
I heard that its possible. But even I don't know HOW :roll: ? Any help from experts?
alanpaladka is offline  
Old 10-12-2005, 11:20 PM   #3 (permalink)
Alpha Geek
 
choudang's Avatar
 
Join Date: Sep 2005
Location: Guwahati
Posts: 812
Default

as per i know, we can store the path of the image. i did like this... created one folder e.g. PIC and put into req. images, added one column as PIC in the table and insert the path. after that i retrieve the link using recordset and put the link into the image box in VB. i know only this much
__________________
For every action, there is an equal and opposite criticism.
choudang is offline  
Old 10-12-2005, 11:47 PM   #4 (permalink)
Coming back to life ..
 
it_waaznt_me's Avatar
 
Join Date: Nov 2003
Location: A bit closer to heaven
Posts: 1,997
Default

You can store images as binary or as LOB in Oracle.. Check this ..
__________________
Sleight of hand and twist of fate...
On a bed of nails she makes me wait...
And I wait without you ...
With or without you ..
----
Batty = Too Busy Now !!!
it_waaznt_me is offline  
Old 10-12-2005, 11:55 PM   #5 (permalink)
Apprentice
 
Join Date: Feb 2005
Location: Pune
Posts: 75
Default

In Access, you can set the field porperty to OLE Object. Then when you insert data in fields, you insert an OLE object including pictures (Insert->Object).

Hope this is what you wanted.
LordDJ is offline  
Old 11-12-2005, 12:25 AM   #6 (permalink)
Right Off the Assembly Line
 
Join Date: Dec 2005
Location: kerala
Posts: 13
Default

i want to do in sql server
rkharikrishnan is offline  
Old 11-12-2005, 02:09 AM   #7 (permalink)
Wise Old Owl
 
desertwind's Avatar
 
Join Date: Nov 2004
Location: Hyderabad
Posts: 1,096
Default

This link may help.
__________________
Sometime you'll think you understand everything

...Then you'll regain consciousness
desertwind is offline  
Old 11-12-2005, 10:43 AM   #8 (permalink)
Right Off the Assembly Line
 
Join Date: Jun 2005
Posts: 46
Default

i don't believe its possible.
but am not sure about it
calvin is offline  
Old 11-12-2005, 11:33 PM   #9 (permalink)
Right Off the Assembly Line
 
Join Date: Dec 2005
Location: kerala
Posts: 13
Default

thanks desertwind.. i got the required in code project. thanks for the link
rkharikrishnan is offline  
 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


 
Latest Threads
- by Charan
- by Sujeet
- by ico
- by Tenida
- by gohan89
- by clinton

Advertisement




All times are GMT +5.5. The time now is 10:37 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.

Search Engine Optimization by vBSEO 3.3.2