Import from .csv file to DataGridView

using Microsoft.VisualBasic;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration;
using System.Data;
using System.Data.Odbc;
using System.Drawing;
using System.IO;
using System.Text;
using System.Windows.Forms;



//  ================================================================================================
//
//  This program copies data from the data file C:\TEST.CSV to C:\TEMP.CSV
//  This is to allow modification of the title line to allow SQL to search on the line.
//  TEMP.CSV is deleted at the end of the program.
//
//  ================================================================================================

namespace ReadDataFile
{
    public partial class Form1 : Form
    {

        char[] splitArray1 = { ',', '\n', '\r' };
        char[] splitArray2 = { ' ' };

        Int64[] SearchList = new long[1];
       
        string CSVDataSource;
        string FileName;
        string FileSize;
        string LineText;
        string TempFileName;

        string[] DataResult1 = { "", "", "", "", "" };// Use to populate the grid.              
        string[] Titles = { "Date", "Time", "Thickness", "Track Speed" };

        //Create a dataset  
        DataSet dataset = new DataSet("My Dataset");
        //Create a table
        DataTable datatable = new DataTable("Temp.CSV");

        public Form1()
        {
            InitializeComponent();            
            TempFileName = @"C:\Temp.csv";
           
            lblLoading.Visible = false;
                      
            CreateTable();
            dataset.Tables.Add(datatable);
        }

        private void btnOpenFile_Click(object sender, EventArgs e)
        {
            // Clear datagrid contents
            dgvData.SelectAll();
            dgvData.ClearSelection();
            // Set file name
            FileName = txtFileName.Text;
            CSVDataSource = FileName;
            if (File.Exists(TempFileName))
            {
                File.Delete(TempFileName);
            }
            StreamReader sr = new StreamReader(FileName);
            StreamWriter sw = new StreamWriter(TempFileName);
// Read & dump header
            string junk = sr.ReadLine();
// Read file into string       
            string FileData = sr.ReadToEnd();
            FileSize = FileData.Length.ToString("N");
            FileSize = FileSize.Substring(0, FileSize.IndexOf("."));
            lblLoading.Text = "Loading " + FileSize + "  bytes.\nPlease wait a moment or two.";
            lblLoading.Visible = true;
            lblLoading.Update();
// Change header to meet with ODBC title requirements
            sw.WriteLine(" Stream No.,Die No,Date,Time,Thickness,Status,Track");
            sw.WriteLine(LineText);
            sw.Write(FileData);
            sr.Close();
            sw.Close(); 
            ReadData();
            lblLoading.Visible = false;
            dgvData.Update();
            dgvData.Columns[4].HeaderText = "Track speed";
            if (File.Exists(TempFileName))
            {
                File.Delete(TempFileName);
            }
        }

        private void CreateTable()
        {
            for (int i = 0; i < 4; i++)
            {
                datatable.Columns.Add(Titles[i]);
            }
        }

        /// 

        /// Open TEMP.CSV as ODBC database file
        /// Access data using SQL 'Select' command
        /// Move data from DATABASE to DataTable and assign to DataGridView object
        /// Make each column UNSORTABLE to stop user messing with data!!!
        /// 
        private void ReadData()
        {
            string tempPath = "C:";
            string strConn = @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" + tempPath + @"\;Extensions=asc,csv,tab,txt";
            OdbcConnection conn = new OdbcConnection(strConn);
            OdbcDataAdapter da = new OdbcDataAdapter("Select Date,Time,Thickness,Status,Track from temp.csv", conn);
            DataTable dt = new DataTable();
            da.Fill(dt);
            dgvData.DataSource = dt;
            dgvData.Columns[1].DefaultCellStyle.Format = "T";
            foreach (DataGridViewColumn col in dgvData.Columns)
            {
                col.SortMode = DataGridViewColumnSortMode.NotSortable;
            }
        }
 

    }
}