First picture repeating in next rows problem what wrong code

Question

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)
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

Vikram Agrawal · Answer

Hi ahmed sa you can use one default pic for all employees. Display this default pic for all those employees who don't have any pic. If employee have any associated image then display that image. Thanks.

ahmed sa · Answer

Are there are any way to show Employees not have pictures

ahmed sa · Answer

for (int i=0; i <= dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; FileStream fs = null; fs = new FileStream(\\192.168.1.105\Personal Pictures\ + dr[i] + .jpg FileMode.Open); BinaryReader br = new BinaryReader(fs); byte[] imgbyte = new byte[fs.Length + 1]; imgbyte = br.ReadBytes(Convert.ToInt32((fs.Length))); dr[Image] = imgbyte; fs.Dispose(); } but it give me exception error name of image not exist in path

ahmed sa · Answer

Not exist in this folder

Piyush Pansuriya · Answer

Is there a file like 4555.jpg in that folder?

ahmed sa · Answer

Can you help me

ahmed sa · Answer

it give me exception error Could not find file '\192.168.1.105\Personal Pictures\4555.jpg'.

Piyush Pansuriya · Answer

You have to use for loop. Give your code from foreach..

ahmed sa · Answer

only first one show

ahmed sa · Answer

Now ok message error not show and i can open crystal report but show only first picture but another es not show why

ahmed sa · Answer

Piyush Pansuriya · Answer

And also in security tab Allow Full control in permission for users.

ahmed sa · Answer

picture of sharing folder

Piyush Pansuriya · Answer

Hello Go to Personal Picture folder property and Uncheck Read Only in attributes.

ahmed sa · Answer

And this folder shared in my computer and i can access to it and edit and open and delete every thing

ahmed sa · Answer

And this folder shared in my computer and i can access to it and edit and open and delete every thing

ahmed sa · Answer

It is my PC and i can access to files but i dont know why problem in my code

Piyush Pansuriya · Answer

Hello is it your PC or different? If it is diff. PC try to open it from RUN . Is there any credential to access?

ahmed sa · Answer

Thank you for reply i make as thread above but it give me error message access is denied to path i can open the path delete edit do every thing in this path why give me error message

Piyush Pansuriya · Answer

Hello Remove foreach Instead of that : DataRow dr = dt.Rows[0]; dr[Image] = imgbyte; This will set image in first row only..

Piyush Pansuriya · Answer

Try this : for (int i; i { DataRow dr = dt.Rows[i]; FileStream fs=null; fs = new FileStream(\\192.168.1.105\Personal Pictures\ +dr[i]+ .jpg FileMode.Open); BinaryReader br = new BinaryReader(fs); byte[] imgbyte = new byte[fs.Length + 1]; imgbyte = br.ReadBytes(Convert.ToInt32((fs.Length))); dr[Image] = imgbyte; fs.Dispose(); } Make sure that all files have to exist in folder which are in DataTable.