Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Place an Image on MSSQL Server

Posted on 1997-06-02
1
Medium Priority
?
254 Views
Last Modified: 2010-04-06
How do I place a bitmap Image on the MSSQL Database with the datatype image?
Could someone please show me an example?
0
Comment
Question by:denny050397
1 Comment
 

Accepted Solution

by:
brittain earned 400 total points
ID: 1336758
This actually isn't as difficult as you may think using BDE and data aware controls.

Create the table / column with Image as the datatype.  Create a BDE alias, and hook up in the traditional TQuery/TTable, TDatasource manner.  

To get the bitmap you want INTO the database just use the LoadFromFile() method of the TDBImage class's Picture property.

When you post using the navigator or a TDataSet.Post() method, the BDE writes the graphic to the database.

0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

926 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