How to read and write a csv or excel file in C#?

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
Hi
I need to upload a csv or excel file which has one column (A) to an aspx page.
It can read the row data one by one and insert into MSSQL DB.
After the row of data inserted into MSSQL DB,  it needs to write the text "Inserted" in column B of the csv or excel file.

If there is interruption such as DB connection error, those row of data had not been inserted will not marked in column B of the csv or excel file.

How should I do that? 
<h1 class=titleHeader> </h1>

View the full article
 
Back
Top