StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
2491936
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-03-22T11:54:48.327
FavoriteCount
0
LastActivityDate
2010-03-22T11:54:48.327
LastEditDate
LastEditorUserId
0
OwnerUserId
296392
ParentId
2468882
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
FAO CodeSleuth (and anyone else needing this). Thanks to you, and you helping me 'understand' the problem, I now have it working. My own code is as follows: <pre><code> Function GetEvents(ByVal [start] As Double, ByVal [end] As Double) As JsonResult Dim sqlConnection As New SqlClient.SqlConnection sqlConnection.ConnectionString = My.Settings.sqlConnection Dim sqlCommand As New SqlClient.SqlCommand sqlCommand.CommandText = "SELECT tripID AS ID, tripName AS Title, dateStart AS [Start], dateEnd AS [End] FROM tblTrip WHERE userID=18 AND DateStart IS NOT NULL" sqlCommand.Connection = sqlConnection Dim ds As New DataSet Dim da As New SqlClient.SqlDataAdapter(sqlCommand) da.Fill(ds, "Meetings") sqlConnection.Close() Dim meetings = From c In ds.Tables("Meetings") Select {c.Item("ID"), c.Item("Title"), "False", c.Item("Start"), c.Item("End"), "False"} Dim meetingsArray As New ArrayList() For Each dr As DataRow In ds.Tables("Meetings").Rows Dim m As New Meeting With m .AllDay = False .End = CDate(dr.Item("End")).ToJson() .ID = dr.Item("ID") .Start = CDate(dr.Item("Start")).ToJson() .Title = dr.Item("Title") End With meetingsArray.Add(m) Next Return Json(meetingsArray, JsonRequestBehavior.AllowGet) End Function </code></pre> and the following class definition: <pre><code>Public Class Meeting Public id As Integer Public title As String Public start As String Public [end] As String Public allDay As Boolean </code></pre> End Class and the following function, again thanks to you: <pre><code>Public Module DateTimeExtensionMethods Sub New() End Sub <System.Runtime.CompilerServices.Extension()> _ Public Function ToJson(ByVal dateTime As DateTime) As String Return dateTime.ToString("s") End Function </code></pre> End Module That works perfectly, although I do need to tweak it slightly to read from the Linq results (or simply change the SQL Command to filter). Again, many thanks for helping me understand the problem, I'm a firm believer that one needs to understand and now just copy code and your help has done that. Jason
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POPopulating FullCalendar events from MVC
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USJasonMHirst
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. 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.