result display | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

result display

Hi, Can anybody help? I’m using OLEDB (and MDX) with VB.Net and
SQL Sever 2005 and I’m having difficulty finding a
good way of displaying the resulting cellset on the form. The office
pivottable component looks good in theory but I can’t get it to
display the data. If anyone could give me some hints, or even better
code, to get this to work then that would be great.
Alternatively any other methods/techniques for displaying this (or an
alternative format of the data) it would also be a great help.
Many thanks in advance.
Gav

Not able to display the data resulting cellset means are you getting any error or unable to get the proper result? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
I haven’t any error, but I don’t know the way for display cube result.
Sorry, excuse me for my english, because I’m italian.
By the way….. I see the excel pivot table, I created right a table, and now I try to insert it in my vb.net project. Do you have any suggestion?? Alternatively any other methods/techniques for displaying this it would also be a great help.
Thanks a lot
Eleonora
Hi,
Try firing your MDX query in SQL Management studio to
validate whether MDX actually returns data or not. Then in vb.net using ADOMD object you can execute MDX on cube
and can retrive the result either in XML format or in cellset format.
You can google on using ADOMD.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |