picture in picture object using path in crystal report

Question

public class studentlist
{
public string Photopath1 { get; set; }
}
var query = (from b in db.User_Students_Registration select new { b.Photopath});
if (query.Count() > 0)
{
foreach (var a in query)
{
Pictureobject p=(Pictureobject)cr.ReportDefinition.Sections ["Section3"]ReportObjects["rptStudentDetailstext1"];
p.Picture = a.Photopath;
}

}

//This Code is For Displaying Image From Database Using Path in Crystal Report. //But My image Not //Display in Picture object Please Help Me

Vishal Jadav · Answer

Hi Sorry i forget to attach class which reads bytes from image. public static void FillCompanyData() { MainClass.RODset.Tables[company].Clear(); SqlDataAdapter da = new SqlDataAdapter(select *from company MainClass.con); da.Fill(MainClass.RODset.Tables[company]); //Load Image To ImgCol FileStream fs = new FileStream(MainClass.RODset.Tables[company].Rows[0][logo].ToString() FileMode.Open FileAccess.Read); byte[] image = new byte[fs.Length]; fs.Read(image 0 Convert.ToInt32(fs.Length)); fs.Close(); MainClass.RODset.Tables[company].Rows[0][img] = image; } Thanks.

Vishal Jadav · Answer

Hi Nafees In a project i need to do the same what you are trying to achieve. What i have done was Created a byte[] field for the image with the same name as field in the crystal report Picture object name. and just assigned datasource. it worked. I am attaching a report and a class i have used. Hope it helps. Thanks. Cheers....:)