DataGridView setting up colums from textfile

See more:

DataGridView

Hi. I have a textfile with columns that I want to output in a DataGridView. The line that I want to read the clumn names from isn't in the beginning of the file so I have to look for a line that starts with #COLUMNNAME and read the coulm names from that line. The problem is that when I do this C# thinks that I want to count this "#COLUMNNAME" as a column. so what I want to do is something like filtering the line and ignore the "#COLUMNNAME" word and same for the last character in the text file for that line that ends with a ';'.

private void button2_Click(object sender, EventArgs e)
{
    foreach (string line in File.ReadLines(filePath))
    {
        if (line.Contains("#COLUMNNAME"))
        {
            string[] s = line.Split('\t');

            for (int i = 0; i <= s.Count() - 1; i++)
            {
                DataGridViewColumn columns = new DataGridViewTextBoxColumn();
                columns.Name = "col" + i.ToString();
                columns.HeaderText = s[i].ToString();
                dataGridView1.Columns.Add(columns);
            }
        }
    }
}

#COLUMNNAME	MapArea	MobId	MinLevel	MaxLevel	AbStateCnt	MinCen	MaxCen	CenRate	TradeBoxA	RateA	TradeBoxB	RateB	TradeBoxC	RateC	DrItem1      ;