Reading contents of CSV file

Question

I have loaded a CSV file

Here is a sample of the content available in the CSV file

Name,Address,Address1,LandMark,User_location,City,State,Phone1,Phone2,Email,Category
Sriram Electricals and Plumbing Contractors,No 12, Vinayakar Koil Street Easa,"Back Side Of Therasa School,",Pallavaram,Chennai,Tamil Nadu,(044) 66590405,,sriram@gmail.com,Electrican

I've tried to convert the file to a list

public ActionResult UserCsv(HttpPostedFileBase uploadfile)
{      
    using (var sr = new StreamReader(uploadfile.InputStream, Encoding.UTF8))
    {   
         var reader = new CsvReader(sr); 
         //CSVReader will now read the whole file into an enumerable
         IEnumerable<UserCSVModel> records = reader.GetRecords<UserCSVModel>();
    }
}

Unable to get a correct output.

@ liaqat ali i tried but same result only i got by using linqticsv — user3129000, Apr 05 '14 at 06:19
Check [this](http://stackoverflow.com/questions/1050112/how-to-read-a-csv-file-into-a-net-datatable) — jomsk1e, Apr 05 '14 at 06:39

score 0 · Answer 1 · edited May 23 '17 at 11:59

0

try this article:

http://www.codeproject.com/Articles/415732/Reading-and-Writing-CSV-Files-in-Csharp

Or this Q on stack over flow:

Reading CSV file and storing values into an array

hope it helps.

edited May 23 '17 at 11:59

Community

1
1

answered Apr 05 '14 at 06:24

Monir Tarabishi

716
1
16
30

score 0 · Answer 2 · edited Aug 03 '15 at 13:59

0

Have a look a http://www.filehelpers.net/. It's a great library for working with CSV files and will give you an Enumerable that you can work with

edited Aug 03 '15 at 13:59

Marcos Meli

3,468
24
29

answered Apr 05 '14 at 08:00

Dave

583
1
4
11

Reading contents of CSV file

2 Answers2