public XmlReader GetXml(string strSql)
{
if ( objconn.State == ConnectionState.Closed )
{
objconn.Open();
} SqlCommand objcmd=new SqlCommand(strSql,objconn); try
{
myXml=objcmd.ExecuteXmlReader();
}
catch(Exception er)
{
throw new Exception(er.Message);
}
return myXml;
}
=============================================================================
XmlReader myxml=SqlConn.GetXml("select * from Ttype for xml auto");while(myxml.Read())
{
Response.Write(myxml.Value[0]);
}
================================================================================
请教高手,为什么我得不到下面的值呢?<Ttype typeid="1" typename="计算机类 "/><Ttype typeid="2" typename="数学类 "/>
{
if ( objconn.State == ConnectionState.Closed )
{
objconn.Open();
} SqlCommand objcmd=new SqlCommand(strSql,objconn); try
{
myXml=objcmd.ExecuteXmlReader();
}
catch(Exception er)
{
throw new Exception(er.Message);
}
return myXml;
}
=============================================================================
XmlReader myxml=SqlConn.GetXml("select * from Ttype for xml auto");while(myxml.Read())
{
Response.Write(myxml.Value[0]);
}
================================================================================
请教高手,为什么我得不到下面的值呢?<Ttype typeid="1" typename="计算机类 "/><Ttype typeid="2" typename="数学类 "/>
你是女的吧。
你可以测试每一步,比如测试得到的XmlReader值是不是null来判断哪里出的问题。
objcmd.CommandText = "select typeid,typename from Ttype FOR XML AUTO";XmlReader myXml = objcmd.ExecuteXmlReader();xmldr.Read()
xmldr.MoveToElement()
xmldr.MoveToAttribute(0);
string typeid = xmldr.Value;
xmldr.MoveToAttribute(1);
string typename = xmldr.Value;
可能是下面这里有问题,你自己看看吧
XmlReader myxml=SqlConn.GetXml("select * from Ttype for xml auto");while(myxml.Read())
{
Response.Write(myxml.Value[0]);
}