How to filter a Dataset and save it into Xml ?

[Patrice Dargenton]

Hello, I can save my DataSet into Xml using ds.WriteXml(strXmlPath).
Now I would like to filter it like I can do using DataView.RowFilter into
another Xml file, but I don't know how to do it, because It always contains
the original DataSet, not the filtered one, any solution ?
Thanks.

 

[Cor Ligthert [MVP]]

Patrice,

See this little sample on our site, maybe can it help you.

http://www.windowsformsdatagridhelp.com/default.aspx?ID=655b418e-8e9d-4303-8be7-d6ad9bebf57f

I hope this helps,

Cor

 

[Patrice Dargenton]

It works fine, thanks a lot !

Dim dvFiltered As New DataView(ds.Tables(sMyTable))
dvFiltered.RowFilter = sMyCriteria
Dim dtFiltered As DataTable = dvFiltered.Table.Clone
For Each dvr As DataRowView In dvFiltered
dtFiltered.ImportRow(dvr.Row)
Next dvr
Dim dsFiltered As New DataSet
dsFiltered.Tables.Add(dtFiltered)
dsFiltered.WriteXml(sMyPath)