Sending XML From .Net To SQLServer

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 :P

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
Tue Apr 05 17:10:09 CDT 2005

Yes it is possible. Look at SqlXml and UpdateGrams.

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



"Johny" <Johny@discussions.microsoft.com> wrote in message
news:57778A1A-444A-48F3-B1CB-B58B0254CE75@microsoft.com...
> 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 :P
>
> 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

Val
Tue Apr 05 19:43:45 CDT 2005

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



"Sahil Malik [MVP]" <contactmethrumyblog@nospam.com> wrote in message
news:envO8wiOFHA.2520@tk2msftngp13.phx.gbl...
> Yes it is possible. Look at SqlXml and UpdateGrams.
>
> - Sahil Malik [MVP]
> http://codebetter.com/blogs/sahil.malik/
>
>
>
> "Johny" <Johny@discussions.microsoft.com> wrote in message
> news:57778A1A-444A-48F3-B1CB-B58B0254CE75@microsoft.com...
>> 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 :P
>>
>> 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
>
>

Johny
Wed Apr 06 08:59:09 CDT 2005

Do you have any example????

"Sahil Malik [MVP]" wrote:

> Yes it is possible. Look at SqlXml and UpdateGrams.
>
> - Sahil Malik [MVP]
> http://codebetter.com/blogs/sahil.malik/
>
>
>
> "Johny" <Johny@discussions.microsoft.com> wrote in message
> news:57778A1A-444A-48F3-B1CB-B58B0254CE75@microsoft.com...
> > 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 :P
> >
> > 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
>
>
>

Johny
Wed Apr 06 09:01:06 CDT 2005

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???

"Val Mazur (MVP)" wrote:

> 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
>
>
>
> "Sahil Malik [MVP]" <contactmethrumyblog@nospam.com> wrote in message
> news:envO8wiOFHA.2520@tk2msftngp13.phx.gbl...
> > Yes it is possible. Look at SqlXml and UpdateGrams.
> >
> > - Sahil Malik [MVP]
> > http://codebetter.com/blogs/sahil.malik/
> >
> >
> >
> > "Johny" <Johny@discussions.microsoft.com> wrote in message
> > news:57778A1A-444A-48F3-B1CB-B58B0254CE75@microsoft.com...
> >> 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 :P
> >>
> >> 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
Wed Apr 06 10:20:25 CDT 2005

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/



"Johny" <Johny@discussions.microsoft.com> wrote in message
news:20C933B6-C463-4186-BF14-35817A209052@microsoft.com...
> Do you have any example????
>
> "Sahil Malik [MVP]" wrote:
>
> > Yes it is possible. Look at SqlXml and UpdateGrams.
> >
> > - Sahil Malik [MVP]
> > http://codebetter.com/blogs/sahil.malik/
> >
> >
> >
> > "Johny" <Johny@discussions.microsoft.com> wrote in message
> > news:57778A1A-444A-48F3-B1CB-B58B0254CE75@microsoft.com...
> > > 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 :P
> > >
> > > 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
> >
> >
> >

Val
Wed Apr 06 19:43:29 CDT 2005

Hi,

Also check next example

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

--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"Johny" <Johny@discussions.microsoft.com> wrote in message
news:C56E8431-F66B-4635-94B9-B58F4694F02F@microsoft.com...
> 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???
>
> "Val Mazur (MVP)" wrote:
>
>> 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
>>
>>
>>
>> "Sahil Malik [MVP]" <contactmethrumyblog@nospam.com> wrote in message
>> news:envO8wiOFHA.2520@tk2msftngp13.phx.gbl...
>> > Yes it is possible. Look at SqlXml and UpdateGrams.
>> >
>> > - Sahil Malik [MVP]
>> > http://codebetter.com/blogs/sahil.malik/
>> >
>> >
>> >
>> > "Johny" <Johny@discussions.microsoft.com> wrote in message
>> > news:57778A1A-444A-48F3-B1CB-B58B0254CE75@microsoft.com...
>> >> 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 :P
>> >>
>> >> 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
>> >
>> >
>>
>>
>>