How to read a blob from Oracle DB and display it in asp.net C# application

Question

0.00/5 (No votes)

See more:

Hi,

I have an image. I wanted to Browse that image file and save it to Oracle DB on Save button click. And in Open button click I want to retrieve the same and display it in the web Page.
Could any one please help me in this.

Thanks & Regards,
Mathi.

Posted 26-Mar-14 20:59pm

Mathi2code

Add a Solution

2 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)

Mukesh Ghosh · Answer 1 · 2014-03-26T21:33:00

Solution 1

Hello,
Check for
http://www.club-oracle.com/forums/insert-images-into-oracle-database-t664/[^]

But personally i suggest not to save image in DB. Some time back table size get increase
& take huge time, i faced the same.

Better store file in server & store path only in Table & display image from that location.

Posted 26-Mar-14 21:33pm

Mukesh Ghosh

Comments

Mathi2code 31-Mar-14 6:27am

Thanks for the suggestion Mukesh. Will think about this, but the link which you pinged has solution only for inserting BLOB to DB. But there is another part which is Reading the BLOB from DB and displaying it in the UI using C# code. Could you please help me on this.

Regards,
Mathi.

Mukesh Ghosh · Answer 2 · 2014-03-31T00:57:00

Solution 2

You can check for
http://www.jguru.com/faq/view.jsp?EID=1325[^]

Posted 31-Mar-14 0:57am

Mukesh Ghosh