Hello,
At the bank I work for, we have an old program that we are trying to retire. This program takes a text file that the customers create and uploads it into our payment system database. The problem is, all the coders from the original program are all gone. So all we can do is look at these text files and build the replacement program based on the files. We are going to .Net later this year so I'd like to start coding in that however I do not have any good examples on taking the contents from a text file (which the format can not change) and upload the data into a SQL Server which has 85 or so fields.. so i need to read this record, chop it up into many fields and then insert each payment into the database. Can someone give me a clue (or link) on how to do that in VB.NET or C#?
Thanks!
At the bank I work for, we have an old program that we are trying to retire. This program takes a text file that the customers create and uploads it into our payment system database. The problem is, all the coders from the original program are all gone. So all we can do is look at these text files and build the replacement program based on the files. We are going to .Net later this year so I'd like to start coding in that however I do not have any good examples on taking the contents from a text file (which the format can not change) and upload the data into a SQL Server which has 85 or so fields.. so i need to read this record, chop it up into many fields and then insert each payment into the database. Can someone give me a clue (or link) on how to do that in VB.NET or C#?
Thanks!
Facebook
Twitter