无法将类型“System.Linq.IQueryable”隐式转换为“System.Linq.IOrderedQueryabl

[www61550125]

CS0029: 无法将类型“System.Linq.IQueryable<AnonymousType#1>”隐式转换为“System.Linq.IOrderedQueryable<AnonymousType#1>”

var source = from a in this.db.Reader_JD_Comment
                         join b in this.db.Product on a.id equals b.id
                         select new
                         {
                             id = a.id,
                             pj = a.pj,
                             istj = a.istj,
                             parentid = a.parentid,
                             qd = a.qd,
                             isdel = a.isdel,
                             eppName = b.eppName,
                             buyFrom = a.buyFrom,
                             smallclass = a.smallclass,
                             username = a.username,
                             commentType = a.commentType,
                             yd = a.yd,
                             fabudate = a.fabudate,
                             fs = a.fs,
                             smallpic = b.smallpic,
                             spid = a.spid,
                             pinpai = b.pinpai,
                             price = b.price,
                             p_name = b.p_name,
                             pricewebCount = b.pricewebCount,
                             commentAVG = b.commentAVG,
                             commentCount = b.commentCount,
                             sellcount = b.sellcount,
                             smallpic80 = b.smallpic80
                         } into c
                         where !c.isdel == (c.fabudate < DateTime.Now)
                         where (c.commentType == 0) && (c.smallclass == this.id)
                         where c.parentid == 0
                         orderby c.fabudate descending
                         select c;
            string strPost = "_" + this.id + "_0";
            int iRecordCount = 0;
            short count = 20;
            short iPageCurrent = 1;
            iRecordCount = source.Count();
            iPageCurrent = Convert.ToInt16((iPageCurrent < 1) ? 1 : ((int)iPageCurrent));
            int num4 = (iPageCurrent - 1) * count;
            source = source.Skip(num4).Take(count);            this.rptComment.DataSource = source;
            this.rptComment.DataBind();
            this.lblPage.Text = common.NetPageWJT(iRecordCount, count, iPageCurrent, "Comment", strPost);

disProduct.aspx.cs 行: 65

行: 65 :source = source.Skip(num4).Take(count);




求教！

[threenewbee]

source = source.Skip(num4).Take(count);
=>
source = source.ToList().Skip(num4).Take(count);

[www61550125]

楼上的：
source = source.ToList().Skip(num4).Take(count);

同样错误。

[threenewbee]

var source = from a in this.db.Reader_JD_Comment
join b in this.db.Product on a.id equals b.id
select new
{
id = a.id,
pj = a.pj,
istj = a.istj,
parentid = a.parentid,
qd = a.qd,
isdel = a.isdel,
eppName = b.eppName,
buyFrom = a.buyFrom,
smallclass = a.smallclass,
username = a.username,
commentType = a.commentType,
yd = a.yd,
fabudate = a.fabudate,
fs = a.fs,
smallpic = b.smallpic,
spid = a.spid,
pinpai = b.pinpai,
price = b.price,
p_name = b.p_name,
pricewebCount = b.pricewebCount,
commentAVG = b.commentAVG,
commentCount = b.commentCount,
sellcount = b.sellcount,
smallpic80 = b.smallpic80
} into c
where !c.isdel == (c.fabudate < DateTime.Now)
where (c.commentType == 0) && (c.smallclass == this.id)
where c.parentid == 0
orderby c.fabudate descending
select c;
=>
var source = (from a in this.db.Reader_JD_Comment
join b in this.db.Product on a.id equals b.id
select new
{
id = a.id,
pj = a.pj,
istj = a.istj,
parentid = a.parentid,
qd = a.qd,
isdel = a.isdel,
eppName = b.eppName,
buyFrom = a.buyFrom,
smallclass = a.smallclass,
username = a.username,
commentType = a.commentType,
yd = a.yd,
fabudate = a.fabudate,
fs = a.fs,
smallpic = b.smallpic,
spid = a.spid,
pinpai = b.pinpai,
price = b.price,
p_name = b.p_name,
pricewebCount = b.pricewebCount,
commentAVG = b.commentAVG,
commentCount = b.commentCount,
sellcount = b.sellcount,
smallpic80 = b.smallpic80
} into c
where !c.isdel == (c.fabudate < DateTime.Now)
where (c.commentType == 0) && (c.smallclass == this.id)
where c.parentid == 0
select c).OrderByDescending(c => c.fabudate).ToList();

[www61550125]

还是同样一摸一样错误。

代码都替换过

[www61550125]

自己再顶一下

[回头是岸]

source = source.Skip(num4).Take(count); this.rptComment.DataSource = source;
把你这段改成：
this.rptComment.DataSource=source.Skip(num4).Take(count);
这样不就可以！

[beyond_me21]

source = source.Skip(num4).Take(count).ToList();

[jayrao5566]

source =source.orderby(c=> c.fabudate)