Import XML and its attribute into SQL server 2000

Navigation

		Wrox Programmer Forums > C# and C > C# 1.0 > C#
Import XML and its attribute into SQL server 2000

C# Programming questions specific to the Microsoft C# language. See also the forum Beginning Visual C# to discuss that specific Wrox book and code.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the C# section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .

Thread Tools

Search this Thread

Display Modes

#1 (permalink)

April 13th, 2005, 09:57 AM

khautinh

Authorized User

Join Date: Jun 2003

Location: , , .

Posts: 45

Thanks: 0

Thanked 0 Times in 0 Posts

Import XML and its attribute into SQL server 2000

Hi all,

I have this xml file
<root>
  <TermAndCondition SectionTest="section1">
    <TermTitle Section="section1" lvl="1">1. Test level 1.
      <SubTitle Section="section1" TermTitle="1. " lvl="2">
        a. Test Level a.
      </SubTitle>
      <SubTitle Section="section1" TermTitle="1. " lvl="2">
        b. Test Level b.
      </SubTitle>
    </TermTitle>
  </TermAndCondition>
</root>
What I would like to do is input this small xml data and its attribute into SQL server 2000 with C#. And I have a table in SQL server 2000 to store all these data. Can anyone have any sample codes please help? I am appreciated all helps.

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Trackbacks are Off Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to import XML into SQL Server	dbellavi	XML	1	February 26th, 2008 06:02 AM
SQL Server 2000 DTS Excel Import Error	Tglover	SQL Server DTS	0	June 22nd, 2007 12:27 PM
Import Fixed length - SQL SERVER 2000	carumuga	SQL Server 2000	4	December 23rd, 2006 10:18 AM
Import Data In MS SQL SERVER 2000	The Beginner	Classic ASP Basics	1	August 14th, 2006 04:59 PM
Import delimited flat file into SQL Server 2000	DevCsharp	C#	1	April 27th, 2005 11:52 PM

All times are GMT -4. The time now is 06:36 PM.

Need to download code?

Navigation