inserting pictures into access database

[steve_rm]

Hello

I am creating a c# application that will use access database. The application is about a property agent that has details of houses for sale.

My question is, how do you store the pictures in access, and how can you add and delete them from C# application

A example program will be most gratefull.

Many thanks in advance

Steve

[Memnoch1207]

Here is a photo album (stores and retrieves images from a database) written in C#.

C# Photo Album

[hellswraith]

You may not want to store the image in the database directly. Instead, create a folder to save the images to, and then store that file path in the database. This will yield much better performance.

[MasterBlaster]

Originally posted by hellswraith
You may not want to store the image in the database directly. Instead, create a folder to save the images to, and then store that file path in the database. This will yield much better performance.

What Hellswraith said, and If you only store the path in the database you can store the images on Network drives, cd's ect. Then your app will not limited by the size of the disk Access is on. Image databases like to eat up disk space.

[steve_rm]

thanks for your help.

There is one more question.

I am using a numericUpDown control to allow the users to insert numbers.

But l am having trouble saving and retrieving them from the database.

This is the code l am using so far

numNoBedrooms.value = m_dtHouses.Rows[m_rowPosition]["Bedrooms"].ToString();

m_dtHouses - is the data table
m_rowPosition - is the current record

Thanks in advance

Steve

[steve_rm]

Just one more question.

I think storing the path in the database is the best way to do it. But in the database what data type do l set the field to.

My pictures are in a folder called: c:\Houses\pictures.

Thanks in advance

Steve

[CornedBee]

On the other hand, if you store the images outside the database, you can't simply distribute one file with all the data, it's bound to be a group of files.

[steve_rm]

Thanks for you help

But is it possible to have some code examples

Thanks


Steve

[steve_rm]

Hello

Still need help with this.

[CornedBee]

I haven't done database handling in ages, so I don't have examples.