StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
19255498
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-10-08T18:29:12.283
FavoriteCount
0
LastActivityDate
2013-10-08T18:34:13.480
LastEditDate
2013-10-08T18:34:13.480
LastEditorUserId
52551
OwnerUserId
52551
ParentId
19255353
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
There's a few issues with your code. First, despite the fact that you're passing a parameter <code>zone</code> to the web service method the method itself doesn't receive this parameter. Second, if you want to return JSON don't use the return type string. Use <code>JSONResult</code>. This will allow you to remove the static keyword as well. I'd recommend changing your method like so: <pre><code>public JSONResult GetCountry(int? zone) { // ... } </code></pre> There are two final changes you should make. The first is to use ASP.Net MVC's built in <code>Json()</code> method to handle serialization of your object. The second is that you should always project your data layer results even if they happen to already be in the structure you want to use. This way if you change your data layer object in a way that breaks the service you'll get a compile error instead of a run time exception. <pre><code>return Json(from c in Countries.GetAll() select new { Id = c.Id, Name = c.Name }) </code></pre> I'd also recommend avoiding using <code>$.get</code> or <code>$.post</code> as they abstract away settings that can be useful when access web services. If you want to shorthand it I'd recommend wrapping the <code>$.ajax</code> call in your own function. You're also going to want to think about standardizing your web service responses. Your web service is a protocol of sorts and as such it benefits from having a well defined header. For a more in-depth explanation take a look here: <a href="http://www.netortech.com/Blog/Entry/17/MVC-Service-Based-Web-Applications---Part-I---Introduction" rel="nofollow">Introduction to MVC Service Based Web Applications</a>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POUnable to parse JSON returned by JQuery ajax call
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USSpencer Ruport
UserOwnerUserId
1. USSpencer Ruport
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. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COI am using asp.net not MVC
 singulars
 PostPostId
 PO
 UserUserId
 USRaj Kumar
2. COIt would be a good idea to make the switch if possible.
 singulars
 PostPostId
 PO
 UserUserId
 USSpencer Ruport

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.