从SQL Server中获取XML

  private string GetFORXML(string sFile, string sSQL)
  {
   // Create and open the connection to Northwind
   DataSet oDs = new DataSet();
   using(SqlConnection oCn = new SqlConnection(ConnectionString))
   {
    oCn.Open();
   
    // Create the SQL command to execute
    SqlCommand oCmd = new SqlCommand(sSQL, oCn);

    System.Diagnostics.Debug.WriteLine(sSQL);
   
    // Execute the SQL statement and return the data to an XmlReader
    XmlReader oXml = oCmd.ExecuteXmlReader();

    // Read the Schema of the XML
    oDs.ReadXmlSchema(oXml);

    // Read the XML fragment (which needs a schema)
    oDs.ReadXml(oXml, XmlReadMode.Fragment);
   }
   oDs.DataSetName = "root";
   
   // Write the XML out to a file
   oDs.WriteXml(sPath + sFile);
   
   return "Wrote XML to file " + sFile;
  }

方法中的 sSQL 是含有 FOR XML 的SQL 语句