how to save flow chart icon in database

hii

i need to save flowchart icons which are multiple in database. suggest me some way sothat i can get that data back & show those icon in new flowchart with same cordinates.

ur valuable suggestion will be highly appreciated

robin
robinpkothariAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

northernchillCommented:
In your database, define a table with the following fields:
PosX int, PosY int, IconData blob and any others needed to link the icons to flowcharts.

Store the position of the icon in the PosX and PosY fields, while saving the icon image bytes to the blob.

When you want to retrieve and display the icon again, query the database for the position and data.

If the flow chart to which they will be retrieved and displayed may not be the same size and you want the icons to have the same relative position, change the posX and PosY fields to float and store the position as a percentage of the overall flow chart width and height.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tejas_pathakCommented:
Hi,

i would suggest you to not store those images in database, bcoz, it would slow down ur database operation , its performance, and moreover its better to query an image on a filesystem then from a blob. I've seen many performance critical applications use this methodology.Store the path of the image in the database field , instead.

Bye.
Tejas.
0
tejas_pathakCommented:
Hi,

i would suggest you to not store those images in database, bcoz, it would slow down ur database operation , its performance, and moreover its better to query an image on a filesystem then from a blob. I've seen many performance critical applications use this methodology.Store the path of the image in the database field , instead.

Bye.
Tejas.
0
robinpkothariAuthor Commented:
hii guys...thanx for reply

i think got my answer from "northernchill".....its gr8....

thank u very much

robin
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.