Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
How to display image from access database 2007 although all
ahmed salah
Mar 8 2017 5:13 PM
212
Reply
How to display image from access database 2007 to rdlc although all data display in rdlc
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();
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 .
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
extender control is not registered.
How to show data horizontally not vertically in rdlc