Menus

Monday, December 3, 2012

display images in crystal report from folder based on imgepath from database using C#.Nettry { // here i have define a simple datatable inwhich image will recide DataTable dt = new DataTable(); // object of data row DataRow drow; // add the column in table to store the image of Byte array type dt.Columns.Add("Image", System.Type.GetType("System.Byte[]")); drow = dt.NewRow; // define the filestream object to read the image FileStream fs; // define te binary reader to read the bytes of image BinaryReader br; // check the existance of image if (File.Exists(AppDomain.CurrentDomain.BaseDirectory + "10157.Jpg")) { // open image in file stream fs = new FileStream(AppDomain.CurrentDomain.BaseDirectory + "10157.Jpg", FileMode.Open); } else { // if phot does not exist show the nophoto.jpg file fs = new FileStream(AppDomain.CurrentDomain.BaseDirectory + "NoPhoto.jpg", FileMode.Open); } // initialise the binary reader from file streamobject br = new BinaryReader(fs); // define the byte array of filelength byte[] imgbyte = new byte[fs.Length + 1]; // read the bytes from the binary reader imgbyte = br.ReadBytes(Convert.ToInt32((fs.Length))); drow(0) = imgbyte; // add the image in bytearray dt.Rows.Add(drow); // add row into the datatable br.Close(); // close the binary reader fs.Close(); // close the file stream CrystalReport1 rptobj = new CrystalReport1(); // object of crystal report rptobj.SetDataSource(dt); // set the datasource of crystalreport object CrystalReportViewer1.ReportSource = rptobj; //set the report source } catch (Exception ex) { // error handling Interaction.MsgBox("Missing 10157.jpg or nophoto.jpg in application folder"); } // run the application to view image in report

try { 
        // here i have define a simple datatable inwhich image will recide 
        DataTable dt = new DataTable(); 
        // object of data row 
        DataRow drow; 
        // add the column in table to store the image of Byte array type 
        dt.Columns.Add("Image", System.Type.GetType("System.Byte[]")); 
        drow = dt.NewRow; 
        // define the filestream object to read the image 
        FileStream fs; 
        // define te binary reader to read the bytes of image 
        BinaryReader br; 
        // check the existance of image 
        if (File.Exists(AppDomain.CurrentDomain.BaseDirectory + "10157.Jpg")) { 
            // open image in file stream 
            fs = new FileStream(AppDomain.CurrentDomain.BaseDirectory + "10157.Jpg", FileMode.Open); 
        } 
        else { 
            // if phot does not exist show the nophoto.jpg file 
            fs = new FileStream(AppDomain.CurrentDomain.BaseDirectory + "NoPhoto.jpg", FileMode.Open); 
        } 
        // initialise the binary reader from file streamobject 
        br = new BinaryReader(fs); 
        // define the byte array of filelength 
        byte[] imgbyte = new byte[fs.Length + 1]; 
        // read the bytes from the binary reader 
        imgbyte = br.ReadBytes(Convert.ToInt32((fs.Length))); 
        drow(0) = imgbyte; 
        // add the image in bytearray 
        dt.Rows.Add(drow); 
        // add row into the datatable 
        br.Close(); 
        // close the binary reader 
        fs.Close(); 
        // close the file stream 
        CrystalReport1 rptobj = new CrystalReport1(); 
        // object of crystal report 
        rptobj.SetDataSource(dt); 
        // set the datasource of crystalreport object 
        CrystalReportViewer1.ReportSource = rptobj; 
        //set the report source 
    } 
    catch (Exception ex) { 
        // error handling 
        Interaction.MsgBox("Missing 10157.jpg or nophoto.jpg in application folder"); 
    } 
// run the application to view image in report 
 
Screenshot - ImgInReport.gif 

No comments:

Post a Comment