Retrieve images from database and display in list view

Question

3.40/5 (2 votes)

See more:

I have path and its image in a table like

C:\Users\Public\Pictures\Sample Pictures\Koala.jpg <binary data="">
C:\Users\Public\Pictures\Sample Pictures\Jellyfish.jpg <binary data="">

I need to retrieve images from database and display in listview

Can any 1 help !!

Thanks in advance

I used the below code

VB

    qry = ""
    qry = "SELECT Image FROM  T_ImageStore"
    Dim adp As New OleDbDataAdapter
    adp.SelectCommand = New OleDbCommand(qry, conn)
    Dim ds As New DataSet()
    adp.Fill(ds, "BLOBTest")
    Dim c As Integer = ds.Tables("BLOBTest").Rows.Count
    Dim bytBLOBData() As Byte = _
           dt.Rows(c - 1)("Image")

    PictureBox1.Image = convertbyteArrayToImage(bytBLOBData)

Private Function convertbyteArrayToImage(ByVal byteArrayIn As Byte()) As Image
    Dim ms As MemoryStream = New MemoryStream(byteArrayIn)
    Dim returnImage As Image = Image.FromStream(ms)
    Return returnImage
End Function

i get error:

An unhandled exception of type 'System.ArgumentException' occurred in System.Drawing.dll

Additional information: Parameter is not valid

Posted 7-Oct-13 21:58pm

Usha Muhunthan

Updated 9-Oct-13 3:16am

Kschuler

v2

Add a Solution

Comments

Kschuler 8-Oct-13 13:57pm

Is the actual image in the database, in a blob field? Or is it just a string of the path it's located in? If the image is IN the database, you should research blobs (Binary Large Objects) If not, then just use System.IO classes to open and/or work with the image files.

Usha Muhunthan 9-Oct-13 1:17am

I have saved image by converting to Binary data, There is no path saved in DB

Usha Muhunthan 9-Oct-13 1:48am

I used the below code

qry = ""
qry = "SELECT Image FROM T_ImageStore"
Dim adp As New OleDbDataAdapter
adp.SelectCommand = New OleDbCommand(qry, conn)
Dim ds As New DataSet()
adp.Fill(ds, "BLOBTest")
Dim c As Integer = ds.Tables("BLOBTest").Rows.Count
Dim bytBLOBData() As Byte = _
dt.Rows(c - 1)("Image")

PictureBox1.Image = convertbyteArrayToImage(bytBLOBData)

Private Function convertbyteArrayToImage(ByVal byteArrayIn As Byte()) As Image
Dim ms As MemoryStream = New MemoryStream(byteArrayIn)
Dim returnImage As Image = Image.FromStream(ms)
Return returnImage
End Function

i get error:

An unhandled exception of type 'System.ArgumentException' occurred in System.Drawing.dll

Additional information: Parameter is not valid

Can u help in this

RedDk 9-Oct-13 11:23am

Repost.

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)