Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Data XML Analysis > How to transfer...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 562 of 568
Post > Topic >>

How to transfer the result to a dataset type

by Gavin <yuzhigang84@[EMAIL PROTECTED] > Dec 21, 2007 at 01:48 AM

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 re****t 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?
 




 1 Posts in Topic:
How to transfer the result to a dataset type
Gavin <yuzhigang84@[EM  2007-12-21 01:48:55 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 9:00:57 CST 2008.