How to delete rows in xml files based on rows selected from a Grid?
Posted on 2011-02-24
How do I delete records in my Link.xml file when I delete a record from the grid control. For example if I select a row with Fuze_ID = 5, I would like to loop through my Link.xml file and delete all the records with Fuze_ID = 5.
I'm using the code code below, but I'm receiving the following error:
"Index 5 is either negative or above rows count"
On line: DV.Item(X).Delete()
Any ideas what's wrong with the code.
Dim dr As DataRow = dt.NewRow()
dr("Link_ID") = linkID
dr("Fuze_ID") = FuzeID
'Delete Selecete Record
Dim X As Integer
Dim DV As New DataView(dt, "Fuze_ID like " & "'" & C1TrueDBGrid.Columns(0).Value & "'" & "", Nothing, DataViewRowState.CurrentRows)
For X = 0 To DV.Count - 1
Dim DV1 As New DataView(dt, "", Nothing, DataViewRowState.CurrentRows)
Dim FilteredDT As DataTable
FilteredDT = DV1.ToTable
'put data back to xml file
FilteredDT.TableName = "Row"
FilteredDT.WriteXml(Application.StartupPath + "\Link.xml")