[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 255
  • Last Modified:

Place an Image on MSSQL Server

How do I place a bitmap Image on the MSSQL Database with the datatype image?
Could someone please show me an example?
0
denny050397
Asked:
denny050397
1 Solution
 
brittainCommented:
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

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now