如何在GridView中显示linq查询数据 [英] how to display linq query data into gridview

问题描述

先生
我有两个数据表，我正在使用linq查询将这两个表连接起来
我有以下代码.

sir
I have two datatables I am joining these two tables using linq query
I have following code.

<pre lang="C++">DataTable dt = new DataTable();<br />
           dt.Columns.Add("ID",typeof(string));<br />
           dt.Columns.Add("Name", typeof(string));<br />
<br />
           DataRow dr = dt.NewRow();<br />
           dr["ID"] = "1";<br />
           dr["Name"] = "Test1";<br />
           dt.Rows.Add(dr);<br />
<br />
           dr = dt.NewRow();<br />
           dr["ID"] = "2";<br />
           dr["Name"] = "Test2";<br />
           dt.Rows.Add(dr);<br />
<br />
           DataTable dt1 = new DataTable();<br />
           dt1.Columns.Add("ID", typeof(string));<br />
           dt1.Columns.Add("Product", typeof(string));<br />
<br />
           dr = dt1.NewRow();<br />
           dr["ID"] = "1";<br />
           dr["Product"] = "Test-Product";<br />
           dt1.Rows.Add(dr);<br />
           dataGridView1.DataSource = dt;<br />
           dataGridView2.DataSource = dt1;<br />
<br />
<br />
<br />
           var c = from p in dt.AsEnumerable()<br />
                   join d in dt1.AsEnumerable() on p.Field<string>           ("ID")        equals d.Field<string>("ID")<br />
                          select new { ID = p.Field<string>("ID"), Name = p.Field<string>("Name"), Product = d.Field<string>("Product")};</pre><br />

我想将上面的Linq查询 c 显示到gridview
我有一个代码

I want to display the above Linq query c display into gridview
I have a code

<pre lang="C++">dataGridView3.DataSource = c.CopyToDataTable<DataRow>();</pre><br />

但这是错误
请给我答案.

But it is error
Pls give me answer.

推荐答案

只需将数据源设置为c
就像在dataGridView3.DataSource = c;

Just set the data source to c
as in dataGridView3.DataSource = c;

中一样，只需将结果转换为ToList .i.e

Just convert you result to ToList.i.e

dataGridView3.DataSource = c.ToList();

就是这样！

That''s it!

这篇关于如何在GridView中显示linq查询数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！