insert images into database

a_sadig84 · June 14th, 2009, 08:29 AM

Hello Mr.Thearon,

First, Thanks for the thorough explanation.

I encounter a problem with inserting image into database.
I define a DataColumn in the dataset with byte data type "BL Component" & image data type in SP "Data Access Component"
I convert the image to array of bytes and pass it to a dataset.

Code:

       'objDataColumn = New DataColumn("Photo", Type.GetType("System.Byte"))
        'objDataTable.Columns.Add(objDataColumn)

The problem is "cannot convert from byte() to byte"

Hope you can help

Ahmed

Thearon · June 23rd, 2009, 06:45 AM

Ahmed,

Go to the Wrox web site and download the code for Visual Basic 2005 Instant Results. I wrote an entire application that does nothing but manages images in a SQL Server database. Perhaps that code can guide you in the right direction.

Let me know if there are any further questions or problems.

Thearon