Ad:

C# Discussion Thread
Unsolved
Views: 960

Mar 13th, 2010

Retrieve image from database

Expand Post »

Hi Experts
I m trying to retry images from database. My code is as below

C# Syntax (Toggle Plain Text)
DataTable tab = obj.createtable("Select pics from picto");//obj is the class in which createtable(string query) is function which returns datatable according to query
 
            byte[] ImgByte = (byte[])tab.Rows[0][0];
            FileStream fs = new FileStream("test.GIF", FileMode.Create);
            fs.Write(ImgByte, 0, ImgByte.Length);
            fs.Close();
            fs = null;
            pictureBox2.Image = Image.FromFile("test.GIF");
DataTable tab = obj.createtable("Select pics from picto");//obj is the class in which createtable(string query) is function which returns datatable according to query

            byte[] ImgByte = (byte[])tab.Rows[0][0];
            FileStream fs = new FileStream("test.GIF", FileMode.Create);
            fs.Write(ImgByte, 0, ImgByte.Length);
            fs.Close();
            fs = null;
            pictureBox2.Image = Image.FromFile("test.GIF");

the last line give "out of memory " error.
Plz help me

Similar Threads

How can I retrieve image from database? in C#
retrieve image from access db to picturebox in C#
Display Image from database in C#
Store and retrieve image from mysql db with JSP in JSP
How to retrieve images from database in PHP

ejazmusavi

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

42 posts
since Jun 2009

Permalink

Mar 13th, 2010

Re: Retrieve image from database

>the last line give "out of memory " error.

Image file has invalid file-format.

adatapost

Moderator

Reputation Points: 2134

Solved Threads: 1227

Posting Genius

Offline

6,524 posts
since Oct 2008

Permalink

Mar 13th, 2010

Re: Retrieve image from database

I have tried another way.

C# Syntax (Toggle Plain Text)
DataTable tab = obj.createtable("Select pics from picto where id=1");
//obj is a class in which createtable(string query) is a function which returns datatable of query
            byte[] ImgByte = (byte[])tab.Rows[0][0];
            MemoryStream fs = new MemoryStream(ImgByte);
            fs.Write(ImgByte, 0, ImgByte.Length);
            MessageBox.Show(ImgByte.Length.ToString());
            Bitmap bm = new Bitmap(fs);
            pictureBox2.Image = bm;
DataTable tab = obj.createtable("Select pics from picto where id=1");
//obj is a class in which createtable(string query) is a function which returns datatable of query
            byte[] ImgByte = (byte[])tab.Rows[0][0];
            MemoryStream fs = new MemoryStream(ImgByte);
            fs.Write(ImgByte, 0, ImgByte.Length);
            MessageBox.Show(ImgByte.Length.ToString());
            Bitmap bm = new Bitmap(fs);
            pictureBox2.Image = bm;

this gives "Parameter no valid " error
plz help me.

ejazmusavi

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

42 posts
since Jun 2009

Permalink

Mar 13th, 2010

Re: Retrieve image from database

.NET throws OutOfMemoryException if it does not recognize the image format.

adatapost

Moderator

Reputation Points: 2134

Solved Threads: 1227

Posting Genius

Offline

6,524 posts
since Oct 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C# Forum Timeline: Remoting & Events

Next Thread in C# Forum Timeline: wsHttpBinding

DaniWeb Message

Cancel Changes

User Name
Password