Last post Mar 09, 2017 01:07 AM by Chris Zhao
Mar 08, 2017 10:59 PM|ahmed.barbary|LINK
I have problem in display image from access 2007 database to rdlc
i work in c# vs2015
Actually i need to display image from database to more records from access 2007
but i cannot
in rdlc i do as following :
drag image control to
report source database
mime type jpeg
set EnableExternalImages = true
=First(Fields!qrimg.Value, "DataSetImage") for value
Name as Name of column in dataset .
on database qrimg image store datatypE OLEOBJECT
in button click view report
reportViewer1.LocalReport.EnableExternalImages = true;
QrClasses q = new QrClasses();
DataSetImage printexcel = q.GetDataImage();
ReportDataSource datasource = newReportDataSource("DataSetImage", printexcel.Tables);
using (OleDbConnection con = newOleDbConnection(connection))
using (OleDbCommand cmd = newOleDbCommand("SELECT UserID,UserNameAR,CountryAR,MemberAR,qrimg FROM AllPrinting"))
using (OleDbDataAdapter sda = new OleDbDataAdapter())
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataSetImage dsimage = new DataSetImage())
Final result i can show all data from access 2007 in report but image cannot display
can any one help me please if possible
i do every thing but really cannot show image .
Mar 09, 2017 01:07 AM|Chris Zhao|LINK
To remove the OLE header from an Access image
1. Add an image from an Access data source as described in the previous procedure.
2. In the Image Properties dialog box, click the expression (fx) button.
3. In the Expression dialog box, copy the following expression, with no line breaks, into the expression pane:
The expression uses Mid to exclude the header information, which resides in the first 105 characters of the file, and then uses Convert to make the rest of the image base64 encoded. The expression assumes that the image originates in an EN-US database. If
you are using a different collation, the OLE header might be longer or shorter than 105 characters.
4. Click OK twice.
An image placeholder appears on the report design surface.