StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
4419203
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2010-12-11T22:02:38.937
FavoriteCount
0
LastActivityDate
2010-12-11T22:08:31.480
LastEditDate
2010-12-11T22:08:31.480
LastEditorUserId
347374
OwnerUserId
347374
ParentId
4413383
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
on the code behind add a partial class to each table. The property [HasNoError] is return true if there are no errors The property [Error] is return the errors as string <pre><code>if(tablename.HasNoError) { // do your logic } else { // display tablename.Error } </code></pre> In the xaml side use the binding <pre><code><DataGridTextColumn Binding="{Binding Path=ActualFieldName1, ValidatesOnDataErrors=True, UpdateSourceTrigger=PropertyChanged }" Header=" ActualFieldName1" /> </code></pre> and this is the class sample using IDataErrorInfo- <pre><code>public partial class tablename : IDataErrorInfo { private Dictionary<string, string> errorCollection = new Dictionary<string, string>(); public bool HasNoError { get { return string.IsNullOrWhiteSpace(Error); } } public string Error { get { if (errorCollection.Count == 0) return null; StringBuilder errorList = new StringBuilder(); var errorMessages = errorCollection.Values.GetEnumerator(); while (errorMessages.MoveNext()) errorList.AppendLine(errorMessages.Current); return errorList.ToString(); } } public string this[string fieldName] { get { string result = null; switch (fieldName) { case "ActualFieldName1": if (string.IsNullOrWhiteSpace(this.ActualFieldName1)) { result = "ActualFieldName1 is required."; }; if (Other_Condition) { result = "Other Result"; }; break; case "ActualFieldName2": if (string.IsNullOrWhiteSpace(this.ActualFieldName2)) { result = "ActualFieldName2 is required."; }; if (Other_Condition) { result = "Other Result"; }; break; // and so } if (result != null && !errorCollection.ContainsKey(fieldName)) errorCollection.Add(fieldName, result); if (result == null && errorCollection.ContainsKey(fieldName)) errorCollection.Remove(fieldName); return result; } } } </code></pre> To make it nice add some style to target the error template see the example <pre><code><Style TargetType="{x:Type TextBox}"> <Setter Property="Validation.ErrorTemplate"> <Setter.Value> <ControlTemplate> <Border BorderBrush="Red" BorderThickness="1"> <Grid> <AdornedElementPlaceholder x:Name="MyAdorner"/> <Image Width="{Binding AdornedElement.ActualHeight, ElementName=MyAdorner}" Margin="0" ToolTip="{Binding AdornedElement.(Validation.Errors)[0].ErrorContent, ElementName=MyAdorner}" HorizontalAlignment="Right" VerticalAlignment="Center" Source="/Path/Exclamation.png" /> </Grid> </Border> </ControlTemplate> </Setter.Value> </Setter> </Style> </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POWPF Datagrid Cross row Validation
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USWaleed A.K.
UserOwnerUserId
1. USWaleed A.K.
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POWPF Datagrid Cross row Validation
 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
CommentsPostId
1. COI believe above works for cell level validation. for my multirow validation, i found this post, http://stackoverflow.com/questions/1729414/wpf-datagrid-how-to-validate-multiple-rows-and-mark-all-invalid-ones and also i combine ur cell level validation to display invalid cells. sorry i cannot mark ur reply as an answer since it is not giving correct solution to my problem.
 singulars
 PostPostId
 PO
 UserUserId
 USManohar

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.