CSV File To DataGridView Control In C#

This snippet shows you how to create a simple CSV class which can be used to populate a DataGridView control.

CSV.cs

1. public class CSV
2. {
3.     private StreamReader _reader;
4.     private ArrayList _contactCollection;
5.     private ArrayList _record;
7.     public CSV(string filename)
8.     {
9.         _reader = new StreamReader(filename);
10.     }
12.     public ArrayList GetContacts()
13.     {
14.         _contactCollection = new ArrayList();
15.         _record = new ArrayList();
17.         string line = "";
19.         while ((line = _reader.ReadLine()) !=null)
20.         {
21.             object[] record = line.Split(',');
22.             _contactCollection.Add(record);
23.         }
25.         return _contactCollection;
26.     }
27. }

Usage

1. private void Form1_Load(object sender, EventArgs e)
2. {
3.     dataGridView1.Columns.Add("Name", "Name");
4.     dataGridView1.Columns.Add("Surname", "Surname");
5.     dataGridView1.Columns.Add("Email", "Email");
7.     CSV csvFile = new CSV("contacts.csv");
8.     ArrayList contacts = csvFile.GetContacts();
10.     for (int i = 0; i < contacts.Count; i++ )
11.     {
12.         object[] record = (object[])contacts[i];
13.         dataGridView1.Rows.Add(record);
14.     }
15. }