I'm trying to use a dataset to populate the flytreeview element. I'm trying to use code from an earlier version of your product. My code:
Dim DSet As New Data.DataSet("DataBase")
Dim DTable As New Data.DataTable("TREE")
SQL = "SELECT NodeID, NodePARENT, NodeHTML " & _
"FROM LOOKUP_Tree " & _
"WHERE (ASOF = '" & ASOF & "') AND (NodeID > 1)" & _
"ORDER BY NodeSORT"
MyConnection = New Data.SqlClient.SqlConnection(ConnectionString)
Dim MyCommand As Data.SqlClient.SqlDataAdapter
MyCommand = New Data.SqlClient.SqlDataAdapter(SQL, MyConnection)
TREE1 = New System.Data.DataSet()
MyCommand.Fill(TREE1, "TREE_INFO")
DSet.Tables.Add(DTable)
DTable.Columns.Add("NodeID")
DTable.Columns.Add("NodePARENT")
DTable.Columns.Add("NodeHTML")
DTable.Columns.Add("Selected")
DTable.Rows.Add(New Object() {1, Nothing, "MFO", True})
For Each row As Data.DataRow In TREE1.Tables(0).Rows
Dim arr() As Object = row.ItemArray()
NodeID = arr(0)
NodePARENT = arr(1)
NodeHTML = arr(2)
DTable.Rows.Add(New Object() {NodeID, NodePARENT, NodeHTML})
Next
Dim hierarchicalData As IHierarchicalEnumerable = NineRays.WebControls.FlyTreeView.ConvertTabularDataToHierarchical(DSet, "TREE", "NodeID", "NodePARENT")
FlyTreeView1.DataSource = hierarchicalData
FlyTreeView1.DataBind()
I've added a gridview to the page to list the elements in DSet and all the records are there. The flytree view element on the aspx page lists only system.Data.DataRowView and no data.