CSV file based on timer event

mprice214

Hi all, I've been looking for a way to write data to a CSV file based on a timer event, without success. Is there a standard .NET class that will do this? Thanks.

Ravi Bhavnani

There are timer classes and there are classes to perform file I/O. Were you expecting specialized support beyond this? If so, what kind? /ravi

My new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com

Priya Prk

Sure, use System.Timers for your timer and System.IO for CSV file.

mprice214

What I would like to do is write a variable value to a csv file dynamically at a certain interval (timer tick). Each tick would result in a new line in the csv file.

Ravi Bhavnani

OK, that's fair. One way to do this would be to open the file (for update) when your application starts, set up a timer to fire at a specific interval, and in the timer tick handler, write a line to the open file (and flush the file). When your program terminates (either normally or abnormally), close the file. See the Timer and File classes for more information. /ravi

My new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com

mprice214

This works, but it seems a bit flakey. Also, does anyone know how to limit the file size?

using (StreamWriter writer = new StreamWriter("C:\\log.csv", true)) //add ,true to this to append
{
writer.WriteLine(textBox1.Text + "," + System.DateTime.Now);

Ravi Bhavnani

mprice214 wrote:

This works, but it seems a bit flakey.

Define "flakey". Remember, a Timer is only one way to go. You could also use a background thread. In this case, be sure to handle concurrent access of UI (and other) data. /ravi

My new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com

Luc Pattyn

No problem[^]. :-D

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

Prolific encyclopedia fixture proof-reader browser patron addict?
We all depend on the beast below.

mprice214

Luc Pattyn wrote:

No problem[^].

Come again?

Ravi Bhavnani

:) OT: I wished I lived in Belgium. It's a collector's haven for Dinky Toys. /ravi

My new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com

Ravi Bhavnani

Luc is just having some fun at our expense. :) /ravi

My new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com

Luc Pattyn

Ravi Bhavnani wrote:

collector's haven for Dinky Toys

is it? I wasn't aware, I haven't seen one for ages. I am a model railroad enthusiast myself (N gauge, i.e. scale 1:160). :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

Prolific encyclopedia fixture proof-reader browser patron addict?
We all depend on the beast below.

Ravi Bhavnani

Luc Pattyn wrote:

I haven't seen one for ages.

You can relive some childhood memories here[^]. :) /ravi

My new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com

Luc Pattyn

Great. The very first image[^] I looked at has a bill board for a shop in Ghent that is still there; I have bought some locs there once. Normally I go shopping in Germany... :) PS: may I suggest you add some navigation to your catalogs, moving to the next/previous page would increase the "user experience".

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

Prolific encyclopedia fixture proof-reader browser patron addict?
We all depend on the beast below.

AspDotNetDev

Sounds like you are doing some profiling/tracing. Google those terms, perhaps in combination with "C#" and anything more specific you are interested in. Or do as others say and create a timer that appends to the CSV file.

[Forum Guidelines]

yu jian

Hi boy, try this. :)

using System;
using System.Windows.Forms;
using System.IO;

namespace WriteCSV
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            this.timer1.Enabled = !this.timer1.Enabled;
        }

        private void timer1_Tick(object sender, EventArgs e)
        {
            FileStream fs = new FileStream("test.csv",  FileMode.Append, FileAccess.Write);
            StreamWriter sw = new StreamWriter(fs);
            sw.WriteLine(DateTime.Now.ToString());
            sw.Close();
            fs.Close();
        }
    }
}