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

girish parganiha

10y2.2k.NET

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

girish parganiha10y ago
Thank you for your reply....
My requirement is for both.
1)Insert the text file data into sql table.
2)And then read that data into textboxes and then save in a new table.
Thanks & Regards,
Girish
Midhun Tp10y ago
Hi,
What exactly is your requirement?
If you need code to read txt file, it is as below -
string text;

var fileStream = new FileStream(@"c:\file.txt", FileMode.Open, FileAccess.Read);

using (var streamReader = new StreamReader(fileStream, Encoding.UTF8))

{

text = streamReader.ReadToEnd();

}