none
How to refresh XSD file when datasource (access db) is changed RRS feed

  • Question

  • Hi,

    I've generated an XSD file using access database as its datasource.
    However, I need to change the db schema.
    I need to add a few more columns and modify some data types.
    Is there a way of updating my XSD file without creating it again?

    Regards,

    Jean Grey
    Tuesday, November 24, 2009 2:13 AM

Answers

  • Hi guys,

    I found out that this could be done by selecting "Configure" in the dataset designer.
    Then in the TableAdapter configuration wizard, just modify the select query.
    Add/delete the columns that you added/deleted in the actual database.
    After clicking "Finish", the data tables are re-generated and so are the other commands.

    I hope this helps, even if it's just a tidbit of information.
    Btw, I'm using MS Visual Studio 2008.

    Regards, Jean Grey
    • Marked as answer by Jean Grey Wednesday, November 25, 2009 2:26 AM
    Wednesday, November 25, 2009 2:25 AM