troubleshooting Question

Loading XML Document

Avatar of yolish
yolish asked on
Visual Basic.NET
4 Comments1 Solution217 ViewsLast Modified:
I am trying to load an xml document that has the following format

<System>
  <sysinfo>
    <account>1</account>
  </sysinfo>
  <order>
    <mark>12</mark>
  </order>
  <detail>
     <marking>12-2</marking>
  </detail>
  <order>
    <mark>13</mark>
  </order>
  <detail>
     <marking>13-2</marking>
  </detail>
</system>

I am trying to load this into SQL Server. I have a SPROC that can handle the loading, my problem is getting the XML document into the SQL Server SPROC.

I have done a lot of research and have read use a DataSet, etc... but need some help on the VB.net part of things... Any and all help would be appreciated.

Thanks,
-t
ASKER CERTIFIED SOLUTION
LordWabbitLordWabbit

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros