Retrieving a image from a sql server database

Question

orville 0 Newbie Poster

13 Years Ago

Hey All

I would like to know how to retrieve a image from sql server database. im storing the path in the database..

3 Contributors
2 Replies
201 Views
2 Days Discussion Span
Latest Post 13 Years Ago Latest Post by yousafc#

bhagawatshinde 11 Posting Whiz

13 Years Ago

Can you save image in folder(i.e. path saved in database) If Yes then just retrieve the path using query and display image in Picturebox/Datagridview.

Hope this will help......

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

yousafc# 0 Junior Poster in Training · Answer 1 · 2011-08-14T19:16:23+00:00

SqlConnection connect = new SqlConnection
                           ("Data source =YS-8462BA359936;Initial Catalog = Schooldata;Integrated Security = True");
            SqlCommand command = new SqlCommand
                                ("select Picture from Picturestable where Studentid=@id", connect);
            command.Parameters.Add("@id", SqlDbType.Int).Value = txtstudentid.Text;
            
            SqlDataAdapter dp = new SqlDataAdapter(command);
            DataSet ds = new DataSet("Picturestable");

            byte[] MyData = new byte[0];

            dp.Fill(ds, "Picturestable");
            DataRow myRow;
            myRow = ds.Tables["picturestable"].Rows[0];

            MyData = (byte[])myRow["Picture"];

            MemoryStream stream = new MemoryStream(MyData);

            pictureBox1.Image = Image.FromStream(stream);