将LinQ var转换为DataTable [英] Convert LinQ var into a DataTable

问题描述

嗨专家，



感谢关注。

Hi Experts,

Thanks For attention.

var results = from table1 in tree.AsEnumerable()
                     join table2 in direct.AsEnumerable() on (int)table1["ID"] equals (int)table2["ID"]
                     select new
                     {
                         ID= (int)table1["ID"],
                         Name = (int)table1["Name"],
                         MobileNumber= (int)table1["MobileNumber"],
                         Address= (int)table2["Address"],
                         FatherName= (int)table2["FatherName"],

                     }

我想要var 结果转换为DataTable。

赞：



DataTable dt = result;



先谢谢你的帮助。

I want the var results convert into a DataTable.
Like:

DataTable dt=result;

Thanks in Advance For Help.

推荐答案

创建一个结果相同的数据表

即。

create a datatable with same structure of result
ie.

DataTable dt = new DataTable();
               dt.Columns.Add("ID", typeof(int));
               dt.Columns.Add("Name", typeof(int));
               dt.Columns.Add("MobileNumber", typeof(int));
               dt.Columns.Add("Address", typeof(int));
               dt.Columns.Add("FatherName", typeof(int));
               var results = from table1 in tree.AsEnumerable()
                             join table2 in direct.AsEnumerable() on (int)table1["ID"] equals (int)table2["ID"]
                             select new
                             {
                                 ID = (int)table1["ID"],
                                 Name = (int)table1["Name"],
                                 MobileNumber = (int)table1["MobileNumber"],
                                 Address = (int)table2["Address"],
                                 FatherName = (int)table2["FatherName"],
                             };
               foreach (var item in results)
               {
                   DataRow dr = dt.NewRow();
                   dr["ID"] = item.ID;
                   dr["Name"] = item.Name;
                   dr["MobileNumber"] = item.MobileNumber;
                   dr["Address"] = item.Address;
                   dr["FatherName"] = item.FatherName;
                   dt.Rows.Add(dr);
               }

您好，



请参阅以下链接。

它可能会帮助您解决问题。



将Linq查询结果转换为DataTable [ ^ ]



谢谢，

Viprat

Hi,

See the below link.
It might be help you to solve your problem.

Convert Linq Query Result To DataTable[^]

Thanks,
Viprat

试试这个



http://www.c-sharpcorner.com/uploadfile/VIMAL.LAKHERA/convert-a-linq-query-resultset -to-a-datatable / [ ^ ]



http://unboxedsolutions.com/sean/archive/2009/06/06/15961.aspx [ ^ ]

try this

http://www.c-sharpcorner.com/uploadfile/VIMAL.LAKHERA/convert-a-linq-query-resultset-to-a-datatable/[^]

http://unboxedsolutions.com/sean/archive/2009/06/06/15961.aspx[^]

这篇关于将LinQ var转换为DataTable的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！