Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

how to save flow chart icon in database

Posted on 2003-03-21
4
Medium Priority
?
306 Views
Last Modified: 2010-04-17
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
0
Comment
Question by:robinpkothari
  • 2
4 Comments
 
LVL 2

Accepted Solution

by:
northernchill earned 300 total points
ID: 8181638
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
 

Expert Comment

by:tejas_pathak
ID: 8185407
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
 

Expert Comment

by:tejas_pathak
ID: 8185412
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
 

Author Comment

by:robinpkothari
ID: 8194699
hii guys...thanx for reply

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

thank u very much

robin
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
If you are a mobile app developer and especially develop hybrid mobile apps then these 4 mistakes you must avoid for hybrid app development to be the more genuine app developer.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question