How To Skip to Write The Fist Line of CSV File Into DataGridView

Apr 16 2012 2:15 PM
Hi,
I am trying to run an application which is supose to present a CSV file contents in a DataGridView.The problem is the csv file contains a line (Fiist Line) which is the Title of CSV like:
================================
Title: Titanic
Director,Year,Rate,Star1,Star2
James Cameron,1997,7.5,Leonardo DiCaprio,Kate Winslet
================================
and here is my code
private void btnLoadData_Click(object sender, EventArgs e)

{

    string rowValue;

    string[] cellValue;

    if (System.IO.File.Exists(txtPath.Text))

    {

        System.IO.StreamReader streamReader = new StreamReader(txtPath.Text);

        // Reading header

        rowValue = streamReader.ReadLine();

        cellValue = rowValue.Split(',');                

        for (int i = 0; i <= cellValue.Count() - 1; i++)

        {

            DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn();

            column.Name = cellValue[i];

            column.HeaderText = cellValue[i];

            dataGridView1.Columns.Add(column);

        }

       // Reading content

        while (streamReader.Peek() != -1)

        {

            rowValue = streamReader.ReadLine();

            cellValue = rowValue.Split(',');

            dataGridView1.Rows.Add(cellValue);

        }

        streamReader.Close();

    }

    else

    {

        MessageBox.Show("No File is Selected");

    }

}


 1- Can you please let me know how I can skip exporting the fist line (Title: Titanic) into the DataGridView?
2- How I can retrive the Fist line and Just the Title (Titanic) and not the "Title:" to use somehwre else?
Thanks for your time and support

Answers (2)