StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
4902918
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-02-04T21:04:12.343
FavoriteCount
0
LastActivityDate
2014-12-10T13:53:40.047
LastEditDate
2014-12-10T13:53:40.047
LastEditorUserId
318425
OwnerUserId
318425
ParentId
4891377
PostTypeId
2
Score
7
ViewCount
0
LastEditorDisplayName
text
Body
Here's a subclassed <code>DataGrid</code> with a <code>MaxRows</code> Dependency Property. The things to note about the implementation is if the <code>DataGrid</code> is in edit mode and <code>CanUserAddRows</code> is changed an <code>InvalidOperationException</code> will occur (like you mentioned in the question). <blockquote> InvalidOperationException 'NewItemPlaceholderPosition' is not allowed during a transaction begun by 'AddNew'. </blockquote> To workaround this, a method called <code>IsInEditMode</code> is called in <code>OnItemsChanged</code> and if it returns true we subscribe to the event <code>LayoutUpdated</code> to check <code>IsInEditMode</code> again. Also, if <code>MaxRows</code> is set to 20, it must allow 20 rows when <code>CanUserAddRows</code> is True, and 19 rows when False (to make place for the <code>NewItemPlaceHolder</code> which isn't present on False). It can be used like this <pre><code><local:MaxRowsDataGrid MaxRows="20" CanUserAddRows="True" ...> </code></pre> MaxRowsDataGrid <pre><code>public class MaxRowsDataGrid : DataGrid { public static readonly DependencyProperty MaxRowsProperty = DependencyProperty.Register("MaxRows", typeof(int), typeof(MaxRowsDataGrid), new UIPropertyMetadata(0, MaxRowsPropertyChanged)); private static void MaxRowsPropertyChanged(DependencyObject source, DependencyPropertyChangedEventArgs e) { MaxRowsDataGrid maxRowsDataGrid = source as MaxRowsDataGrid; maxRowsDataGrid.SetCanUserAddRowsState(); } public int MaxRows { get { return (int)GetValue(MaxRowsProperty); } set { SetValue(MaxRowsProperty, value); } } private bool m_changingState; public MaxRowsDataGrid() { m_changingState = false; } protected override void OnItemsChanged(System.Collections.Specialized.NotifyCollectionChangedEventArgs e) { base.OnItemsChanged(e); if (IsInEditMode() == true) { EventHandler eventHandler = null; eventHandler += new EventHandler(delegate { if (IsInEditMode() == false) { SetCanUserAddRowsState(); LayoutUpdated -= eventHandler; } }); LayoutUpdated += eventHandler; } else { SetCanUserAddRowsState(); } } private bool IsInEditMode() { IEditableCollectionView itemsView = Items; if (itemsView.IsAddingNew == false && itemsView.IsEditingItem == false) { return false; } return true; } // This method will raise OnItemsChanged again // because a NewItemPlaceHolder will be added or removed // so to avoid infinite recursion a bool flag is added private void SetCanUserAddRowsState() { if (m_changingState == false) { m_changingState = true; int maxRows = (CanUserAddRows == true) ? MaxRows : MaxRows-1; if (Items.Count > maxRows) { CanUserAddRows = false; } else { CanUserAddRows = true; } m_changingState = false; } } } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POWpf Datagrid Max Rows
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USFredrik Hedblad
UserOwnerUserId
1. USFredrik Hedblad
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POWpf Datagrid Max Rows
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
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.