Crystal report displaying varbinary(MAX) on the report

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dorababu Meka10y ago
I am not displaying image I want to display PDF content which was stored in bytesI have gone through these links already, even the link I posted is doing the same thing. I need a different requirement
0
Delpin Susai Raj10y ago
http://www.codeproject.com/Questions/187663/Image-display-in-a-crystal-report
0
Delpin Susai Raj10y ago
https://msdn.microsoft.com/en-us/library/ms156388(SQL.105).aspx
0