title: C# creating Chart from CSV data
body: <p>I tried to read a CSV Data and display it in a Chart in Visual Studio. I get a SystemArgument.Exception and it tolds me that he couldn't find the Column with the name "Date".</p>
  
  <p>My Code is the following:</p>
  
  <pre><code>private void button1_Click_1(object sender, EventArgs e)
  {
  
  string file = "test.csv";
  string dir = "C:\\Main";
  
  string ConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
              dir + ";Extended Properties=\"Text;HDR=No;FMT=Delimited\"";
  OleDbConnection myConnection = new OleDbConnection(ConStr);
  
  string mySelectQuery = "Select * from " + file;
  OleDbCommand myCommand = new OleDbCommand(mySelectQuery, myConnection);
  
  myCommand.Connection.Open();
  OleDbDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
  
  chart1.Series["Test"].Points.DataBindXY(myReader, "Date",myReader,"Value");
  chart1.Series["Test"].ChartType = SeriesChartType.Line;
  
  myReader.Close();
  myConnection.Close();
  }
  </code></pre>
  
  <p>What is wrong? I hope someone can help me... the .Csv data is:
  Two columns - First column first row is Date
                Second Column first row is Value
  The Rows in the first column look  01.04.2010 - the Rows in the second column look like 234.567</p>