Retrieving all images from MS-Access database

Well, the article given to you by Sandeep does describe a way to do it. Thought, I'm unclear exactly what you're trying to do and you didn't say if you were using C# or VB. I can show you some code that I used to extract an image from the database, without writing anything to the disk...which the article given does:

Public Function GetThumbnailFromDb(ByVal DataID As Long) As Image
        'check if the connectionString is already opened
        Dim wasOpen As Boolean = False
        If connectionString.State = ConnectionState.Open Then
            wasOpen = True
        Else
            connectionString.Open()
        End If

        'Create new dataset
        Dim DataDS As New DataSet
        Dim newDataAdapter As OleDbDataAdapter
        Dim sql As String = "SELECT Thumbnail, SizeMode FROM Data WHERE ID = " & DataID & ";"

        newDataAdapter = New OleDbDataAdapter(sql, connectionString)
        newDataAdapter.Fill(DataDS, "Data")
        newDataAdapter.Dispose()

        'if the connectionString wasn't open, close it
        If Not wasOpen Then
            connectionString.Close()
        End If

        'Convert the OleObject to an Image
        Dim result As Image = Nothing
        Dim temp() As Byte

        If Not IsDBNull(DataDS.Tables("Data").Rows(0).Item("Thumbnail")) Then
            temp = DataDS.Tables("Data").Rows(0).Item("Thumbnail")
            result = Image.FromStream(New MemoryStream(temp))
            result.Tag = DataDS.Tables("Data").Rows(0).Item("SizeMode")
        End If

        Return result
End Function

It uses the System.Data.OleDb library. This will extract the image into a form that you can use however you want. If you wanted to show all of the images, you would use your Select statement and just cycle through all of the rows and convert the data.

[Modified]
What in the world is the 1 vote and 2 vote for? Was the information I provided inaccurate?

No!

You tell me what he was asking and provide an answer. I was trying to help in what way I could. If you don't think it answers the question, but is still accurate, give it a 3.

What's with all the negativity!?

Hi :)
Thank's for reply..

ya i took OLEObject datatype for image in ms-access.
i think.., u don't understand my question.

i wana show all images in using this query without passing any parameter like this.

"Select image from dbname"

and i used in GenricHndler file

Public Class pic_handler : Implements IHttpHandler
Public Sub ProcessRequest(ByVal context As HttpContext) Implements IHttpHandler.ProcessRequest
context.Response.ContentType = "image/gif"
Dim strm As Stream = ShowProductImage()
If strm Is Nothing Then
Exit Sub
End If
Dim buffer As Byte() = New Byte(4095) {}
Dim byteSeq As Integer = strm.Read(buffer, 0, 4096)
Do While byteSeq > 0
context.Response.OutputStream.Write(buffer, 0, byteSeq)
byteSeq = strm.Read(buffer, 0, 4096)
Loop
context.Response.BinaryWrite(buffer)
End Sub

Public Function ShowProductImage() As Stream
Dim StrSelect As String = "SELECT pic_Name,pic FROM images"
Dim cmd As OleDbCommand = New OleDbCommand(StrSelect, get_connetion)
' cmd.CommandType = CommandType.Text
' cmd.Parameters.AddWithValue("@ID";, ProImageId)
Dim img As Object = cmd.ExecuteScalar()
Try
Return New MemoryStream(CType(img, Byte()))
Catch
Return Nothing
Finally
conn.Close()
End Try
End Function


And on show.aspx.vb file, on PreRender_event

Sub GetSpecificVideo(ByRef dl_img As DataList)
Try
cmd = New OleDbCommand("SELECT pic_name,pic FROM images",get_connetion)
ole_adp = New OleDbDataAdapter()
ole_adp.SelectCommand = cmd
Dim ds As New DataSet
ole_adp.Fill(ds, "images")
dl_img.DataSource = ds.Tables(0)
dl_img.DataBind()
Catch ex As Exception
Throw New Exception(ex.ToString)
Finally
conn.Close()
End Try

And on show.aspx file

<ItemTemplate>
<asp:Image ID="Image1" ImageUrl='<%"pic_handler.ashx?"+Eval("Video_pic",{0})%>' runat="server"/>
</br>
<%#Eval("Video_name")%>
</ItemTemplate>

this is the summary

i could not finding my error..
Is it neccessary to pass parameter in genrichandler file?
if yes then
pls tell me

Thank's again :thumbsup: