Hello everyone!
I do understand this question might seem easy to solve but I am failing to. I am supposed to write an application (in C# preferably but VB won't hurt), that read a CSV file and store the data in a SQL server database. However, here are the problems that i am facing.
1. The CSV file will keep changing because some external devices will be updating the file every 5 min
2. I would like to save the data in sql asap but I wonder how since I am afraid there could be some conflict
3. I am trying to use file changes using FileSystemWatcher but I do not know how it works really.
Any sample code would be very helpful
...
Go to the complete details ...