1
Answer

Error Showing when Imporing Data from CSV file to datatable

Sandeep Kumar

Sandeep Kumar

1y
511
1

Error Msg="A column named '1' already belongs to this DataTable."

this is my CSV file which i want to import and make datatable

My Code is 

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;
}

Answers (1)