TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
ahmed salah
NA
530
148.7k
How to display image from access database 2007 although all
Mar 8 2017 5:13 PM
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 .
Reply
Answers (
1
)
extender control is not registered.
How to show data horizontally not vertically in rdlc