I am working on a traditional WebForms project. In
the project I am trying out some Linq datasources with plans to eventually migrate to an MVC architecture. I am still very new to Linq.
I have a GridView using a Linq datasource.
The entities I am showing has a to many relationship
and I would
like to get
the maximum value of a column in
the many side of
the relationship.
I can show properties of
the base entity in
the gridview:
<asp:TemplateField HeaderText="Number" SortExpression="tJobBase.tJob.JobNumber">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("tJobBase.tJob.JobNumber") %>'>
</asp:Label>
</ItemTemplate>
</asp:TemplateField>
I can also show
the count of
the many related property:
<asp:TemplateField HeaderText="Number" SortExpression="tJobBase.tJob.tHourlies.Count">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("tJobBase.tJob.tHourlies.Count") %>'>
</asp:Label>
</ItemTemplate>
</asp:TemplateField>
Is there a way to get
the max value of a column called WeekEnding in
the tHourlies collection to show in
the GridView?
