Read a CSV file into a Data Grid View (Win Forms)

Question

Is there an easy way to read the contents of a CSV file/XML Sitemap (will just be a bunch of URLS) into a Datagrid view in a win form?

Thankyou

score 1 · Answer 1 · answered Mar 07 '12 at 16:46

How about using FileHelpers. This can read delimited or fixed length files which you map to a type.

In your case the type will contain a string Url.

Put these into a collection and databind to that.

Something like:

[DelimitedRecord(",")]
public class Row
{
    public string Url;

}

and then to read into memory:

FileHelperEngine<Row> engine = new FileHelperEngine<Row>();
engine.ReadFile("input.csv");

score 1 · Accepted Answer · answered Mar 08 '12 at 08:58

There is quite a good article for doing this located here: http://www.codeproject.com/Articles/16951/Populating-data-from-a-CSV-file-to-a-DataGridView the code is in VB.NET but it should be easy to convert either using your own knowledge or using an online conversion tool such as www.developerfusion.com/tools/convert/vb-to-csharp/

score 0 · Answer 3 · answered Mar 07 '12 at 16:38

0

read the csv file to a dataset, and then set the dataset as the datasource of the dataGridView . Follow this link for populating the dataset: http://www.java2s.com/Code/CSharp/Database-ADO.net/ReadcommaseparatedvalueintoDataSet.htm

answered Mar 07 '12 at 16:38

yoozz

247
2
15

score 0 · Answer 4 · edited May 23 '17 at 11:48

0

CSV files are common data sources accessible from OLEDb data provider. Fill a DataTable with them and then set the DataTable as DataSource for the GridView.

See here.

edited May 23 '17 at 11:48

Community

1
1

answered Mar 07 '12 at 16:51

Alberto De Caro

5,147
9
47
73

Read a CSV file into a Data Grid View (Win Forms)

4 Answers4