LINQ: LinqDataSource如何在代码隐藏中做列选择
本文关键字:隐藏 列选 选择 代码 LinqDataSource LINQ | 更新日期: 2023-09-27 18:16:31
<asp:LinqDataSource
ContextTypeName="ExampleDataContext"
TableName="Products"
Select="new(Key as ProductCategory,
Average(Price) as AvePrice)"
ID="LinqDataSource1"
runat="server">
</asp:LinqDataSource>
不知何故,我的Select .aspx文件(如上所示)不工作:所有列都在查询结果中返回。我将在后面的代码中做这个。
我如何在我的linqdatasource1_selected()中执行2个字段的选择?谢谢。
例如:
//通知:condition is sample
int ave ;
Queryable<Object> IQ = ContextTypeName.TableName.Where(x=>x.Price <= ave);
或
var Query = FROM objectNameSeleted IN ContextTypeName.TableName
WHERE (your condition) SELECT objectNameSeleted
List<object> Products = (from p in ExampleDataContext.Products
where CONDITION
select p).ToList<object>();
你忘了GroupBy="ProductCategory"