Yes thank you, exactly what i wanted. ;)

I am trying to get my head around LINQ and am going through some old code to practice, below is some code that i want to convert but cannot work out how to do it. anyone have any ideas please. Reading a csv file, getting first element only with some blank lines and should be able to populate combobox with something like: cboSiteLocation.Items.AddRange(lines.ToArray());

<pre lang="text">

using (StreamReader sr = new StreamReader(filepath)) { IEnumerable&lt;string&gt; lines = File.ReadLines(filepath); // LINQ query here string[] element; foreach (string line in lines) { if (!string.IsNullOrEmpty(line)) { element = line.Split(','); this.cboSiteLocation.Items.Add(element[0].Trim()); } Thanks in advance

I am trying to get my head around LINQ and am going through some old code to practice, below is some code that i want to convert but cannot work out how to do it.
anyone have any ideas please.
Reading a csv file, getting first element only with some blank lines and should be able to populate combobox with something like:
cboSiteLocation.Items.AddRange(lines.ToArray());

using (StreamReader sr = new StreamReader(filepath))
{
IEnumerable<string> lines = File.ReadLines(filepath); // LINQ query here

                string\[\] element;

                foreach (string line in lines)
                {
                    if (!string.IsNullOrEmpty(line))
                    {
                        element = line.Split(',');
                        this.cboSiteLocation.Items.Add(element\[0\].Trim());
                    }
                }                    
            }

Thanks in advance