I have been given the task of developing a program that will run on a clent machine and interact with a MySQL database on an internal server. It is for a phone call loggin system. Basically, each day when the first phone call is made, a csv text file is created and information appended about each call - numbers, extensions, call duration etc is recorded automatically.
What my clients want is for this text file to be uploaded to their internal MySQL using some GUI on a client machine (which I presume can be built using .NET Forms).
My thougts are: build a Forms based GUI that handles file processing, extract the information and add the data to the MySQL database.
Client machine is windows 2000, server is Windows 2003. Can anyone see any problems with this approach? Does .NET 2.0 need to be installed on either machine? I've only ever used C# in ASP.NET.
Thanks in advance!
Mike GoldPosted Jan 17, 2008, 5:56 PM
It sounds like that is what you want to do. You can use something like a StreamReader to read the text file into a string. Then parse the fields into your form to show the user. When the user hits a button (Export) the fields can be inserted into the database using ODBC.NET or a MySQL data provider. If you need further help on this, you can also contact C# Corner Consulting. They have a lot of experience with stuff like this.