在控制器中显示来自Linq的数据以进行查看 [英] Displaying data from Linq in controller to view

问题描述

我在控制器中跟随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屋！