C#

    private void LoadDatabaseBtn_Click(object sender, EventArgs e)
    {
        string filecsv = @"D:\Database.csv";
        DGV.DataSource = LoadCSV(filecsv);
        DGV.Refresh();
    }
    public List<Client> LoadCSV(string csvfile)
    {
       var query = from l in File.ReadAllLines(csvfile)
                    let data = l.Split(',')
                    select new Client
                    {
                        name= data[0],
                        id = data[1],
                        tel = data[2],
                        addr = data[3],
                        city = data[4],
                    };
        return query.ToList();
    }
}
public class Client
{
    public string name { get; set; }
    public string id { get; set; }
    public string tel { get; set; }
    public string addr { get; set; }
    public string city { get; set; }
}

private void filternameTxt_TextChanged(object sender, EventArgs e)
        {
            ClientsTableBindingSource.Filter = string.Format("name LIKE '%{0}%'", filternameTxt_Text);
            DGV.Refresh();
        }

Rectangle rc = hControl.ClientRectangle;

ivw.SetWindowPosition(rc.X, rc.Y, rc.Width , rc.Height);

Hi
I'm trying to create a "FinalDocument" list from another list "OriginDocument" 
The problem is that the "FinalDocument" does not have the correct Client Code.
So I want to get this Client Code from a third List "clients", for that I use the "TaxClienteID" field

It would be something like this:

List<FinalDocument> finalDocument = originDocument.Select(p => new FinalDocument()
{
documentcode = p.documentcode,
date = p.date,
...
codcliente = clients.codcliente where (TaxClienteID = clients.TaxClienteID)
})

I'm not getting it, the best I could get was with this:

List<FinalDocument> finalDocument = originDocument.Select(p => new FinalDocument()
{
documentcode = p.documentcode,
date = p.date,
...
clientcod = clients.Select(j => j.clientcod).Where(u => clients.Select(c => c.TaxClienteID.ToString()).Contains(p.TaxClienteID)).ToString()
}

But I get this in the customer clientcod field:
"System.Linq.Enumerable+WhereEnumerableIterator`1[System.String]"
and I don't know how to extract the value.

I'm sure there is a much simpler way, but I can't find it.
someone can help me?