Showing Picture in Crystal Reports from Table

[M Riaz Bashir]

hi all I have uploaded a picture into table but i am stuck, that how may I show the picture in Crystal Reports from table. I used following codes to upload the picture it works fine

            // load the file that we want to upload into memory
            fileStream = new System.IO.FileStream(strFile, System.IO.FileMode.Open, System.IO.FileAccess.Read);
            reader = new System.IO.BinaryReader(fileStream);
            data = reader.ReadBytes((int)fileStream.Length);

            // open the connection to the database
            //conn = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + AccessFile.Text);
            //conn.Open();

            // determine if the file already exists.  If the file does not already
            // exist, add the file to the table.
            cmd = new OleDbCommand();
            cmd.Connection = Module.objConnection;
            string strQuery = 
                "SELECT \* FROM PICTURES WHERE " + 
                "STCODE="+ textBox1.Text +" AND " + 
                "STSEQ="+ dataGridView1\["STSEQ",dataGridView1.CurrentCell.RowIndex\].Value.ToString() +"  ";
            cmd.CommandText = strQuery;
            dr = cmd.ExecuteReader();
            if (dr.HasRows == false)
            {
                dr.Close();
                cmd.CommandText = "INSERT INTO PICTURES (STCODE,STRNO,STSEQ,FILENAME,FILESIZE,FILETYPE) " +
                    "VALUES(" + textBox1.Text + ", " +
                    "" + dataGridView1\["STRNO", dataGridView1.CurrentCell.RowIndex\].Value.ToString() + ", " +
                    "" + dataGridView1\["STSEQ", dataGridView1.CurrentCell.RowIndex\].Value.ToString() + ", " +
                    "'" + fileName + "'," + data.Length + ",'" + type + "') ";
                //cmd.CommandText = "INSERT INTO PICTURES (STCODE,STRNO,STSEQ,FILENAME,FILETYPE) " +
                //    "VALUES(" + textBox1.Text + ", " +
                //    "" + dataGridView1\["STRNO", dataGridView1.CurrentCell.RowIndex\].Value.ToString() + ", " +
                //    "" + dataGridView1\["STSEQ", dataGridView1.CurrentCell.RowIndex\].Value.ToString() + ",'" + textBox1.Text.Trim() + "\_" + textBox2.Text.Trim() + "." + type + "') ";
                //    //"'" + fileName + "'," + data.Length + ",'" + type + "') ";

                cmd.ExecuteNonQuery();

(Riaz)

[thatraja]

Already answered similar question in Q/A section here before, see that. Crystal Report - Images[^] Printing photo on crystal report[^] Dynamically setting picture path in crystal report[^] Crystal Report Reading Picture file from path c: directory[^]

thatraja

---

**My Tip/Tricks
My Dad had a Heart Attack on this day so don't...
**All these are my opinions. Different people. different way of thinking. I am no one to judge others - Chandru