Sandeep Kumar

Sandeep Kumar

  • 1.1k
  • 683
  • 60.7k

Error Showing when Converting CSV file to datatable

May 4 2023 1:53 PM

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


Answers (1)