在控制器中显示来自Linq的数据以进行查看 [英] Displaying data from Linq in controller to view
本文介绍了在控制器中显示来自Linq的数据以进行查看的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在控制器中跟随Linq查询
I Have following Linq Query in Controller
ViewBag.data=(from cg in db.Colleges
from tn in db.Towns
from ds in db.Districts
where cg.CgTnCode ==tn.TnCode && tn.TnDscode==ds.DsCode
orderby ds.DsCode,tn.TnCode,cg.CgCode
select new
{
cg.CgCode,
cg.CgShName,
cg.CgName,
cg.CgType,
DsCode = ds.DsCode,
DsName=ds.DsName,
TnCode= tn.TnCode,
TnName=tn.TnName,
cg.CgAddr1,
cg.CgAddr2 ,cg.CgAddr3,cg.CgLoca,cg.CgPin,cg.CgPhone,cg.CgFax,cg.CgEmail ,cg.CgWeb,cg.CgOnlyCent});
我想要全部显示视图中的选定字段..
我已按照以下方式编写代码以访问ViewBag.data:
I want to display all selected fields in View..
I have written code in view to acess ViewBag.data as follows :
@foreach(var entry in ViewBag.data)
{
@entry.CgCode
@entry.CgShName
@entry.CgName
@entry.CgTnCode
@entry.DsCode
}
给出错误,因为它不包含'DsCode'的定义
我该怎么办才能有人帮忙? ?
Its Giving Error as does not contain a definition for 'DsCode'
what should I do can anyone help??
推荐答案
从视图转换为Enn的IEnumerable,如下所示
from the view cast to IEnumerable of Enity like below
@foreach(var entry in (IEnumerable<YourEntityClass>)ViewBag.data)
希望这有助于
Hope this helps
这篇关于在控制器中显示来自Linq的数据以进行查看的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文