Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2005-11-03 : 20:05:50
|
| How to save graphic file such a gif or jpg file into SQL server directly from scanner? |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-03 : 23:47:37
|
| One of the easiest ways is to store the path of the file than the file itself then using file system object you can retreive the image and show it in your presentation layerMadhivananFailing to plan is Planning to fail |
 |
|
|
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2005-11-04 : 10:57:46
|
| Very interestin. You mean save all graphic files into a folder of server and then save path and file name into SQL db? |
|
|
|
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2005-11-04 : 10:58:26
|
| Can you teach me more detail? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-05 : 00:16:13
|
quote:
Originally posted by Sun Foster
Very interestin. You mean save all graphic files into a folder of server and then save path and file name into SQL db?
Yes I meant itMadhivananFailing to plan is Planning to fail |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-11-05 : 05:00:58
|
| Saving images in a db is known as BLOB. Which really is a bad design. As Madhivanan said, save it in a folder and save the relative path in your tablesand in your page use a virtual path such as /images/db/<%database_path or filename%>hope this helps |
|
|
|
|
|
|
save gif, jpg file