A column named '1' already belongs to this DataTable.
My Code To Convert datatable
public static DataTable ConvertCSVtoDataTable(dynamic file) { DataTable dt = new DataTable(); using (StreamReader sr = new StreamReader(file.InputStream)) { string[] headers = sr.ReadLine().Split(','); foreach (string header in headers) { dt.Columns.Add(header); } while (!sr.EndOfStream) { string[] rows = sr.ReadLine().Split(','); DataRow dr = dt.NewRow(); for (int i = 0; i < headers.Length; i++) { dr[i] = rows[i]; } dt.Rows.Add(dr); } } return dt; } }
this is my csv file