title: taking data from a csv file, and putting it into an array
body: <pre><code>public class Earthquake
  {
      public double Magnitude { get; set; }
      public string Location { get; set; }
      public double Latitude { get; set; }
      public double Longitude { get; set; }
      public double depth { get; set; }
      public DateTime date { get; set; }
      public string EventID { get; set; }
      public string URL { get; set; }
      public Earthquake()
          : this(string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty)
      { }
      public Earthquake(string magna, string locate, string lat, string longi, string dept, string dat, string Event, string website)
      {
          Magnitude = Convert.ToDouble(magna);
          Location = locate;
          Latitude = Convert.ToDouble(lat);
          Longitude = Convert.ToDouble(longi);
          depth = Convert.ToDouble(dept);
          date = Convert.ToDateTime(dat);
          EventID = Event;
          URL = website;
      }
  
  }
  
  
  public void GetData()
      {
  
          string[] text = File.ReadAllLines(@"Earthquakes.csv");
              Earthquake[] data = new Earthquake[1];
              foreach (string line in text)
          {
              string[] myColumns = line.Split(',');
              Earthquake[] earth = new Earthquake[myColumns[0], myColumns[1], myColumns[2], myColumns[3], myColumns[4], myColumns[5], myColumns[6], myColumns[7]];
                  data[i] = earth[i];
                  i++;
          }
   }
  </code></pre>
  
  <p>Ignore commented parts I have those under control. The problem I am having is getting the data from the csv file into the Earthquake Array. I am getting syntax errors, and I know why, it's because the data type isn't correct, but I honestly cannot figure out how to fix it.
  Also if you notice I am trying to use bubble sort and since there is no definition for "compare" for double, what do I use instead?</p>