Very Computer

by **Martyn Braithwait** » Tue, 03 Jul 2001 23:02:32

Using the OLEDb datareader I am able to query an OLAP cube using an MDX
query (using ado.net with c#) without any errors.

I have then bound the results to a DataGrid on a HTML page.

By default only the data returned in the rows collection appears in the
DataGrid.

Does anybody know how to get the column collection data to appear?

I have also tried using a DataRepeater to display the data but cannot work
out what the syntax is to explicitly grab an item from the results.

I have put this post on the ado/asp.net newsgroups but anything to do with
OLAP etc seems to be ignored by the people using those newsgroups.

When I do this type of thing in ASP I use the cellset object and a couple of
nested for each loops to output.

by **Robert Dos** » Wed, 04 Jul 2001 21:21:47

Hy Martyn,
See the thread below "(Unable to retrieve children: Member with the
UniqueName Scenerio].[All
Scenerio] not found.)". There is a bug in MDAC 2.7 that ships with .Net.
We are waiting and hoping for a fix.
Bob Doss

Quote:> Using the OLEDb datareader I am able to query an OLAP cube using an MDX
> query (using ado.net with c#) without any errors.

> I have then bound the results to a DataGrid on a HTML page.

> By default only the data returned in the rows collection appears in the
> DataGrid.

> Does anybody know how to get the column collection data to appear?

> I have also tried using a DataRepeater to display the data but cannot work
> out what the syntax is to explicitly grab an item from the results.

> I have put this post on the ado/asp.net newsgroups but anything to do with
> OLAP etc seems to be ignored by the people using those newsgroups.

> When I do this type of thing in ASP I use the cellset object and a couple
of
> nested for each loops to output.

by **Martyn Braithwait** » Wed, 04 Jul 2001 21:57:12

Thanks for your help Bob

> Hy Martyn,
> See the thread below "(Unable to retrieve children: Member with the
> UniqueName Scenerio].[All
> Scenerio] not found.)". There is a bug in MDAC 2.7 that ships with .Net.
> We are waiting and hoping for a fix.
> Bob Doss

> > Using the OLEDb datareader I am able to query an OLAP cube using an MDX
> > query (using ado.net with c#) without any errors.

> > I have then bound the results to a DataGrid on a HTML page.

> > By default only the data returned in the rows collection appears in the
> > DataGrid.

> > Does anybody know how to get the column collection data to appear?

> > I have also tried using a DataRepeater to display the data but cannot
work
> > out what the syntax is to explicitly grab an item from the results.

> > I have put this post on the ado/asp.net newsgroups but anything to do
with
> > OLAP etc seems to be ignored by the people using those newsgroups.

> > When I do this type of thing in ASP I use the cellset object and a
couple
> of
> > nested for each loops to output.

Very Computer

.NET, OLEDb, MDX and the DataGrid

.NET, OLEDb, MDX and the DataGrid

.NET, OLEDb, MDX and the DataGrid

.NET, OLEDb, MDX and the DataGrid