StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
3077473
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2010-06-19T22:26:20.367
FavoriteCount
0
LastActivityDate
2010-06-19T22:48:20.393
LastEditDate
2010-06-19T22:48:20.393
LastEditorUserId
284240
OwnerUserId
284240
ParentId
3077340
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<pre><code> Dim persSeparator as string=";" Dim keyValSeparator as string="="; Dim allPersons As New Dictionary(Of String, Person) Dim str As String = "Name=Fred;Birthday=19-June-1906;ID=12345" Dim parts As New List(Of String)(str.Split(persSeparator.ToCharArray)) 'why dont want you to split this string?? Dim person As New Person For Each part As String In parts Dim keyValue() As String = part.Split(keyValSeparator.toCharArray()) Select Case keyValue(0).ToUpper Case "ID" person.ID = keyValue(1) Case "NAME" person.Name = keyValue(1) Case "BIRTHDAY" person.BirthDay= keyValue(1) End Select Next If Not allPersons.ContainsKey(person.ID) Then allPersons.Add(person.ID, person) End If Public Class Person Private _name As String Private _birthday As String Private _id As String = String.Empty Public Sub New() End Sub Public Sub New(ByVal id As String) Me._id = id End Sub Public Sub New(ByVal id As String, ByVal name As String) Me._id = id Me._name = name End Sub Public Sub New(ByVal id As String, ByVal name As String, ByVal birthday As String) Me._id = id Me._name = name Me._birthday = birthday End Sub Public Property ID() As String Get Return Me._id End Get Set(ByVal value As String) Me._id = value End Set End Property Public Property Name() As String Get Return Me._name End Get Set(ByVal value As String) Me._name = value End Set End Property Public Property BirthDay() As String Get Return Me._birthday End Get Set(ByVal value As String) Me._birthday = value End Set End Property Public Overrides Function Equals(ByVal obj As Object) As Boolean If TypeOf obj Is Person AndAlso Not obj Is Nothing Then Return String.Compare(Me._id, DirectCast(obj, Person).ID) = 0 Else : Return False End If End Function End Class </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to convert a string of key/value pairs to HashTable or Dictionary or?
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USTim Schmelter
UserOwnerUserId
1. USTim Schmelter
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COProbably in `Case "BIRTHDAY" person.Name = keyValue(1)` you meant `person.Birthday = ...`
  singulars
  PostPostId
  PO
  UserUserId
  USabatishchev
2. COAlready changed, that happens when you dont test your code ;) Also changed type from BirthDay to String.
  singulars
  PostPostId
  PO
  UserUserId
  USTim Schmelter

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.