XML EXPLICIT

[Guest]

Hello,

I have a stored proc that takes two input params and returns xml using the "FOR XML EXPLICIT". I am at a loss how I can read this proc in .Net . I don't want to bind it or use a data grid etc, as its all on the server side. Does anyone know how to read a proc that returns XML ?

Regards

Danny

 

[Alok]

Try the ExecuteXMLReader() of the SQLCommand object.

HTH

Hello,

I have a stored proc that takes two input params and returns xml using the

"FOR XML EXPLICIT". I am at a loss how I can read this proc in .Net . I
don't want to bind it or use a data grid etc, as its all on the server side.
Does anyone know how to read a proc that returns XML ?

 

[Val Mazur]

Hi Danny,

Check next example

http://support.microsoft.com/default.aspx?scid=kb;en-us;316016&Product=adonet