求一方法将linq查询出的结果IQueryable类型 转换为DataTable类型
如下:
public static IQueryable<Teachers> List(int depID,string teacherName)
{
KymisDataContext ky = new KymisDataContext(); IQueryable<Teachers> teacherList; teacherList = from teacher in ky.Teachers
where (teacher.DepID == depID || depID == 0)
&& (teacher.TeacherName.Contains(teacherName) || teacherName == "")
select teacher;
return teacherList;
}ss=list(depid,tname);DataTable dt=new DataTable();
dt=ConvertToDataTable(ss);现在求方法ConvertToDataTable 谢谢各位前辈赐教!
如下:
public static IQueryable<Teachers> List(int depID,string teacherName)
{
KymisDataContext ky = new KymisDataContext(); IQueryable<Teachers> teacherList; teacherList = from teacher in ky.Teachers
where (teacher.DepID == depID || depID == 0)
&& (teacher.TeacherName.Contains(teacherName) || teacherName == "")
select teacher;
return teacherList;
}ss=list(depid,tname);DataTable dt=new DataTable();
dt=ConvertToDataTable(ss);现在求方法ConvertToDataTable 谢谢各位前辈赐教!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货