|
ASk this in the ASP.NET Forum.
|
|
|
|
|
Hi there..
I'm currently working on a project application in which I'm dealing with
multiple data reports. Use of multiple data reports are causing generation
of multiple temporary(*.tmp) files in the application directory.
So, I programmed a method to delete those temporary files from the app
directory. 
The code for the method goes as follows:
Public Sub deleteTMPFiles()
Dim oFSO As New FileSystemObject
Dim oFolder As Folder, oSF As File
Set oFolder = oFSO.GetFolder(App.Path)
On Error GoTo KillErr
For Each oSF In oFolder.Files
If Right(oSF.Name, 4) = ".tmp" Then
SetAttr oSF.Path, vbNormal
Kill oSF.Path ' This line's generating error
End If
Next
Exit Sub
KillErr:
MsgBox Err.Description
End Sub
But the method is generating an error, when it comes to delete the file.
It gives a description as Permission Denied 
I'm calling the method from MDIForm's unload event.
I just want to delete the temporary files from the application directory.
I've also tried the DeleteFile API function. It seemed as if the code ran
but reflected no changes in the system. 
Any help will be appreciated.. 
|
|
|
|
|
Sounds like the file is in use still, and so will not be deletable.
By the way it looks like you are writing VB6 code. If you are posting in the future I suggest you include that information in your post, and probably also the header line.
It will get you some flac these days as VB6 is a legacy platform, no longer supported in any form by Microsoft. Though strangely I see MSDN subscribers can now download the VB6 IDE. Odd thing for microsoft to do.
If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
www.JacksonSoft.co.uk
|
|
|
|
|
Hey there..
Thanx 4 ur reply..
But the file wasn't in use. I've already checked it many time..
Anyways, I've got my solution.
I used an alternative. I created an console application in C#
The code's as follows: (in C#)
using System;
using System.IO;
namespace DeleteTempFiles
{
class Program
{
static void Main(string[] args)
{
DirectoryInfo di = new DirectoryInfo(AppDomain.CurrentDomain.BaseDirectory);
FileInfo[] rgFiles = di.GetFiles("*.tmp");
foreach (FileInfo fi in rgFiles)
{
fi.Delete();
}
}
}
}
It simply deletes the *.tmp files from the application directory.
I'm just running this DeleteTempFiles.exe while unloading the form
using the following code in VB6
Shell(App.Path & "\DeleteTempFiles.exe")
Thanks again..
Nash - ThE CoDe sLiZeR
|
|
|
|
|
Have you ever wondered why your first approach doesn't work and your second approach does ?
|
|
|
|
|
Actually, My first approach was also working..
But after a day, it started showing me that error.
I've thought that it might be b'coz of the file being used somewhere.. in the memory. But the file wasn't in use..
Then I just got an idea of using that alternative.
No wonder, why it started showing that error.
I'd also googled about it before posting, many were having same problem as mine. But was with no answers left behind from anyone.
Well.. correction to my code before in VB6, I'd forgotten something there.
(in VB6)
Dim DeleteTempFiles<br />
DeleteTempFiles = Shell(App.Path & "\DeleteTempFiles.exe")
|
|
|
|
|
This is what probably happened:
1. When you tried to delete files from your own app, you got access denied because your own app was keeping those files open (your ReportViewer control).
2. When you moved the code to delete the files to another process (your console app) and call it when your are about to exit your app, your app is actually closed and releases all the handles it has on those files. So, your console app can happily delete those files.
|
|
|
|
|
Here is what is probably troubling you, BTW it uses some .NET terms but that isn't really relevant, the crux of the matter holds true in any language on a Windows system:
if you want write or delete access (anything other than read access) to a file that just got created (by yourself or someone else, does not matter), chances are you will find the file is being accessed by some other process, and your access is not granted.
The other process very likely is some server code that is there to assist you somehow. Candidates are:
- anti-virus software (Norton, McAfee, whatever)
- indexing software (Google Desktop, MS Office, whatever)
The common thing is these packages are looking all the time for new files, so they can inspect them.
Microsoft is aware of the consequences; Windows Explorer will try rename and delete attempts up to five times (with one-second interval), and only reports failure if the action continues to fail for that time.
The solution:
1. either use a different file name (not always acceptable)
2. or remove all background reader candidates (bad idea)
3. or implement the retry loop as Explorer has it (use a Windows.Forms.Timer for this)
BTW: if all you need is Read, make sure to allow others to read as well, i.e.
use File.Open(path, FileMode.Open, FileAccess.Read, FileShare.Read)
Remark: in my experience, trying to open/append/close a file more often than once a second succeeds all the time, seems like the inspectors allow for at least one second of inactivity before opening the files themselves.
Luc Pattyn [Forum Guidelines] [My Articles]
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
|
|
|
|
|
Thanx Luc..
I think this might be the problem.
I'll check my all codes once again. There's a high chance that I might have forgotten to close the recordsets or release resources while not working with them.
|
|
|
|
|
Hello all,
I am facing a problem while extact the Data from Excel in VB.Net
when I am having a Date Value and Double Value in Excel Spread Sheet.
When i am converting the Date Value Using Date.FromOADate(double args) Function, The Double Values in Excel are also converted to Date Format which is going Wrong. As Double Values in Excel Remain Double and Date Values must be converted to Date.FromOADate(...) as it is in OleDate Format which is again double.
I want to Convert Only the Date Field Values which are in Double format,
Not double values in Excel.
Please Suggest any Approach, It is Very Urgent.
Regards,
Uday.
|
|
|
|
|
Your question is not very clear at all.
Are you saying that you have two different date values (Ole and Double) in the same column of data and you want to be able to tell the difference between the two?
|
|
|
|
|
I will Explain You,
I have entered some double values in A3 Range of Excel.
Also some Date values in A3 Range of Excel.
While Retrieve this A3 Range Both the double value and Date values are showing as double.
So while converting the date value i used Date.FromOADate(double) it is OK for Date, But for the Range A3 there are also double values entered, This are also converting to Date value which must not happen for double values.
As Both Date value and Double Value in A3 Range are finally showing as double from excel,so i am not able to distingush for exact casting for Date values in A3 Range.
Please help me out.
Thanks & Regards,
Uday.
modified on Tuesday, November 17, 2009 12:15 PM
|
|
|
|
|
That explanation doesn't help much.
A3 is a single cell, or a Range consisting of one cell. Your explanation says that you have multiple values in A3 and that just isn't possible.
The only way to tell the difference between the two date values is to try to convert them to a date and see if the date comes back in a known range. If the date doesn't appear inside this range, try the other conversion. If it doesn't match either valid date range, you'll have to handle that value approriately.
|
|
|
|
|
janaswamy uday wrote: I want to Convert Only the Date Field Values which are in Double format,
Not double values in Excel.
If you are doing the converting then you need to apply the correct format depending on the source, whether it is a date or not.
|
|
|
|
|
dear All,
I understand but i will give a Article where the same problem is been raised.
Please see this Link There he has also same Problem :
Reading Excel Dates. Excel date gets converted to Double value in DotNet
------------------------------------------------------------------------
----> See this Link "http://social.msdn.microsoft.com/forums/en-US/vsto/thread/5b70f5e2-90c3-4824-99e4-8733be2e35ac"
I mean if we have Date Values and Double Values in a perticualr Range then how to find it is Date Value or Double Value ?
Regards,
Uday.
|
|
|
|
|
I already said, since the Date serial number is no different than a double, you have to either:
1) make sure that your dates do not end up intermingled with actual values or other date representations
2) try to convert the suspect date value into an actual date and test it for validity. If you know there cannot be any dates outside of a certain range, then you've got the wrong conversion if a date falls outside of that range. Try another conversion function and test again.
|
|
|
|
|
Dear Deave,
I think it is not correct solution. Please give me correct Solution for this. i mean if date and double lie in 1900 Year then what we can do.
Regards,
Uday
|
|
|
|
|
Rudheesh wrote: Please give me correct Solution for this.
How many times do you need this explained? Excel stores dates as double values and does not distinguish them from 'ordinary' doubles. It is the user's responsibility to know which cells are supposed to be dates; e.g. one column represents transaction date and the next column transaction cost.
|
|
|
|
|
Yeah, it IS the correct solution for your situation.
The only REAL solution is to normalize the data ahead of time and make damn sure you do not mix value types in the same data "column". If you're mixing normal Double values and Ole date serial numbers (also represented by a Double value,) in the same "column", you've got a horrible data model that just got you in trouble.
|
|
|
|
|
Strange question, but I'm sure someone's dealt with it.
When there are say 2 dimensions, and we want to loop within each of the 2, we write
for a = 0 to x
for b = 0 to x
do something...
next
next
And if there are 3 dimensions, we just add a c loop within the b loop, etc.
What if we don't know ahead of time how many dimensions there are? Can we write the looping structure to be dynamic based on a specified number of required loops?
Thanks
|
|
|
|
|
depending on circumstances recursion, reflection or a simple foreach may do it.
Luc Pattyn [Forum Guidelines] [My Articles]
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
|
|
|
|
|
That would be awful. Unless you just cannot avoid it, don't use it. What if there are 10 nested loops each going from 0 to 1000?
If there will be no code between the two loops, you can do something like this:
for(int i = 0; i<dimensions;i++){
Looper(loopFrom,loopTill);
}
Then in the Looper method:
private void Looper(loopFrom,loopTill){
for(int i=loopFrom;i<loopTill;i++){
}
}
Looks awful.
You can also generate dynamic code blocks and inject when required.
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
Thanks for the ideas. I figured out a way to do this with a collection.
Roughly, you make your own looping code:
Make a collection with the same number of rows as you have dimensions
Each row has a property indicating its number of iterations
Make a method getvalue in the collection
When you call getvalue,
if it's the last row in the collection (innermost loop which is incremented on every call) then
increment the index by 1
if we're at the highest value of the dimension, then
if we're not in the first row of the collection then
return to zero
increment the value of the index in the prior row (return to zero if necessary)
Return the value
Works like a charm
|
|
|
|
|
I don't know which .Net version are you using. If that is 3.0 or above, use LINQ it will surely help you get rid of some loops.
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
I want the Windows password at run-time achieved to bring,How do I do it,Is this possible?
All are successful
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
