StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
1973638
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2009-12-29T09:01:19.723
FavoriteCount
0
LastActivityDate
2009-12-29T09:01:19.723
LastEditDate
LastEditorUserId
0
OwnerUserId
240058
ParentId
1972597
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
in your page, write this js method, it takes a parent and a child dropdown and it will fill the child dropdown asynchronously based on the parent dropdown's selected value: <pre><code> function LoadDataHandle(cmbParent,cmbChild,Type) { var cmb = document.getElementById(cmbParent); var mydate = new Date() mydate.setDate(mydate.getDate()) $.get("GetItems.aspx?ID=" + cmb.value + "&Type=" + Type + "&x=" + mydate.getMilliseconds(), function(data) { LoadData(data, cmbChild); }); } function LoadData(strData, cmbChild) { var cmb = document.getElementById(cmbChild); cmb.options.length = 0; var choose = document.createElement('option'); choose.text = "--- اختر ---"; choose.value = -1; cmb.add(choose); if (strData.length > 0) { var data = strData.split('$'); var i = 0; for (i = 0; i < data.length - 1; i++) { var data1 = data[i].split('#'); var item = document.createElement('option'); item.value = data1[0]; item.text = data1[1]; cmb.add(item); } } } </code></pre> note that use of jqyery's $get method passing in the aspx page having the parentid in the query string. now in your page_load event of the aspx page containing the dropdowns <pre><code> Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load cmdParent.Attributes.Add("onchange", "LoadDataHandle('" & cmdParent.ClientID & "','" & cmdChild.ClientID & "');") End Sub </code></pre> we are almost done, note that in the GetItems.aspx age you will need to write out the items that should be filled in the child dropdown items as a single long string where each item is separated by a '#'. here is a sample of doing this : <pre><code> Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim ID As Integer = Request.QueryString("ID") Response.Write(GetDepartment(ID)) End Sub Private Function GetDepartment(ByVal ID As String) As String Dim dt As DataTable = 'get from db If dt IsNot Nothing AndAlso dt.Rows.Count > 0 Then Dim sb As New StringBuilder(dt.Rows.Count * 20) For Each row As DataRow In dt.Rows sb.AppendFormat("{0}#{1}$", row(0), row(1)) Next Return sb.ToString End If Return "" End Function </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POPopulate dropdownlist asynchronously
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USAli Tarhini
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. 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.