private DataTable ReadCSV(string FileName) { DataTable csvDataTable = new DataTable(); try { //no try/catch - add these in yourselfs or let exception happen String[] csvData = File.ReadAllLines(FileName); //if no data if (csvData.Length == 0) { return csvDataTable; } String[] headings = csvData[0].Split(';'); //for each heading for (int i = 0; i < headings.Length; i++) { ////replace spaces with underscores for column names //headings[i] = headings[i].Replace(" ", "_"); //add a column for each heading csvDataTable.Columns.Add(headings[i]); } //populate the DataTable for (int i = 1; i < csvData.Length; i++) { //create new rows DataRow row = csvDataTable.NewRow(); for (int j = 0; j < headings.Length; j++) { //fill them row[j] = csvData[i].Split(';')[j]; } //add rows to over DataTable csvDataTable.Rows.Add(row); dataGrid1.ItemsSource = csvDataTable.DefaultView; } } catch (Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message.ToString()); } //return the CSV DataTable return csvDataTable; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)