1. private DataTable ReadAsDataTable(string file, bool hasHeader, char seperator)
    {
    DataTable dt = new DataTable();

    StreamReader reader = new StreamReader(file);
    string line = string.Empty;
    string[] data = null;
    int counter = 0;

    while (reader.Peek() != -1)
    {
    line = reader.ReadLine();
    data = line.Split(seperator);

    if (hasHeader)
    {
    if (counter == 0)
    {
    foreach (string item in data)
    {
    dt.Columns.Add(item);
    }
    }
    else
    dt.Rows.Add(data);
    }
    else
    dt.Rows.Add(data);

    counter++;
    }

    reader.Close();
    return dt;
    }


    Calling function
    DataTable result = ReadAsDataTable(@"C:\temp\data.csv", true, ',');
    0

    Add a comment

Blog Archive
Topics
Topics
Loading
Dynamic Views theme. Powered by Blogger. Report Abuse.