How to pick an image retreived from a database to a datagridview into a winform picturebox

Question

0.00/5 (No votes)

See more:

I have a datagridview that display image retreived from a database, i want that when ever a user select the row e.g that has id column an picture column, and click on a button the image should be pick from the image column and diplayed on a picturebox
pls any help on how to do this.
Thanks

Posted 27-Aug-12 19:43pm

Ese Ochuko

Add a Solution

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)

Mohamed Mitwalli · Answer 1 · 2012-08-27T19:56:00

Solution 2

Hi ,
Check this
With the same Datasource you are using to bind your DataGrid

C#

using (SqlConnection con = new SqlConnection(@"Data Source=pc\SQLEXPRESS;Initial Catalog=test;Persist Security Info=True;User ID=sa;Password=***"))
            {
                con.Open();
                using (SqlCom
mand cmd = new SqlCommand("select * from ImageInsert", con))
                {
                    SqlDataAdapter adpt = new SqlDataAdapter(cmd);
                    DataSet ds = new DataSet();
                    adpt.Fill(ds);
                    DataRow Row;
                    Row = ds.Tables[0].Rows[0];
                    byte[] MyImg = (byte[])Row[1];
                    MemoryStream ms = new MemoryStream(MyImg);
                    Image img = Image.FromStream(ms);
                    pictureBox1.Image = img;

                }
            }

Best Regards
M.Mitwalli

Posted 27-Aug-12 19:56pm

Mohamed Mitwalli

Comments

Ese Ochuko 28-Aug-12 8:28am

Thanks vry much that waz a eye opener

Mohamed Mitwalli 28-Aug-12 9:38am

Your welcome If it help you mark it as answer

[no name] 28-Aug-12 13:18pm

correct answer.
+5

Mohamed Mitwalli 28-Aug-12 13:44pm

Thanks Sourav :)

[no name] 28-Aug-12 14:13pm

Why he is not accepting the answer?

Mohamed Mitwalli 29-Aug-12 2:07am

I don't know , but it's okay :)

WinnieMeeKun 27-Nov-12 21:19pm

using (SqlConnection conn = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Documents and Settings\\meekun.poon\\My Documents\\Visual Studio 2008\\Projects\\TrackLocation\\TrackLocation\\barcodePrinter.mdf;Integrated Security=True;User Instance=True"))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("SELECT Imagename FROM image", conn))
{
SqlDataAdapter adpt = new SqlDataAdapter(cmd);
DataSet dataSet = new DataSet();
adpt.Fill(dataSet,"image");
DataRow Row;
Row = dataSet.Tables["image"].Rows[0];
byte[] MyImg = (byte[])Row[0];
MemoryStream ms = new MemoryStream(MyImg);
Image img = Image.FromStream(ms); //error
MessageBox.Show("Error Message");
pictureBox1.Image = img;
}
conn.Close();
}

this is my code..but the Image img = Image.FromStream(ms); have error..how to solve this??? thanks..urgent!!!

WinnieMeeKun 27-Nov-12 21:24pm

and then i save imagename as image data type...

Mohamed Mitwalli 29-Nov-12 3:29am

what is the error message says ??

WinnieMeeKun 29-Nov-12 3:53am

Parameter is not valid. can i know how to solve this problem??? i already try and error so many days....thanks

Mohamed Mitwalli 29-Nov-12 5:49am

Well this Error will occurred if the file that you stored on the Database isn't Image
Check this
try to insert one image using this command in your DB then try from your application

INSERT INTO test (Img)
SELECT
(select * FROM OPENROWSET(BULK 'C:\test.JPG', SINGLE_BLOB) AS img)
Hope it help you :).

WinnieMeeKun 29-Nov-12 19:59pm

i can retrieve the image by following the code above...But, this is retrieve image from database??? thanks.

WinnieMeeKun 29-Nov-12 19:46pm

ok.i try this and see. thanks.

Mohamed Mitwalli 30-Nov-12 9:45am

your welcome :)