I have Varchar as my datatype, I checked CSV File in that Date column i found in the Format cells that the column is defined as Date. I think that may the problem , this is the code i use string ConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=\"Text;HDR=No;FMT=Delimited\\\""; System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(ConStr); System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter("Select * from " + file, conn); da.Fill(ds, "TextFile"); DGCsv.DataSource = ds.Tables[0].DefaultView;