locked
How to Save Data from XML File ? RRS feed

  • Question

  • 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

    Friday, July 7, 2006 7:10 AM

Answers