Hello everyone.. I'm trying to convert table to XML file.. My code like this.. n it's success!!!
Dim ds As New DataSet
Dim cn As New SqlConnection("Initial Catalog=PDA;Data Source=Maizatulakmal;Integrated Security=True;")
Dim da As New SqlDataAdapter("select * from users", cn)
da.Fill(ds, "users")
ds.WriteXml("users.xml")
Now I want to read the XML file back and save it to table..
Dim
ds As New DataSet
Dim filePath As String
filePath = "users.xml"
ds.ReadXml(filePath)
What I'm suppose to do after this code to save the data from XML to my existing table? Thanksss!! a lot