How to set UltraTree Control? | Infragistics Forums

1225

How to set UltraTree Control?

Steve posted over 13 years ago

Hello friends,

Please I need your help, I have this Query:

SELECT c.CategoryID , p.ProductID , c.CategoryName , p.ProductName
FROM Categories as C INNER JOIN Products as P
ON c.CategoryID = p.CategoryID

I need to show a tree with the head of the Parent Category table and within the detail of the Product table.

Please friend, any idea?

Thanks, God Bless you.

1225

Offline Steve posted over 13 years ago in reply to Georgi

Hi, thanks for your help, Please, I'm getting my data from each table in two different lists, but I obtain bad results, the PK from my Parent Table is is displayed several times.
This is my code, please any idea.

            objListCategoryInfo = obcCategory.CategorySelAll
            objListProductInfo = obcProduct.ProductSelAll

            Dim ds As New DataSet()
            Dim dt As New DataTable
            dt.Columns.Add("pCategoryId").DataType = System.Type.GetType("System.Int32")
            dt.Columns.Add("pCategoryName").DataType = System.Type.GetType("System.String")
            dt.Columns.Add("pDescription").DataType = System.Type.GetType("System.String")

            dt.Columns.Add("cProductId").DataType = System.Type.GetType("System.Int32")
            dt.Columns.Add("cCategoryId").DataType = System.Type.GetType("System.Int32")
            dt.Columns.Add("cProductName").DataType = System.Type.GetType("System.String")

            For i = 0 To objListCategoryInfo.Count - 1
                dt.Rows.Add(objListCategoryInfo(i).CategoryId, objListCategoryInfo(i).CategoryName, objListCategoryInfo(i).Description, 0, 0, "")
            Next
            For i = 0 To objListProductInfo.Count - 1
                dt.Rows.Add(objListProductInfo(i).CategoryId, "", "", objListProductInfo(i).ProductId, objListProductInfo(i).CategoryId, objListProductInfo(i).ProductName)
            Next

            ds.Tables.Add(dt)
            Dim dr As DataRelation = New DataRelation("RR", dt.Columns("cCategoryId"), dt.Columns("pCategoryId"), False)
            ds.Relations.Add(dr)

            utCategories.DataSource = ds.Tables(0)

Thanks, God Bless You.
Cancel
Reply

Cancel
53790

Georgi posted over 13 years ago in reply to Georgi

Hello Eros,

Have you been able to resolve your issue ? Did you have a time to take a look at the attached sample. Please let me know if you have any questions.

Regards
Cancel
Reply

Cancel
53790

Suggested Answer
Georgi posted over 13 years ago

Hello Eros,

There are different approaches to achieve the desired behavior. The first one is to split your query with Inner join to two different queries, without inner join. The first one will be select from your Categories table – Parent table, and second query (from Products) will be your child table. You could include both tables (the result set from your two queries) in DataSet. Then you could create a Relation between both tables using the same connection like it is in your Inner join.

Other approach could be by using directly the result set from your inner join (please note that by this was you will have duplicate items in your Categories table). I made small sample that shows the second approach. Please take a look at the attached sample for more details. Please let me know if you have any questions.

Regards

UltraTreeDataBindingFromInnerJoin.zip
Cancel
Reply

Reject Answer

Cancel