Linq将不同的行筛选为数据表

Question

如何将下面的结果传递给数据表，以便在datagridview中显示?

        var query = from r in DtSet.Tables["tblCharge"].AsEnumerable()
                    select new
                        {invoice = r.Field<string>("InvNo"),
                         type = r.Field<string>("EorD")};

Thanks in advance

Answer 1

可以通过

dataGridView.DataSource = query.ToList();