Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
XML
data.xmlanalysis
mappoint.webservice
msf
msxml-webrelease
netmyservices.sdk
passport.sdk
soap
soapsdk
uddi.general
uddi.programming
uddi.specification
xml
xmlsqlwebrelease
xsl
  
 
date: Fri, 21 Dec 2007 01:48:55 -0800 (PST),    group: microsoft.public.data.xmlanalysis        back       


How to transfer the result to a dataset type   
HI,
   I use Adomd.net to visit the sql server 2005 analyst service.  i
want the get a serializable result.
   Code seems like:

    AdomdCommand cmd = new AdomdCommand();
  ....
  System.Xml.XmlReader xr = cmd.ExecuteXmlReader();
  DataSet ds = new DataSet();
  ds.ReadXml(xr);

   // string strXml = xr.ReadInnerXml();
  // MemoryStream ms = new
MemoryStream( Encoding.Default.GetBytes(strXml) );
 // ds.ReadXml( ms );


now, the ds doesn't contain any data.
if use the second mothod, it report me that "the xml contains many
root element". I checked the xml , it contains many root element, such
as "schema" , "OlapInfo","Axes",.

So Is there a way to get a DataSet or DataTable  when querying the
cube?
date: Fri, 21 Dec 2007 01:48:55 -0800 (PST)   author:   Gavin

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us