获取mssql的xml返回结构的方法

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

数据库在时回加for xml auto

调用方法
SqlCommand SqlComm= new SqlCommand("Psp_ShowMarkerProduct",Db.SqlConn);
xmlReader Xr= SqlComm.ExecutexmlReader();
xmlDocument xmlDoc=new xmlDocument();
xmlDoc.Load(Xr);
xml1.Document=xmlDoc;
SqlComm.Dispose();

一定要生成xmldoc对象 否则系统提示错误！呵呵 这个该死的错误 困惑了我好久

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

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>