0

I have problem in display image from access 2007 database to rdlc

i work in windows form 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 :

In RDLC

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 .

In dataset

qrimg system.Byte[]

on interface

in button click view report

reportViewer1.LocalReport.EnableExternalImages = true;

QrClasses q = new QrClasses();

DataSetImage printexcel = q.GetDataImage();

ReportDataSource datasource = new ReportDataSource("DataSetImage", printexcel.Tables[0]);

this.reportViewer1.LocalReport.DataSources.Clear();

this.reportViewer1.LocalReport.DataSources.Add(datasource);

this.reportViewer1.RefreshReport();

view sourceprint?

public DataSetImage GetDataImage()

{

using (OleDbConnection con = new OleDbConnection(connection))

{

using (OleDbCommand cmd = new OleDbCommand("SELECT UserID,UserNameAR,CountryAR,MemberAR,qrimg FROM AllPrinting"))

{

using (OleDbDataAdapter sda = new OleDbDataAdapter())

{

cmd.Connection = con;

sda.SelectCommand = cmd;

using (DataSetImage dsimage = new DataSetImage())

{

sda.Fill(dsimage, "DataTable1");

return dsimage;

}

}

}

}

}

**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 .

2
Contributors
1
Reply
10
Views
3 Months
Discussion Span
Last Post by rproffitt
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.