Show any csv file to DataGridView in WinForm

Question

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.

Laxmidhar Sahoo · Answer

string FileName = ... OleDbConnection conn = new OleDbConnection ( "Provider=Microsoft.Jet.OleDb.4.0; Data Source = " + Path.GetDirectoryName(FileName) + "; Extended Properties = \"Text;HDR=YES;FMT=Delimited\"" ); conn.Open(); OleDbDataAdapter adapter = new OleDbDataAdapter ( "SELECT * FROM " + Path.GetFileName(FileName), conn); DataSet ds = new DataSet( "Temp" ); adapter.Fill(ds); 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 { if (fieldData[i] == "" ) { fieldData[i] = null ; } } csvData.Rows.Add(fieldData); } } } catch (Exception ex) { } return csvData; } }

Show any csv file to DataGridView in WinForm

Answers (1)