StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POasp.net Sorting an inner ListView
primarykey
Id
9925697
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-03-29T12:50:30.903
FavoriteCount
0
LastActivityDate
2012-03-29T15:38:59.013
LastEditDate
LastEditorUserId
0
OwnerUserId
1198344
ParentId
0
PostTypeId
1
Score
0
ViewCount
641
LastEditorDisplayName
text
Body
I've only been using asp.net for about a month now so I hope my vernacular makes sense. I would much rather prefer to use MVC but this particular view page seemingly has to be using aspx and code-behind files as it needs to be "included" in a flat-file CMS. I have 3 nested ListViews. The first is populated (databound) from my code-behind file using LINQ and works great, gets a list of years. Then for the second ListView I call a function GetRecordsFromYear which gets all the records, again using LINQ in the code-behind. <pre><code><asp:ListView ID="lv2" runat="server" DataSource='<%# GetRecordsFromYear(Convert.ToInt32(Container.DataItem)) %>'> </code></pre> Next, for each Record there is a navigation property (one-to-many relationship with another table) with Degrees. The Degrees table has a column named "gradyear" which is what I want to sort this last ListView by. I can output this fine by doing something like: <pre><code><asp:ListView ID="lv3" runat="server" DataSource='<%# Eval("Degrees") %>'> </code></pre> Everything works perfectly except I can't figure out how to sort this final ListView. I can't use LINQ because I never really retrieved this data, it's a navigation property of the first table Records. I guess I could probably just use another function to retrieve the data but it seems silly to have to keep querying the database all the time when I have the navigation property available to me. I don't want a button to sort it, just have it sorted by default.
Tags
<asp.net><entity-framework><listview><sorting><nested>
Title
asp.net Sorting an inner ListView
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USVince Ruppert
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.