Solved

image being used by another process

Posted on 2013-01-30
5
470 Views
Last Modified: 2013-01-30
I have a process for pulling an image from the database when I use it once it pulls fine if I close the form in the app and open it again I ge tthe same error

any ideas
        private void ShowImage(int ID)
        {
            int @id = ID;
            string conString = ConfigurationManager.ConnectionStrings["connection"].ToString();
            SqlConnection conn = new SqlConnection(conString);
            SqlDataAdapter da = new SqlDataAdapter("spx_MsgUploadFiles_Pull", conn);
            da.SelectCommand.CommandType = CommandType.StoredProcedure;
            da.SelectCommand.Parameters.AddWithValue("@id", id);
            DataSet ds = new DataSet("read");
            conn.Open();
            da.Fill(ds, "read");
            conn.Close();
            //storing the file in byte array 
            byte[] MyData = new byte[0];
            DataRow myRow;
            myRow = ds.Tables["read"].Rows[0];
            MyData = (byte[])myRow["Document_File"];
            
            string name = myRow["filename"].ToString();
            int ArraySize = new int();
            ArraySize = MyData.GetUpperBound(0);
            if (ArraySize > -1)
            {

                string temp = ConfigurationManager.AppSettings["AppfileLogRootPath"];
                string path = temp + name;
                File.WriteAllBytes(path, MyData);
                byte[] pdf = (byte[])myRow["Document_File"];
                Image image = Image.FromFile(path);
                pbImage.Image = image;
            }

        }

Open in new window

0
Comment
Question by:r3nder
  • 2
  • 2
5 Comments
 
LVL 6

Author Comment

by:r3nder
ID: 38835969
exact error
The process cannot access the file '\\server\Users\Logs\newuser\openfiles\image.jpg' because it is being used by another process.
0
 
LVL 85

Accepted Solution

by:
Mike Tomlinson earned 500 total points
ID: 38836052
Change from ImageFromFile():

            Image image = Image.FromFile(path);
            pbImage.Image = image;

To Image.FromStream():

            Image image;
            using (System.IO.FileStream fs = new System.IO.FileStream(path, System.IO.FileMode.Open))
            {
                image = Image.FromStream(fs);
            }
            pbImage.Image = image;

See Image.FromFile():
http://msdn.microsoft.com/en-us/library/stf701f5.aspx

    "The file remains locked until the Image is disposed."
0
 
LVL 27

Expert Comment

by:nmarun
ID: 38836067
Or you can try something and dispose it off correctly.

      public partial class Form1 : Form
      {
          private Image _image;

            public Form1()
            {
                  InitializeComponent();
                _image = Image.FromFile(@"c:\temp\image.jpg");
                pictureBox1.Image = _image;
            }

        private void Form1_FormClosing(object sender, FormClosingEventArgs e)
        {
            if (_image != null)
            {
                _image.Dispose();
            }
        }
      }
0
 
LVL 27

Expert Comment

by:nmarun
ID: 38836074
Just use your own code to show the image, just that while closing the form, you explicitly call the Dispose() method on the image instance. This way your code is doing all the clean up before it closes.

Arun
0
 
LVL 6

Author Closing Comment

by:r3nder
ID: 38836116
as always Idle, you are the Batman of the code world :o)
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Web site error 3 40
asp day pilot 3 18
Problem to refer to value 8 46
updating order of the rows, N+1 query issue, C#, asp.net, MVC, SQL Server 3 25
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
A short article about problems I had with the new location API and permissions in Marshmallow
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question