Ad:

C# Discussion Thread
Unsolved
Views: 2986

Jul 3rd, 2009

close or overwrite the file

Expand Post »

Hi all,

I have one windows service made in C#. I want My service to create CSV file every two minutes... but it should overwrite the existing file every two minutes. but whenever I try - it says file is already open - while I am sure that file is processed during those elapsed two minutes.. How do i programmatically close the file or overwrite the same. My file creation is through windows utility CSVDE (so have no control over creation except for the time and name!)

please suggest, thanks,
Jeet

Similar Threads

Error msg: "Filename.xls file already open. Choose to reopen or close the excel file" in Visual Basic 4 / 5 / 6
Open, search, replace data, save, close .txt file in VB.NET
how te close excel file automaticly with vb6 ??? in Visual Basic 4 / 5 / 6
Simple Inventory Program - file manipulation help in C++
File Open dialog created using GetOpenFileName function does not close in C++

havejeet

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

26 posts
since May 2009

Permalink

Jul 3rd, 2009

Re: close or overwrite the file

Look; as it's blackbox tool and you don't know how to handle its operations on file, try to do it manually (I think you query on Active Directory) or try to use files created by CSVDE as intermediate stage and read from them and write in another files using System.IO

Ramy Mahrous

Featured Poster

Reputation Points: 480

Solved Threads: 276

Postaholic

Offline

2,189 posts
since Aug 2006

Permalink

Jul 3rd, 2009

Re: close or overwrite the file

Click to Expand / Collapse Quote originally posted by Ramy Mahrous ...

Look; as it's blackbox tool and you don't know how to handle its operations on file, try to do it manually (I think you query on Active Directory) or try to use files created by CSVDE as intermediate stage and read from them and write in another files using System.IO

thanks Ramy, yes I am operating upon Active Directory data - every two minutes I need updated Active Directory data - CSVDE works fine. thanks for your suggestion but in that manual process - for chunk of data my elapsed time goes higher... well, let me see!

thanks
Jeet

havejeet

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

26 posts
since May 2009

Permalink

Jul 3rd, 2009

Re: close or overwrite the file

As long as we don't know how CSVDE works with files (try to read in it you may need to write couples of lines of code to let it close the file, hmmm I don't know) I wish for you the best of luck

Ramy Mahrous

Featured Poster

Reputation Points: 480

Solved Threads: 276

Postaholic

Offline

2,189 posts
since Aug 2006

Permalink

Jul 3rd, 2009

Re: close or overwrite the file

Hi all,

came across to wonderful code...now i am allowing to create files and deleting archieves!

protected void CleanImageFolder()
{
string imgFolder = Server.MapPath("~/lab/maskemail/img/");
string[] imgList = Directory.GetFiles(imgFolder, "*.jpg");
foreach (string img in imgList)
{
FileInfo imgInfo = new FileInfo(img);
if (imgInfo.LastWriteTime < DateTime.Now.AddMinutes(-3))
{
imgInfo.Delete();
}
}
}

thanks
Jeet

havejeet

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

26 posts
since May 2009

Permalink

Jul 3rd, 2009

Re: close or overwrite the file

Nice, mark it as solved then

Ramy Mahrous

Featured Poster

Reputation Points: 480

Solved Threads: 276

Postaholic

Offline

2,189 posts
since Aug 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C# Forum Timeline: How to create a web part using telerik radgrid?

Next Thread in C# Forum Timeline: Buttons Enabled Property not Working Properly

DaniWeb Message

Cancel Changes

User Name
Password