Charles Baldo
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.