How do I retrieve an image from an access database in visual studio?

Question

1.00/5 (1 vote)

See more:

, +

I'm trying to retrieve an image stored in an Access Database to a Picturebox. I have successfully managed to store the image into the database using OLE Object, I'm not very fluent with this language, but my current code is as follows:

What I have tried:

VB

Private Sub lstUsers_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lstUsers.SelectedIndexChanged

    Dim dt As New DataTable

    dt = runSQL("Select * from tblUser where UserName = '" & lstUsers.SelectedItem.ToString & "'")

    txtForename.Text = dt.Rows(0)(2)
    txtSurname.Text = dt.Rows(0)(3)
    txtCode.Text = dt.Rows(0)(6)
    txtFinish.Text = dt.Rows(0)(7)
    PictureBox1.Image = dt.Rows(0)(8)

End Sub

When I try to run this and I select a username I get the following error message:

VB

Unable to cast object of type 'System.Byte[]' to type 'System.Drawing.Image'.

Any help would be appreciated.

Posted 8-Jan-17 22:38pm

Sh.Zakria

Updated 8-Jan-17 23:00pm

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sunasara Imdadhusen · Answer 1 · 2017-01-08T22:48:00

Solution 1

You can not directly assign byte array to image object. First you have convert byte array to image object and then you can.
following is the solution: C# vresion

C#

byte[] data = (byte[]) dt.Rows(0)(8);
using (MemoryStream ms = new MemoryStream(data ))
{
pictureBox1.Image = Image.FromStream(ms);
}

Vb.Net version:

Dim data As Byte() = DirectCast(dt.Rows(0)(8), Byte())
Using ms As New MemoryStream(data)
	pictureBox1.Image = Image.FromStream(ms)
End Using

Regards,
Imdadhusen

Posted 8-Jan-17 22:48pm

Sunasara Imdadhusen

Updated 8-Jan-17 23:03pm

v2

Comments

Sh.Zakria 9-Jan-17 5:00am

When I paste this code on my program right below txtFinish.Text = dt.Rows(0)(7), the words byte and memoryStream are underlined in blue. Do I have to translate your code into a visual basic statement?

Sunasara Imdadhusen 9-Jan-17 5:04am

i have added vb.net code style, you can use this one. if reference is not available in the project then you must have to add approvpriate reference from the project.

Sh.Zakria 9-Jan-17 5:08am

PictureBox1.Image = Image.FromStream(ms)---Parameter is not valid.

Sunasara Imdadhusen 9-Jan-17 5:15am

Check this link for more info http://net-informations.com/q/faq/imgtobyte.html

Wendelius · Answer 2 · 2017-01-08T22:50:00

You cannot place the binary image data directly picturebox, you first need to create the image object from the data.

There's a nice article about this. See: Save and Retrieve Image from a SQL Server Database using VB.NET[^]

Don't worry if the database is SQL Server, the idea for the image is the same.

OriginalGriff · Answer 3 · 2017-01-08T23:00:00

There are a number of problems here: first off never concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Use Parametrized queries instead.
Second, never use SELECT * FROM - always specify exactly which columns you want to retrieve, and the order in which you want them. That way, you don't transfer data you don't need - which saves bandwidth - and your code becomes more immune to changes on the database causing it to crash because the column order is different, or worse corrupt data. This is particularly important if you use numeric indexes to retrieve column content instead of string based column names.
Thirdly, don't use a DataTable to retrieve a single user details - use a DataReader instead, it's a lot more memory efficient - and check the return to make sure there is data before you try to access it! If there is no user with that name, your code crashes and burns...
Fourthly, do not use the code in Solution 1: the documentation for Image.FromStream Method (Stream) (System.Drawing)[^] is very specific that the stream must remain open for the life of the image, which the using block does not allow.

VB

Dim ms As New MemoryStream(bytes)
Dim useThisImage As Image = Image.FromStream(ms)

How do I retrieve an image from an access database in visual studio?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0