I have a problem. I have a app which takes data from database and generate this data into txt file. On the beginning I create button for generate this data into txt file But now I want to this app generate this data in txt file for example every 5 min and overide previous file without button. Here is my code:
public partial class MainWindow : Window
{
private static Timer aTimer;
private List<tw__Towar> someData;
public MainWindow()
{
InitializeComponent();
}
private void Generate()
{
string path = @"c:\some path";
var createFile = someData.Select(k => $"{k.tw_Id}\t" + $"{k.column}\t" + $"{k.column2}\t" + $"{k.column3}\t"
);
File.WriteAllLines(path, createFile);
Process.Start(path);
System.Timers.Timer aTimer = new System.Timers.Timer();
aTimer.Elapsed += new ElapsedEventHandler(OnTimedEvent);
aTimer.Interval = some time;
aTimer.Enabled = true;
}
private void OnTimedEvent(object sender, ElapsedEventArgs e)
{
Generate();
Console.WriteLine("It works");
}
private void LoadData()
{
DataClasses1DataContext cd = new DataClasses1DataContext();
someData = (from p in cd.datavbase where p.column != null && p.column != ""
select p).ToList();
GT1.ItemsSource = someData;
}
private void Button_Click(object sender, RoutedEventArgs e)
{
LoadData();
}
//private void Button_Click_1(object sender, RoutedEventArgs e)
//{
// Generate();
//}
}