C#

private void button1_Click_1(object sender, EventArgs e)
        {

string file = @"C:\Main";

string ConStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + file + ";Extended Properties=\"Text;HDR=Yes;FMT=Delimited\"";
                          OleDbConnection myConnection = new OleDbConnection(ConStr);

                          // Create a database command on the connection using query
                          string query = @"select * from [test.csv]";
                          OleDbCommand myCommand = new OleDbCommand(query, myConnection);

                          // Open the connection and create the reader
                          myCommand.Connection.Open();
                          OleDbDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);

                          DataTable tb = new DataTable();
                          using (OleDbDataAdapter ad = new OleDbDataAdapter(query, myConnection))
                          {
                              ad.Fill(tb);
         
                          }
                      chart1.Series["Test"].Points.DataBindXY(myReader, "Date", myReader,"Value");
                            chart1.Series["Test"].ChartType = SeriesChartType.Spline;




                  
                          myReader.Close();
                          myConnection.Close();
              
            }

Points.DataBindXY(myReader, "Date", myReader,"Value");