Methods for obtaining the XML return structure of MSSQL

the database is added for XML auto at time

Call method
SqlCommand sqlcomm= New SqlCommand ("Psp_showmarkerproduct", db.sqlconn);
XmlReader xr= Sqlcomm.executexmlreader ();
XmlDocument xmldoc=new XmlDocument ();
Xmldoc.load (XR);
Xml1.document=xmldoc;
Sqlcomm.dispose ();

be sure to generate the XmlDoc object otherwise the system prompts for errors! Oh, this damned mistake has puzzled me for a long time.

XSL file


...