For a resilient, fast, and low effort solution, you can use [CsvHelper][1] which handles a lot of code and edge cases and has pretty good [documentation][2]

### First, install the [CsvHelper package on Nuget][3]

[![CsvHelper nuget download][4]][4]

## a) CSV *with* Headers

If your csv has headers like this:

```none
sport,date,team 1,team 2,score 1,score 2
basketball,2011/01/28,Rockets,Blazers,98,99
baseball,2011/08/22,Yankees,Redsox,4,3
```

You can add attributes to your class to map the field names to your class names like this:

```cs
public class SportStats
{
    [Name("sport")]
    public string Sport { get; set; }
    [Name("date")]
    public DateTime Date { get; set; }
    [Name("team 1")]
    public string TeamOne { get; set; }
    [Name("team 2")]
    public string TeamTwo { get; set; }
    [Name("score 1")]
    public int ScoreOne { get; set; }
    [Name("score 2")]
    public int ScoreTwo { get; set; }
}
```

And then invoke like this:

```
List<SportStats> records;

using (var reader = new StreamReader(@".\stats.csv"))
using (var csv = new CsvReader(reader))
{
    records = csv.GetRecords<SportStats>().ToList();
}
```

### b) CSV *without* Headers

If your csv doesn't have headers like this:

```none
basketball,2011/01/28,Rockets,Blazers,98,99
baseball,2011/08/22,Yankees,Redsox,4,3
```

You can add attributes to your class and map to the CSV ordinally by position like this:

```cs
public class SportStats
{
    [Index(0)]
    public string Sport { get; set; }
    [Index(1)]
    public DateTime Date { get; set; }
    [Index(2)]
    public string TeamOne { get; set; }
    [Index(3)]
    public string TeamTwo { get; set; }
    [Index(4)]
    public int ScoreOne { get; set; }
    [Index(5)]
    public int ScoreTwo { get; set; }
}
```

And then invoke like this:

```
List<SportStats> records;

using (var reader = new StreamReader(@".\stats.csv"))
using (var csv = new CsvReader(reader))
{
    csv.Configuration.HasHeaderRecord = false;
    records = csv.GetRecords<SportStats>().ToList();
}
```

### Further Reading

