Storing images

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Storing images

I've read the documentation, but I'm in a quandry as to the best way of
storing images.

Is it in a blob field? blob fields seem to lack necessary information like
titles and keywords.

I've read elsewhere - I cannot find the source - that it is better to store
images - photos, maps, and so on in a file. This seems to have similar
problems. The photo would only have an identifier. It seems I'd have to
have another table(s) that would point to the identifier, the topicid,
keywordsetid, and another related table for keywords.

Another problem is where in the solution to keep this file so that
click-once deployment still works.

Obviously I'm just feeling this out.

Can someone point me in the right direction?

dennist685
 
Dennist,

In my opinion does the best never exist.

For the deployment are we talking about a server situation, so there will be
in my idea not really a click once situation (except if you are talking
about stand alone single client databases as ms-Access or MSDE).

In my opinion is the most optimum if you want to keep your original images
(or whatever that has a huge size) as a reference to the file in your
database, which has another field to store the thumbnails of the pics. Than
you get the 'best' of both worlds.

Just my opinion.

Cor
 
In the end, you're right, Cor. But in the meantime I'm using msacess. Even
when I'm using sqlserver, I'm not clear of where to place the photos or maps,
and how to number them. I'll have to have a separate table to point to them,
along with a topicid, conceptid and keywordid. Then I'll need yet another
related table to include the keywords. Won't this slow things down
tremendously?

dennist685
 
Dennist,

Saving hugh pictures in a database is terrible slow, therefore in a access
probably even slower.

The identifiing system you want to use is your choise. I go for the original
names, however your suggesting creating a kind of autonumer or guid for that
is as well not bad in combination with thumbnails and the original names in
a seperated field.

The place of the files is of course just a choose depending on the use. As I
understand it now than it is of course a submap from the personal folders.

I hope this helps,

Cor
 
Cor,

I have yet another question.

I can't figure how to address the photo or map. Just for argument's sake,
suppose I'm storing the images in
c:\vs2005projects\hasbara\hasbara\bin\release\images.

Suppose further that the image name is Nablus.jpg. Furthermore, I've opened
a form displaying my keywordsets. With each move of the bindingource, I want
to display the images assigned to the keywordset.

How would I do that. Assume I have the tables and relationships set up.
That I can do.

thanks again.

dennist685
 
dennist,

I don't know if you have the Northwind sample from SQL, have than a look at
the datatable employees

Cor
 
cor,

thanks a lot for your help. Now that your mention it I remember the
northwind sample, including the pictures.

I made a form, and then to my great surprise(vs 2005 beta2), couldn't find a
picture box or anything similar. So I used a panel. Doesn't do what I want,
but that I'll address in the vs2005 windows controls forum.

Maybe I'll have to buy a third party picture box. If you have any
recommendations - that work with vs2005b2- let me know.

dennist685
 
Dennist,

I see really the picturebox in my version of 2005.

If it is not there than righclick the toolbox than you can probably add it.

Cor
 
Back
Top