CSV file parse Method which will read 001 as 001 instead of 1

See more:

C#

I have below code to parse CSV file

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.Odbc;
using System.IO;
using System.Data.OleDb;
using System.Globalization;

namespace ReadCSVFile
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            string path =@"D:\csvfile.csv";
            DataTable de = GetDataTableFromCsv(path, false);
        }

        static DataTable GetDataTableFromCsv(string path, bool isFirstRowHeader)
        {
            string header = isFirstRowHeader ? "Yes" : "No";

            string pathOnly = Path.GetDirectoryName(path);
            string fileName = Path.GetFileName(path);

            string sql = @"SELECT * FROM [" + fileName + "]";

            using (OleDbConnection connection = new OleDbConnection(
                      @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pathOnly +
                      ";Extended Properties=\"Text;HDR=" + header + "\""))
            using (OleDbCommand command = new OleDbCommand(sql, connection))
            using (OleDbDataAdapter adapter = new OleDbDataAdapter(command))
            {
                DataTable dataTable = new DataTable();
                dataTable.Locale = CultureInfo.CurrentCulture;
                adapter.Fill(dataTable);
                return dataTable;
            }
        }


    }
}

It works well with alphanumeric data
Like If we have below CSV data
Member1,BL,Yes
Member2,BL,No
Member3,BL,Yes

Then GetDataTableFromCsv retuen proper data in table like

Member1	BL	Yes
Member2	BL	No
Member3	BL	Yes

ButIf we have below CSV data
001,BL,Yes
002,BL,No
003,BL,Yes

Then GetDataTableFromCsv does not return proper data in table like

1	BL	Yes
2	BL	No
3	BL	Yes

I want return data to be in below format

001	BL	Yes
002	BL	No
003	BL	Yes

In summary I want the above CSV parsing method consider memberid column as string datatype instead of numeric data type so that It will parse it as it is (with 00)


Thanks in Advance
--Rahul D.