I have a problem, displaying pictures from database onto report, i put the picture there but it is not showing at all when i run and view, is there something i am not doing right.
The
VB.Net code I used to store image in access database ( ref. field Name "Logo" type "OLEObject"
'Read Blob Image Data to Byte Array
'===========================================
Dim FileStreamObject As New System.IO.FileStream(Trim(txtLogoIMG.Text), IO.FileMode.Open, IO.FileAccess.Read)
Console.Write(FileStreamObject.Length)
Dim PictureByteArray(CType(FileStreamObject.Length() - 1, Integer)) As Byte
FileStreamObject.Read(PictureByteArray, 0, PictureByteArray.Length)
FileStreamObject.Close()
'===========================================
.
.
.
.
.
'Write Blob Image data to Access Databse
objData.AddParameter("@Logo", OleDb.OleDbType.LongVarBinary, PictureByteArray.Length, PictureByteArray)
Here objData is class object ie. I am using to data operations, "AddParameter" is a member proc.
Public Sub AddParameter(ByVal Name As String, ByVal Type As OleDbType, _
ByVal Size As Integer, ByVal Value As Object)
Try
Command.Parameters.Add(Name, Type, Size).Value = Value
Catch OleDbExceptionErr As OleDbException
Throw New System.Exception(OleDbExceptionErr.Message, _
OleDbExceptionErr.InnerException)
End Try
End Sub
Kind Regards
Aneesh Sankar