Solved

Place an Image on MSSQL Server

Posted on 1997-06-02
1
249 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 200 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Downloading email attachments 2 74
select query - oracle 16 100
How to create virtual printer while installing my application 5 53
Tvertscrollbox like a whatsapp layout 5 28
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

825 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