StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
3228801
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-07-12T13:08:15.237
FavoriteCount
0
LastActivityDate
2010-07-12T13:08:15.237
LastEditDate
LastEditorUserId
0
OwnerUserId
213738
ParentId
3222754
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
Okay, I know you are using asp.net and my example is based on PHP and MySQL, but since your problem seem to be about the JSON format autocomplete is expecting, I am posting anyway. Get the latest files from the <a href="http://jqueryui.com/download" rel="nofollow noreferrer">jQuery UI page</a>. The autocomplete need UI Core, UI Widget and UI Position from the base package. You also need the autocomplete widget itself. This example works well for me: The HTML: <pre><code><div> <input id="cities" /> </div> </code></pre> The script part: (It sends the search variable to cities.php as cities.php?term=) <pre><code>$(function() { $("#cities").autocomplete({ source: "backend/cities.php", minLength: 2, select: function(event, ui) { // perhaps do something with these? region = ui.item.id; country = ui.item.label; city = ui.item.value; secret = ui.item.secret; } }); }); </code></pre> The PHP in cities.php: (The variables id, label and value need to be used. Label is used to populate the drop down list. Value is entered into the input box when the label value is clicked in the list). <pre><code>// important to set header with charset header('Content-Type: text/html; charset=utf-8'); $term = $_POST["term"]; // some database stuff removed // loop it through and build array $n = 0; while ($row = $q->fetch()) { $row_array[$n]['id'] = $row['City']; $row_array[$n]['label'] = $row['Country']; $row_array[$n]['value'] = $row['Region']; $row_array[$n]['secret'] = 'blabla'; $n++; } // encode it to json format echo json_encode($row_array); </code></pre> The JSON sent back: (When ?term=new york) <pre><code>[{"id":"New York","label":"United States","value":"New York","secret":"blabla"},{"id":"Minnesota","label":"United States","value":"New York Mills","secret":"blabla"},{"id":"New York","label":"United States","value":"New York Mills","secret":"blabla"}] </code></pre> So, to recap: <ul> <li>By default, it sends the variable "term" with the search word to the backend page.</li> <li>It needs "id", "value" and the "label" variables to be sent back.</li> <li>By default the drop down list is populated with the "label"-values.</li> <li>By default, clicking in the list will fill out the input box with "value".</li> <li>You can put additional variable names and make something with them, but the three above is needed.</li> <li>The JSON syntax need to look as provided above.</li> </ul> I hope it helps.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POJquery autocomplete JSON return result from webservice but it is not showing in dropdownlist
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USMattis
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
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.