How to read values from multiple text files and then save it

Question

Hi I have many text files which has details (say Employee details). one text file for each employee. Now I need to read each file get the details (like Emp_Name Emp_ID Address etc.) and then save it into SQL database directly. Can someone please help me on this. In the text file each details are separated by ; (semicolon) Ex: File1: EmpID: 101 EmpName: Nagaraja Address: Bangalore File2: EmpID: 102 EmpName: Deepak Address: Bangalore

Nagaraja Tr · Answer

Hi Chandu Thanks for the reply. I saw the code in the provided link. it actually points to a specific file. In my case I will not know the file name upfront. All I know is multiple Employee details will be stored as .txt file in one particular location. Now I need to read each file then get the required information within the file and store into Database. Now I do not know how to read these text files and get the details. Can you please help me on this.

Chandu Kumawat · Answer

refer this http://www.codeproject.com/Questions/133849/txt-file-import-c-to-sql