Community Learn Tools Library Leisure
search
English
Home > Backend Development > XML/RSS Tutorial > Method to obtain the xml return structure of mssql

Method to obtain the xml return structure of mssql

黄舟
Release： 2017-03-02 17:09:27
Original
1688 people have browsed it

When the database is added for xml auto

Calling 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();
Copy after login

Be sure to generate an xmldoc object, otherwise the system will prompt an error! Haha This damn error has confused me for a long time

xsl file

<?xml version="1.0" encoding="GB2312" ?>
 <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
  ...
 </xsl:template>
</xsl:stylesheet>
Copy after login

The above is the content of the method of obtaining the xml return structure of mssql. For more related content, please pay attention to the PHP Chinese website ( www.php.cn)!


Related labels：
mssql，xml，结构
source：php.cn
Previous article：Teach you step by step how to create a Google Sitemap (detailed production tutorial and protocol explanation) Next article：Detailed explanation of simple reading and writing of XML
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Select woocommerce related products using custom taxonomy with 3 level hierarchy I have a woocommerce store with a custom classification of "Sports". The classif...
From 2024-04-06 20:05:30
0
1
544
How to group and count in MySQL? I'm trying to write a query that extracts the total number of undeleted messages sent to f...
From 2024-04-06 18:30:17
0
1
353
**Error type: Unable to iterate 'NoneType' object** I want to use ssh tunnel to access Mysql database. Unfortunately, the architecture of this...
From 2024-04-06 10:26:38
0
1
378
Export useState variable to another component/page I'm a bit stuck. I have put the user input results into an array that can be used on anoth...
From 2024-04-05 11:30:54
0
1
286
How to configure apache to load index.html and index.php? Here is my doubt, I have the following structure: root/index.html root/api/index.php I hav...
From 2024-04-05 09:27:53
0
1
3505
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template