How to retrieve a image in dataset using C#.net

Question

1.00/5 (1 vote)

See more:

Hi All,

My task is to dispaly the images in dataset.
Images and their text name are stored in database.
i need to dispaly the textname and image names.

Ex:-

Dataset:-

Folwer Nature Baby //Image Text Name

flow.jpg Na.jpg Baby.jpg //Images.

Can any one send me the sample code for this.

Thanks in Advance

Posted 19-Dec-11 19:16pm

RagSuchi

Updated 19-Dec-11 19:30pm

v3

Add a Solution

Comments

Suresh Suthar 20-Dec-11 1:20am

If this is your task than do it your self. What is the problem?
What have you tried? Any code?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Varun Sareen · Answer 1 · 2011-12-19T19:22:00

Solution 1

Dear Friend,

A picture stored in database can't be kept or inserted into a dataset column as the image is a stream object which can be only read if the connection is open and dataset works into a disconnected mode.

You have to use sql datareader object in order to read image from the database :-) as it maintains a connection with the db till the time whole content is not read from the database.

I hope this will help you out.

Thanks

Posted 19-Dec-11 19:22pm

Varun Sareen

Comments

RagSuchi 20-Dec-11 1:32am

Hi Varun,

Thanks for your reply,

Can you send me the sample code for this.

RaviRanjanKr 20-Dec-11 3:41am

No one will send you Sample Code. you need to put your effort and then revert back with specific question.

Varun Sareen 20-Dec-11 5:13am

Dear RagSuchi, I would have provided you the code but when i was not able to show the image after retrieving the byte image from the sql reader object so i turned my self to storing images in folder and that worked. If you need that i can provide you :-). Also if you search for the code it can be easily available to you. Thanks Varun Sareen

D Anil Kumar · Answer 2 · 2011-12-19T21:34:00

Solution 2

go through this link it may help you

http://www.dotnettutorials.com/tutorials/database/save-retrieve-image-cs.aspx

Posted 19-Dec-11 21:34pm

D Anil Kumar

RaviRanjanKr · Answer 3 · 2011-12-19T21:58:00

Solution 3

This Read / Write BLOBs using C# .NET DataSet and DataReader[^] link might help you.

Posted 19-Dec-11 21:58pm

RaviRanjanKr