Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
Crystal report displaying varbinary(MAX) on the report
Dorababu Meka
Sep 25 2016 2:16 AM
477
Reply
I am trying to display the varbinary data on a crystal report after converting it to original bytes. The content that I saved is a pdf content. I followed this approach to achieve as per my requirement
http://csharpdotnetfreak.blogspot.com/2012/06/crystal-reports-display-images-database.html
My code is as follows
SqlConnection con =
new
SqlConnection(ConfigurationManager.ConnectionStrings[
"MyCon"
].ConnectionString);
string
strSelect =
"SELECT FileData from Documents where ID = 26"
;
SqlCommand cmd =
new
SqlCommand(strSelect, con);
SqlDataAdapter dAdapter =
new
SqlDataAdapter(cmd);
con.Open();
dAdapter.Fill(dsReport.Tables[
"Documents"
]);
Byte[] bytes = (Byte[])dsReport.Tables[0].Rows[0][
"FileData"
];
dsReport.Tables[0].Rows[0][
"FileData"
] = bytes;
dsReport.AcceptChanges();
con.Close();
CrystalReport1 rpt =
new
CrystalReport1();
rpt.SetDataSource(dsReport);
crystalReportViewer1.ReportSource = rpt;
So can some one help me how can I display byte[] data on to the report
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
Crystal report - complicated sql query
I like to create a sample dynamic telerik report? pls help