linq查询结果怎么转换成datatable

public DataTable Getusermessage(int siteid, string userpwd)
{
DataClassesDataContext db = new DataClassesDataContext();
DataTable dt = new DataTable();
var messagelist = from m in db.pop_g where m.g_siteid == siteid orderby m.g_createtime descending select m;

return dt;
}

//怎么将messagelist转换成datatable返回呢？谢谢

试试

IEnumerable<DataRow> query =
from m in db.pop_g where m.g_siteid == siteid orderby m.g_createtime descending select m;

DataTable dt = query.CopyToDataTable<DataRow>();

dt=messagelist.asnuerable();

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息