Linq 嵌套问题
0
悬赏园豆：20
[已关闭问题]
<P>protected void Page_Load(object sender, EventArgs e)<BR> {<BR> var customer = new[]{new {PKId="001",Name="admin",Pwd="123456",Group="001"},<BR> new {PKId="002",Name="user",Pwd="user",Group="003"},<BR> new {PKId="003",Name="geust",Pwd="guest",Group="004"},<BR> new {PKId="004",Name="aa",Pwd="123456",Group="002"},<BR> new {PKId="005",Name="bb",Pwd="123456",Group="002"},<BR> new {PKId="006",Name="cc",Pwd="123456",Group="002"},<BR> };<BR> var groups = new[] { new { PKId = "001", depict = "最高权限" },<BR> new {PKId="002",depict="管理员"},<BR> new {PKId="003",depict="发布信息"},<BR> new {PKId="004",depict="只有浏览权限"}<BR> };<BR> GridView1.DataSource =<BR> from word2 in groups <BR> where word2.depict == "管理员"<BR> select new {<BR> quanxian = word2.depict,<BR> <BR> Name =<BR> from word in customer<BR> where word.Group==word.PKId<BR> select word <BR> };<BR> GridView1.DataBind();</P>
<P> <BR> <BR> }</P>
<P>================================</P>
<P>为什么 只显示</P>
<DIV>
<TABLE id=GridView1 style="BORDER-COLLAPSE: collapse" cellSpacing=0 rules=all border=1>
<TBODY>
<TR>
<TH scope=col>quanxian</TH></TR>
<TR>
<TD>管理员</TD></TR></TBODY></TABLE></DIV>
<P>Namd 信息为什么没有 。。 ？</P>
<P>谢谢 各位大哥了。。 </P>
其他回答(2)
0
where word2.depict == "管理员"
你这样写肯定只会显示管理员啊
0
好像是在select new里面不能再嵌套 from select
0
using System;
using System.Linq;
class P
{
static void Main()
{
var customer = new[]{new
{PKId="001",Name="admin",Pwd="123456",Group="001"},
new
{PKId="002",Name="user",Pwd="user",Group="003"},
new
{PKId="003",Name="geust",Pwd="guest",Group="004"},
new
{PKId="004",Name="aa",Pwd="123456",Group="002"},
new
{PKId="005",Name="bb",Pwd="123456",Group="002"},
new
{PKId="006",Name="cc",Pwd="123456",Group="002"},
};
var groups = new[] { new { PKId = "001",
depict = "最高权限" },
new
{PKId="002",depict="管理员"},
new
{PKId="003",depict="发布信息"},
new
{PKId="004",depict="只有浏览权限"}
};
var data =
from word2 in groups
where word2.depict == "管理员"
select new {
quanxian = word2.depict,
Name =
from word in customer
where word.Group==word.PKId
select word
};
var first = data.First();
Console.WriteLine("{0}, {1}",
first.quanxian, first.Name);
}
}
//下面是输出:
管理员, System.Linq.Enumerable+WhereArrayIterator`1[<>f__AnonymousType0`4[System
.String,System.String,System.String,System.String]]
看到没?Name的值是个其名IEnumerator.
正确的写法应该是:
var data =
from word2 in groups
where word2.depict == &
