how to show the image from database to picturebox in c#

Question

0.00/5 (No votes)

See more:

C#

i saved a image into sql server...
i couldn't view that image...

Posted 4-Mar-14 19:57pm

Member 10339067

Add a Solution

Comments

Aravindba 5-Mar-14 2:14am

which format u saved in sql server ? binary ?

Bernhard Hiller 5-Mar-14 2:15am

How is that image stored - path to a network share, path accessible to a server of a client-server-application, as binary data in a blob (plus additional information on the picture type in a different column or not), ...?

Raajkumar.b 5-Mar-14 2:18am

check it u will get an idea

http://www.dotnetgallery.com/kb/resource21-How-to-store-and-retrieve-images-from-SQL-server-database-using-aspnet.aspx

Vedat Ozan Oner 5-Mar-14 2:37am

google answers this question in 0.19 seconds: https://www.google.com.tr/search?q=how+to+show+the+image+from+database+to+picturebox+in+c%23

Member 10339067 5-Mar-14 2:45am

i saved in image datatype

Member 10339067 5-Mar-14 2:46am

i am using in windows application.....

1 solution

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)

nandakishoreroyal · Answer 1 · 2014-03-04T22:29:00

Solution 1

Please refer the link

Posted 4-Mar-14 22:29pm

nandakishoreroyal

Comments

Member 10339067 5-Mar-14 4:32am

already i used this... but not working

nandakishoreroyal 5-Mar-14 4:36am

Can you update the code what you have used?

Member 10339067 5-Mar-14 4:39am

SqlDataAdapter adapter1 = new SqlDataAdapter("SELECT Photo FROM tblPatientDetails WHERE PatientID=" + Convert.ToInt32((txtPatientID.Text)) + "", con);
DataTable datatable = new DataTable();
adapter1.Fill(datatable);
adapter1.Dispose();
if (datatable.Rows.Count > 0)
{
byte[] picArray = (byte[])dt.Rows[0]["Photo"];
MemoryStream ms = new MemoryStream(picArray);
ms.Seek(0, SeekOrigin.Begin);
//pictureBoxDisplay.Image = Image.FromStream(ms);
//pictureBoxDisplay.Image = ByteToImage(picArray);

MemoryStream mStream = new MemoryStream();
// byte[] pData = picArray;
mStream.Write(picArray, 0, Convert.ToInt32(picArray.Length));
Bitmap bm = new Bitmap(mStream, false);
mStream.Dispose();
pictureBoxDisplay.Image = bm;

}