Hi.
How to save TreeView. I have no problem read data from database, like this:
Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
Me.TblSkydeHoldTableAdapter.Fill(Me.SkyttecenteretDataSet.tblSkydeHold)
Me.RadTreeView1.DisplayMember = "name"
Me.RadTreeView1.ParentMember = "pid"
Me.RadTreeView1.ChildMember = "id"
Me.RadTreeView1.ValueMember = "id"
Me.RadTreeView1.DataSource = Me.GetSampleData()
End Sub
Private Function GetSampleData() As DataTable
Dim dt As New DataTable()
Dim dc As New DataColumn()
dc.ColumnName = "id"
dc.DataType = GetType(Integer)
dt.Columns.Add(dc)
Dim dc1 As New DataColumn()
dc1.ColumnName = "name"
dc1.DataType = GetType(String)
dt.Columns.Add(dc1)
Dim dc2 As New DataColumn()
dc2.ColumnName = "pid"
dc2.DataType = GetType(Integer)
dt.Columns.Add(dc2)
Me.TblSkydeHoldTableAdapter.Fill(Me.SkyttecenteretDataSet.tblSkydeHold)
For Each dRow As DataRow In Me.TblSkydeHoldTableAdapter.GetData
Dim dr As DataRow = dt.NewRow()
dr(0) = dRow.Item("dr0")
dr(1) = dRow.Item("dr1")
dr(2) = dRow.Item("dr2")
dt.Rows.Add(dr)
Next
Return dt
End Function
But my problem starts when i want to save back to database. When i add a new node, the node have no parentmember value or valuemeber value. Is it possible to add those values automaticly when a new node is created?
Kindly Peter
3 Answers, 1 is accepted
Hello Peter,
The provided code snippet is greatly appreciated. If your RadTreeView is bind to a DataTable, then all the changes that you are doing are automatically saved to the DataTable and they are "stacked" there until you push them to the database. You can do this by calling the Update method of the TableAdapter. More information is available at the following MSDN documentation:
- https://docs.microsoft.com/en-us/previous-versions/visualstudio/visual-studio-2012/bz9tthwx(v=vs.110)?redirectedfrom=MSDN
- https://docs.microsoft.com/en-us/previous-versions/visualstudio/visual-studio-2012/ms171933%28v%3dvs.110%29
I hope this information is useful. Do not hesitate to contact me if you have other questions.
Regards,
Nadya
Progress Telerik
Our thoughts here at Progress are with those affected by the outbreak.
Rank 1
Hi Nadya
I finnaly got it to work. I dont know why, but i did not used the id i the datatable as childmeber (stupid) ;-)
Thanx
Peter
Hello Peter,
I am glad that you managed to get it works. Should you have any other questions do not hesitate to ask.
Regards,
Nadya
Progress Telerik
Our thoughts here at Progress are with those affected by the outbreak.