Retriving Images from sql server and store it in local drive

See more:

C#3.0

C#

Windows

forms

image

Hi friends

i am inserting my friends image in my sql database and now i want to retrieve image from database base and save it to my local drive but i am unable to o it please help me.

try
            {
                String sql = "Select name, Image from ImageTest";
                DataTable dt = new DataTable();
                _Connection.FillTable(ref dt, sql);
                Image img = null;
                for (int i = 0; i <= dt.Rows.Count - 1; i++)
                {
                    string TempPath;
                    TempPath = System.IO.Path.GetTempPath() + "\\myImage.jpeg";
                    img = _Connection.RetriveImageFromDB(dt.Rows[i][1]);
                    img.Save(System.IO.Path.GetTempPath() + "\\myImage.jpeg", ImageFormat.Jpeg);                  
                  
                }
            }

            catch { }

my code is not working and i get a error "A generic error occurred in GDI+"