Got more questions? Find advice on: ASP | SQL | Regular Expressions | Windows
in Search
Welcome to XmlAdvice Sign in | Join | Help

How to populate existing XML file by seletecting data from multiple grids using vb.net

Last post 12-26-2009, 14:33 by victor09. 0 replies.
Sort Posts: Previous Next
  •  12-26-2009, 14:33 58086

    How to populate existing XML file by seletecting data from multiple grids using vb.net

    I'm converting from ACCESS to XML, I'm able to do this for an ACCESS database but can't figure out how to do it with XML, basically, how do I update an xml file (file3),based on rows selected in grids 1 and 2?

    For example when I select GBR (Receiver_ID = 2) from the grid1 and 1305 from grid2 (Prop_NSN_ID = 1) how do I add the ID values to file 3 in the same row?

    File 1 (Data in Grid1 users will select)Nations

    <Root>

    <Row><Receiver_ID>1</Receiver_ID>

    <Description>FRA</Description>

    </Row>

    <Row><Receiver_ID>2</Receiver_ID>

    <Description>GBR</Description>

    </Row>

    <Row>

    <Receiver_ID>3</Receiver_ID>

    <Description>NLD</Description>

    </Row>

    <Row>

    <Receiver_ID>4</Receiver_ID>

    <Description>DEU</Description>

    </Row>

    <Row><Receiver_ID>5</Receiver_ID>

    <Description>USA</Description>

    </Row>

    </Root>

     

    File 2 (Data in Grid2 users will select)Prop_NSN

    <Root>

    <Row>

    <Prop_NSN_ID>1</Prop_NSN_ID>

    <Description>1305</Description>

    </Row>

    <Row>

    <Prop_NSN_ID>1</Prop_NSN_ID>

    <Description>1307</Description>

    </Row>

    <Row>

    <Prop_NSN_ID>1</Prop_NSN_ID>

    <Description>1309</Description>

    </Row>

    </Root>

     

    File 3 (File to be updated) - Link_Table

    <Root>

    <Row>

    <Receiver_ID>2</Receiver_ID>

    <Prop_NSN_ID>1</Prop_NSN_ID>

    </Row>

    </Root>

     

    Thanks,

     

    Victor

     

View as RSS news feed in XML