Link to home
Start Free TrialLog in
Avatar of Charles Baldo
Charles BaldoFlag for United States of America

asked on

Write XML To SQL Table VB.Net

I have the below XML File in a vb.net winforms app.  I need to with it to a sql table

XML

<MachineConfiguraton>
  <Section value="Machine">
    <key name="Box.Enabled" value="True" />
    <key name="Box.InterfacePort" value="Com10" />
      <key name="Box.Speed" value="9600" />
  </Section>
....
....  
  <Section value="Printer">
    <key name="NeedsFilling" value="False" />
  </Section>  
</MachineConfiguraton>

SQL Table

CREATE TABLE Configuration
(
    Section varchar(255) NOT NULL,  
    [Key] varchar(255) NOT NULL,  
    Value varchar(255) NOT NULL
)

I need to do this with VB In this program I have a active valid SQL connection

Thank You
ASKER CERTIFIED SOLUTION
Avatar of McOz
McOz

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial