Insert data from XML file to SQL Database

[Dray]

Hi,

Could anyone please give me a code example of how to insert data from
an XML file into a SQL database. So far I've got the data sitting in a
dataset...

Thanks

[sloan]

Sql Server 2000 , OPENXML. Send the xml in as text (one way).
ds.GetXml() will work.

Sql Server 2005? SP2 introduced an slowness bug.
http://connect.microsoft.com/SQLServ...dbackID=250407

You'll have to consider sending in your ds.GetXml ..but convert it to
attribute based first.
Helper articles:
http://sholliday.spaces.live.com/blog/cns!A68482B9628A842A!148.entry
http://www.sqlservercentral.com/arti...rproblem/2283/
http://www.ipass.net/sloan/code/OPEN...yntax_Test.txt

Good luck.


"Dray" <al**@boxtop.co.ukwrote in message
news:7f**********************************@x35g2000 hsb.googlegroups.com...

Hi,

Could anyone please give me a code example of how to insert data from
an XML file into a SQL database. So far I've got the data sitting in a
dataset...

Thanks

[Dray]

On 8 Aug, 16:45, "sloan" <[e-mail]:

Sql Server 2000 , OPENXML. *Send the xml in as text (one way).
ds.GetXml() will work.

Sql Server 2005? *SP2 introduced an slowness bug.http://connect.microsoft.com/SQLServ...dback.aspx?Fee...

You'll have to consider sending in your ds.GetXml ..but convert it to
attribute based first.

Helper articles:http://sholliday.spaces.live.com/blog/cns!A68482B9628A842A!148.entryhttp://www.sqlservercentral.com/articles/Stored+Procedures/thezeroton...http://www.ipass.net/sloan/code/OPEN...yntax_Test.txt

Good luck.

"Dray" <[e-mail] in message

news:7f**********************************@x35g2000 hsb.googlegroups.com...

Hi,

Could anyone please give me a code example of how to insert data from
an XML file into a SQL database. So far I've got the data sitting in a
dataset...

Thanks- Hide quoted text -

- Show quoted text -

Hi, thanks for your help. I was however thinking of using sqldataapter
update to do this but are not sure how to go about it...

[sloan]

I think you're barking up the wrong tree, but that's me.

SqlDataAdapters have a very "row by row"-ness to them.

If you want the "set based" or "bulk-ness" of xml, I think you'll have to do
some coding.

Here is one last helper article:
http://support.microsoft.com/kb/315968

........


"Dray" <al**@boxtop.co.ukwrote in message
news:65**********************************@j22g2000 hsf.googlegroups.com...
On 8 Aug, 16:45, "sloan" <[e-mail]:

Sql Server 2000 , OPENXML. Send the xml in as text (one way).
ds.GetXml() will work.

Sql Server 2005? SP2 introduced an slowness
bug.http://connect.microsoft.com/SQLServ...dback.aspx?Fee...

You'll have to consider sending in your ds.GetXml ..but convert it to
attribute based first.

Helper
articles:http://sholliday.spaces.live.com/blog/cns!A68482B9628A842A!148.entryhttp://www.sqlservercentral.com/articles/Stored+Procedures/thezeroton...http://www.ipass.net/sloan/code/OPEN...yntax_Test.txt

Good luck.

"Dray" <[e-mail] in message

news:7f**********************************@x35g2000 hsb.googlegroups.com...

Hi,

Could anyone please give me a code example of how to insert data from
an XML file into a SQL database. So far I've got the data sitting in a
dataset...

Thanks- Hide quoted text -

- Show quoted text -

Hi, thanks for your help. I was however thinking of using sqldataapter
update to do this but are not sure how to go about it...