c# - Link two tables to the grid view c#

Question

Friends,

I have 2 tables in my database called "Children " and "Funds" .

children's table contains "CID, Fname, Lname,.. etc".

Funds table contains "CID, Date, Fund.. etc.

My problem is I need to show "CID, Full name (Fname + Lname) ,Date, Fund" In my Data grid view. How can I do it friends?

Im using c# service based data base

标签： c#database

Answer 1

所以假设我们有两个类

public class Children {
    public string CID {get; set;}
    public string Lname {get; set;}
    public string Fname {get; set;}

}
public class Fund {
    public string CID {get; set;}
    public string Date {get; set;}
    public string Fund {get; set;}

}

然后在您的主要功能中，您有上面这些类的 2 个列表：

List<Children> Childrens; // It can be Ienumable also
List<Fund> Funds;

最后我们使用 linq 加入两个列表

var Lst = from child in Childrens join fund in Funds on child.CID equals 
            fund.CID select new {CID = child.child, 
            FullNam = child.Lname + " " + child.Fname, fund.Date, fund.Fund};

您有列表名称“Lst”，最后一步将其值添加到 datagridview