Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Is the function called from multiple threads? If yes you may want to declare a static object on class level and place a lock statement around the entire body of that method. Like this:</p> <pre><code>private static Object syncObject = new Object() // this works not - see commented lin public static void DecryptFile(string FileName) { lock(syncObject) { string ToDecrypt = null; using (StreamReader sr = new StreamReader(FileName)) { ToDecrypt = sr.ReadToEnd(); } // here comes the exception using (StreamWriter sw = new StreamWriter(FileName, false)) { string Decrypted = Decrypt(ToDecrypt, true); sw.Write(Decrypted); } } } </code></pre> <p>Also could you, just for fun, comment the StreamReader statement and try to run the method again? If it still doesn't work, check if you've that file open in a texteditor or something alike by using ProcessExplorer or something similiar.</p> <p><strong>edit</strong> could you comment the StreamReader part? So that it looks like this:</p> <pre><code> public static void DecryptFile(string FileName) { //string ToDecrypt = null; //using (StreamReader sr = new StreamReader(FileName)) //{ // ToDecrypt = sr.ReadToEnd(); //} // here comes the exception using (StreamWriter sw = new StreamWriter(FileName, false)) { string Decrypted = Decrypt(ToDecrypt, true); sw.Write(Decrypted); } } </code></pre> <p>also could you try to open an exclusive FileStream on that file before the StreamReader and once after the StreamReader but before the StreamWriter? <a href="http://msdn.microsoft.com/de-de/library/tyhc0kft%28v=vs.110%29.aspx" rel="nofollow">http://msdn.microsoft.com/de-de/library/tyhc0kft%28v=vs.110%29.aspx</a></p> <p>Also could you try and use another file for that method?</p>
    singulars
    1. This table or related slice is empty.
    1. POc# exception file is being used by another process
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USSteffen Winkler
    1. USSteffen Winkler
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. CONo, function is not used by multiple threads. I also closed all other applications like explorer could block the file. This is very confusing, because first function is in principle the same and it works. I also commented out the part throwing the exception, than it works. So error is clearly localized, Thanks.
      singulars
      1. PO
      1. USTorsten Schneider
    2. COedited my question. I'm almost convinced that there is something else blocking that file since StreamReader is usually non-exclusive and even if it were still open, you should be able to edit that file. oh and another thing: Could you set a breakpoint on the using statement of the StreamWriter? When the debugger arrives there, try to open the file in a texteditor and make some change to it and try to save it. Also check your code and make sure that you aren't using that file anywhere else.
      singulars
      1. PO
      1. USSteffen Winkler
    3. CODone.Error found. A StreamReader was open before function call.Stupid error. Sorry and thanks a lot.
      singulars
      1. PO
      1. USTorsten Schneider
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload