Retrieving OLE Object image from access database using VB.NET

See more:

VS2008

VB

Visual-Studio

Hello friend,

I am having problem retrieving ole object binary data from access database into picture box,

Table_name: Bio_data_ND1
i have a unique column called: regno
then column where the picture reside: picpath


actual i did a little work, but honestly it misbehaved. i used this codes:

Private Sub display_result_ND1()
       Try

Dim adp As New OleDb.OleDbDataAdapter("select * FROM Bio_data_ND1 WHERE regno='" & TxtSearch.Text & "'", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\ResultPrc.mdb;Persist Security Info=True")
            Dim ds As New DataSet
            adp.Fill(ds, "Bio_data_ND1")
            Dim bytes() As Byte = ds.Tables("Bio_data_ND1").Rows(0).Item("picpath")
            Dim img As Image = Image.FromStream(New System.IO.MemoryStream(bytes))
            PictureBox2.Image = img


        Catch ex As Exception
            MsgBox(ex.Message)
        End Try
end sub

but the WHERE clause is not working, whenever i try selecting it gives me only the last record stored in the database,

i dont know if the is a little mistake that i need to correct

if any please help.

thanks.