My problem is this.
Say, I got a list of customer, who inturn will have list of orders. Each order will have orderdetails list inside it.
I want to display the above information in a hierarchial fashion.
The solution has to look like this.
Customer
Order
OrderDetails.
I created a typed dataset with customer as parent, order as a child of customer and orderdetails as child of order.
In the UI, i created 3 bands respectively. When I bind the data, I can see only the first two band details. i.e. Customer and order. I couldn't see the orderdetails information. How can I achieve this? Any samples will be of great help?
I got the problem.
Though I have defined the relationship, the data didnt get populated.
As a resut, I was able to see the first two hierarchy.
a) What version are you using?
b) Does each "Order" have corresponding "OrderDetails"?
If you are using 8.1, there was a very obscure bug in that release where (if memory serves) if the first Order record the grid encountered while binding did not have any associated OrderDetails, then the third band would not show, even though it should. If the first Order encountered had associated OrderDetails, then everything was fine, even if subsequent Orders did not have associated OrderDetails.
We fixed that in the first 8.1 hotfix, but you might check to ses if your running into that specific issue.
Devin
Retrive data and create relationships ex:
Dim str_SQl As String = "spToGetHeaders"
Dim myCommand As SqlCommand = New SqlCommand(str_SQL, yourSqlConn)
myCommand.CommandType = CommandType.StoredProcedure
Example of setting up relationships in the dataset (vb):
ds_BO_Headers_and_Lines.Tables.Add("LineItems")
Try
sqlConnApps.Open()
'Retrive Header datatable
myDA.Fill(ds_BO_Headers_and_Lines.Tables("Headers"))
str_SQl = "SPtogetLineItems"
myCommand.CommandText = str_SQl
myDA.Fill(ds_BO_Headers_and_Lines.Tables("LineItems"))
'Retrive BO PO DataTable
str_SQl = "spTogetBoPos"
myDA.Fill(ds_BO_Headers_and_Lines.Tables("BOPO"))
ds_BO_Headers_and_Lines.Relations.Add("BO_POs", ds_BO_Headers_and_Lines.Tables("LineItems").Columns("WHDP"), ds_BO_Headers_and_Lines.Tables("BOPO").Columns("WHDP"))
Sometimes I have seen a band not displaying becuase of data issues like non-unique data in the columns used to form the relationships.
Hope it helps.
Patrick
Hello,
When you bind strong types dataset to UltraWebGrid you have to fill the instance of dataset through adapters and then just bind to grid, but if you have observation of some issue that show often you can submit at that link:
https://ko.infragistics.com/my-account/submit-support-request/
Hope that helps.
The most common mistakes I've seen are:
I have an example of binding to a four-level DataSet (not strongly typed) posted at:
https://ko.infragistics.com/community/forums/f/ultimate-ui-for-windows-forms/17902/group-by-row-show-the-item-count-problem#17902
HTH