How to insert text file data into sql table using asp.net c#

Question

Hi,

 

I am making a project in which i want to insert the text file data into sql table using asp.net c#.

 

The text file data is store in a network folder with so many different text file data with different file name(rp001,rp002,rp003....) .Before insert into table it will check in a loop that the text file data is in a table or not...if the data is in a table then it will skip that text file and check other text file...if that text file data is not in a table then it will insert that data in a table.

 

The data in the text file is in a pipe"|" form -  445|175|254|213|

15/05/2016|05.55|15/05/2016|04.45|98546|547|15/05/2016|15.36|15/05/2016|14.22

1859|1546|1235456|01/02/2016|V555|06/06/2016|5

 

 

Please help me.

 

 

 

Thanks & Regards,

Girish