how to databind pivot table

M

masum

i have a problem, maybe i dont know :)
i am using sql & net 2005 and i try to make a web page (in vb.net).i used to
pivot table in my windows application normally (no problem), but in web
application i have not yet used to properly.

my some code is here;

----------------------------------
Dim strConnectionString As String
Dim advwrksConnection As New ADODB.Connection
System.Diagnostics.Debug.WriteLine(advwrksConnection.ConnectionString)
Dim Cmd As New String("MDX Query")
Dim cset As New ADOMD.Cellset
Dim cubes As ADOMD.CubeDefs
Dim cube As ADOMD.CubeDef
Dim dtcatalog As New ADOMD.Catalog()
Dim i, k As New Integer
Try
strConnectionString = "Provider=MSOLAP.3;Persist Security
Info=True;Data Source=http://*****/olap/msmdpump.dll; Catalog=*****;"
advwrksConnection.ConnectionString = strConnectionString
advwrksConnection.Open()

Catch ex As Exception
advwrksConnection = Nothing
Throw ex
Finally

dtcatalog.ActiveConnection = advwrksConnection
cubes = dtcatalog.CubeDefs
For Each cube In cubes
TextBox1.Text = (cube.Name)
Next
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top