Sending XML From .Net To SQLServer

[Guest]

Hi people I have a question about that:

Nowadays I'm using the Update Method from DataAdapter but i figure out that
it generate multiples roundtrip to my dbserver so i want to use XML to send
all my data to SQLServer and process that in just one travel

That XML have all my rows that are Added, Modified and Deleted on my
Win32Application....So it's possible to process if i send in XML???...

I saw that in SQLServer exist OPENXML function to accomplish that but i
don't know how to use it..

Please can you help me!!!!

Regards

 

[Sahil Malik [MVP]]

Yes it is possible. Look at SqlXml and UpdateGrams.

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/

 

[Val Mazur \(MVP\)]

Also check my KB article with an example how you could pass XML into SQL
Server stored procedure

http://support.microsoft.com/default.aspx?scid=kb;en-us;555266

--
Val Mazur
Microsoft MVP

http://xport.mvps.org

 

[Guest]

Do you have any example????

Yes it is possible. Look at SqlXml and UpdateGrams.

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/

 

[Guest]

the article is very interesting but i need to know how can i use XML to
execute INSERT, UPDATE and DELETE sentences......Do you know???

 

[Sahil Malik [MVP]]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/updategram_5kkh.asp

and

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/updategram_5kkh.asp

<--- In 2.0 you have a managed provider, in 1.1 you'll need to interop.

This is explained very well in Chapter 12 of my first book and Chapter 13 of
my second (not published yet).

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/

 

[Val Mazur \(MVP\)]

Hi,

Also check next example

http://support.microsoft.com/default.aspx?scid=kb;en-us;316244

--
Val Mazur
Microsoft MVP

http://xport.mvps.org