locked
Help with XML needed. Newbie question. RRS feed

  • Question

  •  

    Hi,

     

    As I mentioned I’m a newbie trying to work with xml.

    My problem is: I've a XSD file and need to fill it with data from an Access database in VB2005.

     

    Can someone guide me to the solution (with vb code), please?

     

    For the past days I'm looking to all the post, help documentations, and as further as I look to them, more lost I’m.

     

    Thank you

     

    Monday, November 19, 2007 8:55 AM

Answers

  • What data you expect to find in the DB and where in XSD file you want to insert the data?

     

    Most likely you don't need to insert data into XSD but instead you need to create another XML file with data from DB that would be valid according to given XSD.

     

    In this case I'd recommend you to:

    Create DataSet.

    Reade XSD to this DataSet with ReaderXmlSchema().

    Copy data from DB to tables in the DataSet.

    Save DataSet with WriteXml().

     

    In any case you would need to code your program yourself.

    Wednesday, January 2, 2008 8:40 AM