StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POCascading dropdowns for C# ASP.NET
primarykey
Id
8932979
data
AcceptedAnswerId
8933028
AnswerCount
3
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-01-19T20:42:23.577
FavoriteCount
0
LastActivityDate
2014-01-15T23:23:23.093
LastEditDate
LastEditorUserId
0
OwnerUserId
1830549
ParentId
0
PostTypeId
1
Score
2
ViewCount
1910
LastEditorDisplayName
text
Body
I'm trying to create some cascading drop downs. I have my States loading via C# page load fine. I just can't seem to get anything to fire off to load the cities. After the cities, I'll be adding another drop down, but I can figure that out once I have this working. I did notice "Default.aspx/LoadCitiesByState 500 (Internal Server Error)" in my Chrome errors. C# <pre><code> protected void LoadStates() { // Populate State dropdown box ListItem li = new ListItem(); li.Value = "0"; li.Text = "Select One"; DataSet dsState = SharedData.GetStates(); ddlState.DataSource = dsState.Tables[0].DefaultView; ddlState.DataValueField = "ab"; ddlState.DataTextField = "name"; ddlState.DataBind(); ddlState.Items.Insert(0, li); } [WebMethod] protected void LoadCitiesByState(string state) { ListItem li = new ListItem(); li.Value = "0"; li.Text = "Select One"; DataTable dt = new DataTable(); dt = SharedData.GetCities(state); ddlCity.DataSource = dt.Rows[0].Table.DefaultView; ddlCity.DataValueField = "ListCity"; ddlCity.DataTextField = "ListCity"; ddlCity.DataBind(); ddlCity.Items.Insert(0, li); } </code></pre> Markup <pre><code><asp:DropDownList ID="state" runat="server" MaxLength="50" Style="width: 200px;" /> <asp:DropDownList ID="city" runat="server" MaxLength="50" Style="width: 200px;" /> function loadCities(selectedItem) { $.ajax({ type: "POST", url: "Default.aspx/LoadCitiesByState", data: "selectedItem", contentType: "application/json; charset=utf-8", dataType: "json", async: true, success: function Success(data) { alert(selectedItem); } }); </code></pre>
Tags
<c#><jquery>
Title
Cascading dropdowns for C# ASP.NET
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USTrey Copeland
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. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POCascading dropdowns for C# ASP.NET
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POCascading dropdowns for C# ASP.NET
 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.