load image from database table

Question

Hello ..
 
I don't know how I can load image from database table . I am store it with path (with copy and paste)in cell type text .
 
how I can show it in image control?
 

I ask my question for the third time , I hope to find answers now from my programmers friends .
 
Thanks ,Regards

Answer 1

Plz I want the code?

Answer 2

the easy way to show is is by using bitmap format.

this.picturebox1.image = new bitmap(path//write the path here.)

---

One word frees us of all the weight and pain of life: that word is love.

Answer 3

http://www.codeproject.com/Articles/33310/C-Save-and-Load-Image-from-Database

http://www.codeproject.com/Articles/9323/Load-Unload-images-into-from-DB-table

http://www.codeproject.com/Articles/268123/Display-Store-and-Retrieve-Image-Data-from-Databas

Kindly have a look at the samples provided in the above link.

Regards,

Narendran Ponpandiyan

Answer 4

This not what i want ,i want the code able me to show the image from database table 

Answer 5

Hi Aishaaa,

Drag a picturebox on your form and set the image as below:

picturebox1.image = new bitmap("value of path you fetched from db");

---

Regards, http://shwetamannjain.blogspot.com

Answer 6

Aishaaa

Try this code. You can save the images in a temporary folder.

For Image Control

string conn = ConfigurationManager.ConnectionStrings["tempstring"].ConnectionString;
            using (SqlConnection connection = new SqlConnection(conn))
            {
                connection.Open();
                //get the image from the database
                SqlDataAdapter dap = new SqlDataAdapter("select image from Demo where id=1", conn);
                DataSet ds = new DataSet();
                dap.Fill(ds, "temp");
                Byte[] abyt = null;
                foreach (DataRow row in ds.Tables[0].Rows)
                {
                    //convert the image into bytes
                    abyt = (Byte[])row[0];
                }
                //save the image in the folder
                FileStream FS1 = new FileStream(Server.MapPath("Images/image.jpg"), FileMode.Create);
                FS1.Write(abyt, 0, abyt.Length);
                FS1.Close();
                FS1 = null;
                //asign the image to the asp:Image control
                Image1.ImageUrl = "Images/image.jpg";
            }

For Picturebox Control

string conn = ConfigurationManager.ConnectionStrings["tempstring"].ConnectionString;
using (SqlConnection connection = new SqlConnection(conn))
            {
                connection.Open();
                //get the image from the database
                SqlDataAdapter dap = new SqlDataAdapter("select image from Demo where id=1", conn);
                DataSet ds = new DataSet();
                dap.Fill(ds, "temp");
                Byte[] abyt = null;
                foreach (DataRow row in ds.Tables[0].Rows)
                {
                    //convert the image into bytes
                    abyt = (Byte[])row[0];
                }
                System.IO.MemoryStream stream = new System.IO.MemoryStream(abyt, true);
                stream.Write(abyt, 0, abyt.Length);
                pictureBox1.Image = new Bitmap(stream);
            }

Hope this helps.

---

Parth

Answer 7

i work in wpf under c# i don't have dataset 

sorry the code is not work !

Answer 8

Hi aishaaa,
I think I got what's you mean, the "Database table" you said is the table in database, not the datatable in WPF.
If what I guess is true, that is to say you need to first know how to connect database in WPF, and get the data from datatabe, right?

For how to bind database to WPF, please check out below link for your reference:

http://msdn.microsoft.com/en-us/library/aa480226.aspx

http://www.codeproject.com/Articles/24192/Simple-Demo-of-Binding-to-a-Database-in-WPF-using

And once you get the path of image from database, you can use code like what above memeber said to show image:

this.picturebox1.image = new bitmap(path//write the path here.

Hope it helps.

Have a nice day.

---

Annabella Luo[MSFT]
MSDN Community Support | Feedback to us

Answer 9

HI

 i work on wpf under c#

I don't know how I can load image from database table . I am store it with path (with copy and paste)in cell type text .
 and i want to show the image randomly in 4 image . i want to do game

how I can show it in 4image control?

 

Answer 10

this my skype name if there any helper programmer

(aisha.dodi)

Answer 11

Hi aishaaa,

After you get the data of path from database, you can create bitmapimage as the Image Control's Source base on these path, then in a DispatcherTimer to create a randomly integer between 1 and 4, then in a switch sentence set Image's source base on the created random integer.

How to create randomly integer in C# for your reference:

private int RandomNumber(int min, int max)
{
Random random = new Random();
return random.Next(min, max); 
}

About DispatcherTimer class for your reference:http://msdn.microsoft.com/en-us/library/system.windows.threading.dispatchertimer.aspx 

Hope it helps.

Have a nice day.

---

Annabella Luo[MSFT]
MSDN Community Support | Feedback to us