XmlReader returns {none}

EDN Admin · Dec 12, 2007

When I use this code it returns the XmlReader as {none}:
 
public static XmlReader _getTemplate(int id)
{
object o = null;
XmlReader reader = null;
System.IO.MemoryStream msXml = null;
XmlReaderSettings settings = null;
StringReader s = null;
SqlXml sql = null;
XmlTextReader oXmlTextReader = null;
SqlDataReader dr = null;
SqlConnection sqlCnn = genSpHandler.sqlCnn_(ConnectionString);
SqlCommand sqlCmd = new SqlCommand("_getTemplate", sqlCnn);
sqlCmd.CommandType = CommandType.StoredProcedure;
try 
{
//add the value to set 
sqlCmd.Parameters.Add("@id", SqlDbType.Int);
sqlCmd.Parameters[0].Value = id;
if(sqlCnn.State != ConnectionState.Open)
sqlCnn.Open();
// reader = sqlCmd.ExecuteXmlReader(); 
o = sqlCmd.ExecuteScalar();
if(o != null)
{
oXmlTextReader = new XmlTextReader(o.ToString(),
XmlNodeType.Document, context);
//s = new StringReader(o.ToString()); 
//msXml = new System.IO.MemoryStream(System.Text.Encoding.Unicode.GetBytes(o.ToString())); 
//sql = new SqlXml(msXml); 
//reader = sql.CreateReader(); 
}
}
catch(Exception exc)
{
log.Error(exc);
}
finally 
{
if((dr != null) && (!dr.IsClosed)) dr.Close();
sqlCmd.Dispose();
sqlCnn.Close();
sqlCnn.Dispose();
}
return oXmlTextReader;
}

Here the XSL:
 
<?xml version=1.0 encoding=UTF-8?>
<xsl<img height=19 alt="Tongue Tied" src="http://forums.microsoft.com/MSDN/emoticons/emotion-7.gif" width=19>tylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns<img height=19 alt="Stick out tongue" src="http://forums.microsoft.com/MSDN/emoticons/emotion-4.gif" width=19>3="http://schemas.primavera.com/2006/API/5.0sp4/prmbo" version="1.0">
<xsl<img height=19 alt=Surprise src="http://forums.microsoft.com/MSDN/emoticons/emotion-3.gif" width=19>utput method="xml"/>
<xsl<img height=19 alt="Stick out tongue" src="http://forums.microsoft.com/MSDN/emoticons/emotion-4.gif" width=19>aram name =Id_SUBP>
<xsl:value-of select=p3:BusinessObjects/p3:ActivityCodeType[p3:Name="BANF: SUBP"]/p3<img height=19 alt=Surprise src="http://forums.microsoft.com/MSDN/emoticons/emotion-3.gif" width=19>bjectId/>

...


Why is this?

View the full article

XmlReader returns {none}

EDN Admin

Well-known member