How to uplad csv file and save data in DataTable

A filePath variable is declared that contains the path to the CSV file to be read. A new DataTable object is created to hold the CSV data. The StreamReader class is used to open the CSV file located at filePath and read its contents. The first line of the CSV file is read using ReadLine(), which contains the column headers of the table. The column headers are split into an array of strings using the Split() method with a comma as the delimiter. A foreach loop is used to iterate over each header in the array of headers, and a new DataColumn is created with the header name and added to the DataTable using the Columns.Add() method. The remaining lines of the CSV file are read using a while loop, which continues until EndOfStream is reached. Each row is read using ReadLine(), which returns a string containing comma-separated values. The row string is split into an array of strings using the Split() method with a comma as the delimiter. A new DataRow object is created using NewRow(), and each value in the row array is assigned to the corresponding column using the Item[] property of the DataRow object. The DataRow object is added to the DataTable using the Rows.Add() method. After all rows have been read and added to the DataTable, the resulting DataTable object is returned, containing all of the data from the CSV file in a tabular format.

string filePath = @"C:\path\to\your\file.csv";

var dataTable = new DataTable();

using (var streamReader = new StreamReader(filePath))
{
    var headers = streamReader.ReadLine().Split(',');
    dataTable.Columns.AddRange(headers.Select(h => new DataColumn(h)).ToArray());

    while (!streamReader.EndOfStream)
    {
        var rows = streamReader.ReadLine().Split(',');
        var dataRow = dataTable.Rows.Add();
        dataRow.ItemArray = rows;
    }
}

Hi AMit

  I have written below . Is it o.k

parser.TextFieldType = FieldType.Delimited;
            parser.SetDelimiters("\t");

Thanks

Hi all

  I think separator is tab delimited. I am downloading file from facebook.

it is showing as id\tcreated_time and so on

Thanks

Hi Amit

  same issue which i just mentioned

I have written below line. Is hould show only id

var colname = dt.Columns[0].ColumnName;

and it shows like this

id	created_time	ad_id	ad_name	adset_id	adset_name	campaign_id	campaign_name	form_id	form_name	is_organic	platform	enter_your_child's_name	enter_your_child's_age	full_name	city	phone_number

Thanks

string filePath = @"C:\example\file.csv";
DataTable dataTable = new DataTable();
using (StreamReader reader = new StreamReader(filePath))
{
    // Read the first line of the CSV file to get the column names
    string[] columnNames = reader.ReadLine().Split(',');
    foreach (string columnName in columnNames)
    {
        dataTable.Columns.Add(columnName);
    }
    while (!reader.EndOfStream)
    {
        string[] fields = reader.ReadLine().Split(',');
        DataRow dataRow = dataTable.NewRow();
        for (int i = 0; i < fields.Length; i++)
        {
            dataRow[i] = fields[i];
        }
        dataTable.Rows.Add(dataRow);
    }
}

foreach (DataRow row in dataTable.Rows)
{
    foreach (DataColumn column in dataTable.Columns)
    {
        Console.Write(row[column] + " ");
    }

    Console.WriteLine();
}

It seems like you are using the ExcelReaderFactory to read a CSV file. However, as the name suggests, ExcelReaderFactory is used to read Excel files, not CSV files.

To read a CSV file and load its data into a DataTable, you can use the TextFieldParser class which is available in the Microsoft.VisualBasic.FileIO namespace. Here's an example of how you can modify your code to use TextFieldParser:

using Microsoft.VisualBasic.FileIO;

public static DataTable ReadCSVFile(string fileName)
{
    DataTable dataTable = new DataTable();
    using (TextFieldParser parser = new TextFieldParser(fileName))
    {
        parser.TextFieldType = FieldType.Delimited;
        parser.SetDelimiters(",");
        string[] headers = parser.ReadFields();
        foreach (string header in headers)
        {
            dataTable.Columns.Add(header);
        }
        while (!parser.EndOfData)
        {
            string[] fields = parser.ReadFields();
            DataRow row = dataTable.NewRow();
            for (int i = 0; i < headers.Length; i++)
            {
                row[i] = fields[i];
            }
            dataTable.Rows.Add(row);
        }
    }
    return dataTable;
}

Thanks