Execute Multidimensional Query in .NET

The extended ADO.NET to execute Multidimensional Queries is ADOMD.NET.

ADOMD.NET is a standard .NET data provider that is designed to communicate with multidimensional data sources, such as Microsoft® SQL Server™ 2000 Analysis Services.

ADOMD.NET uses XML for Analysis version 1.1 to communicate with multidimensional data sources, using either TCP/IP or HTTP streams to transmit and receive SOAP requests and responses that are compliant with the XML for Analysis specification.


Multidimensional data can be retrieved and manipulated by using the ADOMD.NET object model. Using ADOMD.NET, you also can view and manipulate meta data either by retrieving OLE DB-compliant schema rowsets or by using the ADOMD.NET object model.

Difference between Response.Write() and Response.Output.Write() in ASP.NET.

--------- Thanks to Mr. Christian ----------

Response.Output.Write() gives you String.Format-style output and the Response.Write() doesn't.

In ASP.NET the Response object is of type HttpResponse and when you say Response.Write you're really saying (basically) HttpContext.Current.Response.Write and calling one of the many overloaded Write methods of HttpResponse.

Response.Write then calls .Write() on it's internal TextWriter object:

public void Write(object obj)
{
this._writer.Write(obj);
}

HttpResponse also has a Property called Output that is of type, yes, TextWriter, so:

public TextWriter get_Output()
{
return this._writer;
}

Which means you can to the Response whatever a TextWriter will let you. Now, TextWriters support a Write() method String.Format,

so you can do this:

Response.Output.Write("Scott is {0} at {1:d}", "cool",DateTime.Now);

But internally, of course, this this is happening:

public virtual void Write(string format, params object[] arg)
{
this.Write(string.Format(format, arg));
}



I. Jesuraj
http://www.thamizhkkalam.blogspot.com
email : i.jesuraj@yahoo.co.in