Show any csv file to DataGridView in WinForm

Joni Hysa

I have a simple program that open a dialog box , take a .csv file, show the name of file. Now I need to put that csv data into DataGridView. Can anyone help me finding a solution even if it was a book or anything else. Thank you.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo8y ago
1. string FileName = ...
2. OleDbConnection conn = new OleDbConnection
3. ("Provider=Microsoft.Jet.OleDb.4.0; Data Source = " +
4. Path.GetDirectoryName(FileName) +
5. "; Extended Properties = \"Text;HDR=YES;FMT=Delimited\"");
7. conn.Open();
9. OleDbDataAdapter adapter = new OleDbDataAdapter
10. ("SELECT * FROM " + Path.GetFileName(FileName), conn);
12. DataSet ds = new DataSet("Temp");
13. adapter.Fill(ds);
15. conn.Close();
hi below code try
private static DataTable GetDataTabletFromCSVFile(string csv_file_path)
       {
           DataTable csvData = new DataTable();
           try
           {
             using(TextFieldParser csvReader = new TextFieldParser(csv_file_path))
                {
                   csvReader.SetDelimiters(new string[] { "," });
                   csvReader.HasFieldsEnclosedInQuotes = true;
                   string[] colFields = csvReader.ReadFields();
                   foreach (string column in colFields)
                   {
                       DataColumn datecolumn = new DataColumn(column);
                       datecolumn.AllowDBNull = true;
                       csvData.Columns.Add(datecolumn);
                   }
                   while (!csvReader.EndOfData)
                   {
                       string[] fieldData = csvReader.ReadFields();
                       //Making empty value as null
                       for (int i = 0; i < fieldData.Length; i++)
                       {
                           if (fieldData[i] == "")
                           {
                               fieldData[i] = null;
                           }
                       }
                       csvData.Rows.Add(fieldData);
                   }
               }
           }
           catch (Exception ex)
           {
           }
           return csvData;
       }
     }