StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
17837636
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-07-24T14:54:50.120
FavoriteCount
0
LastActivityDate
2013-07-25T12:39:12.480
LastEditDate
2013-07-25T12:39:12.480
LastEditorUserId
1081897
OwnerUserId
1081897
ParentId
17835966
PostTypeId
2
Score
3
ViewCount
0
LastEditorDisplayName
text
Body
The documentation for <a href="http://msdn.microsoft.com/en-us/library/system.data.datatable.locale.aspx" rel="nofollow"><code>DataTable.Locale</code></a> doesn't say anything about setting number formats; it says: <blockquote> Gets or sets the locale information used to compare strings within the table. </blockquote> So it may not do what you're expecting it to do. If you're auto-generating columns you may need to store the values as strings in the <code>DataTable</code> instead so you can specify the formatting. Another option is to attach to the <code>AutoGeneratingColumn</code> event to set custom column properties: excerpt from <a href="http://msdn.microsoft.com/en-us/library/cc903950%28v=vs.95%29.aspx" rel="nofollow">MSDN</a> : <pre><code>private void dataGrid1_AutoGeneratingColumn(object sender, DataGridAutoGeneratingColumnEventArgs e) { // Modify the header of the Name column. if (e.Column.Header.ToString() == "Name") e.Column.Header = "Task"; // Replace the DueDate column with a custom template column. if (e.PropertyName == "DueDate") { // Create a new template column. DataGridTemplateColumn templateColumn = new DataGridTemplateColumn(); templateColumn.Header = "Due Date"; templateColumn.CellTemplate = (DataTemplate)Resources["dueDateCellTemplate"]; templateColumn.CellEditingTemplate = (DataTemplate)Resources["dueDateCellEditingTemplate"]; templateColumn.SortMemberPath = "DueDate"; // ... // Replace the auto-generated column with the templateColumn. e.Column = templateColumn; } // Cancel AutoGeneration of all boolean columns. if (e.PropertyType == typeof(bool)) e.Cancel = true; if (e.PropertyName == "ValueField") { (e.Column as DataGridTextColumn).Binding.StringFormat = "N5"; } } </code></pre> I will say that auto-generating columns is a nice way to quickly prototype a grid but I usually end up directly configuring the columns to specify number formats, etc.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POC# number format in data table
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USD Stanley
UserOwnerUserId
1. USD Stanley
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POC# number format in data table
 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
 VTAcceptedByOriginator
2. 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.