Click here to Skip to main content
15,905,419 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi guys i try to show more pictures in crystal reports but my version of crystal report not allow to me to make link pictures meaning
picture tab not have graphic location formula in crystal report
Now what i do to solve this problem
i try from code to do that it working from code below but
first picture repeating in next rows
my code as following (only show one picture)
C#
DataTable dt = new DataTable();
string connString = "data source=192.168.1.105; initial catalog=hrdata;uid=sa; password=1234";

using (SqlConnection con = new SqlConnection(connString))
{
    con.Open();
    SqlCommand cmd = new SqlCommand("ViewEmployeeNoR", con);
    cmd.CommandType = CommandType.StoredProcedure; 
    SqlDataAdapter da = new SqlDataAdapter();
    da.SelectCommand = cmd;
    da.Fill(dt);
} 

FileStream fs=null;
fs = new FileStream("\\\\192.168.1.105\\Personal Pictures\\" + ".jpg", FileMode.Open);
BinaryReader br = new BinaryReader(fs);
byte[] imgbyte = new byte[fs.Length + 1];
imgbyte = br.ReadBytes(Convert.ToInt32((fs.Length)));

foreach (DataRow dr in dt.Rows)
{
    dr["Image"] = imgbyte;
}

ReportDocument objRpt = new Reports.CrystalReportData2();
objRpt.SetDataSource(dt);
crystalReportViewer1.ReportSource = objRpt;
crystalReportViewer1.Refresh();

Now what modification i must do to prevent first picture from repeating in next records
Crystal report show ID AND Image
Posted
v2

1 solution

C#
foreach (DataRow dr in dt.Rows)
{
    dr["Image"] = imgbyte;
}

Actually, here you are assigning the same image to all the Rows on Column "Image". That's why it is repeating. You should assign different images to every row or something like that according to your requirements.
 
Share this answer
 
Comments
ahmed_sa 18-Feb-15 7:24am    
Thank you for reply what modification id in code to accept
show all pictures for employees
if possible help me
Where exactly you have saved the image? In Database or File System?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900