How to picture to save datebase(sql2008) and read pic to datebase and show datagridview?

Question

0.00/5 (No votes)

See more:

~~please answer my Question~~.
I want to save pic or image to db and read pic or image from db and show to gridview.
Please answer.

Posted 5-Apr-11 6:40am

saeed1364

Updated 5-Apr-11 6:49am

Sandeep Mewara

v2

Add a Solution

Comments

Sandeep Mewara 5-Apr-11 12:49pm

No need to bold your question.

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

Sandeep Mewara · Answer 1 · 2011-04-05T06:50:00

Solution 1

Start from here:C# Photo Album Viewer[^]

If you get stuck, post your effort with details and issue faced.

Posted 5-Apr-11 6:50am

Sandeep Mewara

Wendelius · Answer 2 · 2011-04-05T06:53:00

Solution 2

There are several article targeting this issue, even here in CP. This one was the first hit when I searched: Uploading / Downloading Pictures to / from a SQL Server[^]

Posted 5-Apr-11 6:53am

Wendelius

RaviRanjanKr · Answer 3 · 2011-04-05T07:12:00

Solution 3

In addition to Sandeep and Mika solution you can also go there[^] to learn how to get or set image in database.

Posted 5-Apr-11 7:12am

RaviRanjanKr

Michael Bookatz · Answer 4 · 2011-04-05T07:28:00

What you need to do in a nut shell, is serialise the image to a blob type in SQL and then deserialise it when you retrieve it from your database and want to display the image on your gridview.

It gets more complicated if it is an ASP gridview as then you need to save the images before you display as you can't set the source of an image to an image from memory.