* [Reading CSV file and storing values into an array][7] (295🡅)
* [Parsing CSV files in C#, with header][9] (245🡅)
* [Import CSV file to strongly typed data structure in .Net][6] (104🡅)
* [Reading a CSV file in .NET?][5] (45🡅)
* [Is there a “proper” way to read CSV files][8] (17🡅)
* ... many more

[1]: https://github.com/JoshClose/CsvHelper
[2]: https://joshclose.github.io/CsvHelper/getting-started/
[3]: https://www.nuget.org/packages/CsvHelper/
[4]: https://i.stack.imgur.com/RaOZM.png
[5]: https://stackoverflow.com/q/1405038/1366033
[6]: https://stackoverflow.com/q/1898/1366033
[7]: https://stackoverflow.com/q/5282999/1366033
[8]: https://stackoverflow.com/a/2315182/1366033
[9]: https://stackoverflow.com/q/2081418/1366033

I know how to read and display a line of a .csv file. Now I would like to parse that file, store its contents in arrays, and use those arrays as values for some classes I created.

I'd like to learn how though.

Here is an example:

    basketball,2011/01/28,Rockets,Blazers,98,99
    baseball,2011/08/22,Yankees,Redsox,4,3

As you can see, each field is separated by commas. I've created the Basketball.cs and Baseball classes which is an extension of the Sport.cs class, which has the fields:

    private string sport;
    private string date;
    private string team1;
    private string team2;
    private string score;

I understand that this is simplistic, and that there's better ways of storing this info, i.e. creating classes for each team, making the date a DateType datatype, and more of the same but I'd like to know how to input this information into the classes. 

I'm assuming this has something to do with getters and setters... I've also read of dictionaries and collections, but I'd like to start simple by storing them all in arrays... (If that makes sense... Feel free to correct me).

Here is what I have so far. All it does is read the csv and parrot out its contents on the Console:

    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Text;
    using System.IO;

    namespace Assign01
    {
        class Program
        {
            static void Main(string[] args)
            {
                string line;
                FileStream aFile = new FileStream("../../sportsResults.csv", FileMode.Open);
                StreamReader sr = new StreamReader(aFile);
                
                // read data in line by line
                while ((line = sr.ReadLine()) != null)
                {
                    Console.WriteLine(line);
                    line = sr.ReadLine();
                }
                sr.Close();
            }
        }
    }


Help would be much appreciated.

Importing CSV data into C# classes

You can create a clone of any class by calling this helper function:




    Function DeepClone(Of T)(ByRef orig As T) As T

        ' Don't serialize a null object, simply return the default for that object
        If (Object.ReferenceEquals(orig, Nothing)) Then Return Nothing

        Dim formatter As New BinaryFormatter()
        Dim stream As New MemoryStream()

        formatter.Serialize(stream, orig)
        stream.Seek(0, SeekOrigin.Begin)

        Return CType(formatter.Deserialize(stream), T)

    End Function

This works by serializing all the information from your class into a portable object and then rewriting it in order to sever any reference pointers.

> **Note**: The passed in class and any other classes it exposes as properties must be marked [`<Serializable()>`][1] in order to use [`BinaryFormatter.Serialize`][2]



If you want to make your own class expose the clonable method itself, you can add the method and implement the [`ICloneable`][3] interface like this:



    <Serializable()>
    Public Class MyClass : Implements ICloneable

        'NOTE - The Account class must also be Serializable
        Public Property PersonAccount as Account
        Public Property FirstName As String

        Function Clone(ByRef orig As MyClass) As MyClass Implements ICloneable.Clone
    
            ' Don't serialize a null object, simply return the default for that object
            If (Object.ReferenceEquals(orig, Nothing)) Then Return Nothing
    
            Dim formatter As New BinaryFormatter()
            Dim stream As New MemoryStream()
    
            formatter.Serialize(stream, orig)
            stream.Seek(0, SeekOrigin.Begin)
    
            Return CType(formatter.Deserialize(stream), T)
    
        End Function
    
    End Class

> **Note**: Be aware ICloneable comes with it's share of [controversies][4] as it does not indicate to the caller if it is performing a deep or shallow clone.  In reality, you don't need the interface to be able to add the method to your class.

[1]: https://msdn.microsoft.com/en-us/library/System.SerializableAttribute(v=vs.110).aspx
[2]: https://msdn.microsoft.com/en-us/library/System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Serialize(v=vs.110).aspx
[3]: https://msdn.microsoft.com/en-us/library/system.icloneable(v=vs.110).aspx
[4]: https://stackoverflow.com/q/699210/1366033

Can I please have some help to perform a deep copy of an object.

Here is my code:

    Option Explicit On
    Option Strict On

    <Serializable> Public Class [Class]
    Private _Name As String
    Private _ListOfFields As New List(Of Field)

    Public Property Name As String
        Get
            Return _Name
        End Get
        Set(value As String)
            _Name = value
        End Set
    End Property

    Public Property ListOfFields As List(Of Field)
        Get
            Return _ListOfFields
        End Get
        Set(value As List(Of Field))
            _ListOfFields = value
        End Set
    End Property

    Public Function Clone() As [Class]
        Return DirectCast(Me.MemberwiseClone, [Class])
    End Function

    End Class

Field is a Class that I have written myself as well.

What do I need to modify for the Clone() Function to return a deep copy?

Deep Copy of an Object

You could do either:

Display them as a block - should take up a new line:



    a.tileSB {
      display: block
    }

Float and clear all the elements:



    a.tileSB {
      float: left;
      clear: left;
    }

### Demo in Stack Snippets





    .tileSB {
      display: block
    }



    <div id="sidebar-company">

      <a class="tileSB bg-darkBlue animated six flipInX" data-click="transform">
        <div class="brand">
          <div class="text-center">
            <p class="fg-white">Overview</p></div>
        </div>
      </a>

      <a class="tileSB half bg-darkBlue animated seven flipInX" data-click="transform">
        <div class="tile-content icon">
          <img src="images/mthc/arrowRight.png"> - Text 2
        </div>
      </a>

      <a class="tileSB half bg-darkBlue animated eight flipInX" data-click="transform">
        <div class="tile-content icon">
          <img src="images/mthc/arrowRight.png"> - Text 3
        </div>
      </a>

      <a class="tileSB half bg-darkBlue animated nine flipInX" data-click="transform">
        <div class="tile-content icon">
          <img src="images/mthc/arrowRight.png"> - Text 4
        </div>
      </a>

    </div>

I am trying to place the class called `tile` with a few other bits around it so that it is a vertical list.  The tiles are of different sizes and don't seem to list vertically. I also want to put some text alongside it but not sure how.  The first tile has a label inside it called "Overview", but the others I want to place some text to the right of the tile without messing up the vertical alignment.





    <div id="sidebar-company">

      <a class="tileSB bg-darkBlue animated six flipInX" data-click="transform">
        <div class="brand">
          <div class="text-center">
            <p class="fg-white">Overview</p></div>
        </div>
      </a>

      <a class="tileSB half bg-darkBlue animated seven flipInX" data-click="transform">
        <div class="tile-content icon">
          <img src="images/mthc/arrowRight.png">

        </div>
      </a>

      <a class="tileSB half bg-darkBlue animated eight flipInX" data-click="transform">
        <div class="tile-content icon">
          <img src="images/mthc/arrowRight.png">
        </div>
      </a>

      <a class="tileSB half bg-darkBlue animated nine flipInX" data-click="transform">
        <div class="tile-content icon">
          <img src="images/mthc/arrowRight.png">
        </div>
      </a>

    </div> 





How can I do this in CSS?