Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
binding pivotchart with sql server in vb.net
hi !
i have written the following code to programmatically bind the pivot chart with sql server but till now i m not getting any success. i am pasting my code below.plz help me .thanks. Dim oconnection As SqlClient.SqlConnection = New SqlClient.SqlConnection("Server=awais;Database=sta tlogs;integrated security=true") oconnection.Open() Dim oselectcommand As New SqlClient.SqlCommand("select date from designfile", oconnection) Dim odataAdapter As New SqlClient.SqlDataAdapter(oselectcommand) ptable.ConnectionString = "Server=awais;Database=statlogs;integrated security=true" Dim odataset As New DataSet("ptable") odataAdapter.Fill(odataset, "abc") ptable.DataMember = "196$" cspace.DataSource = ptable oconnection.Close() |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicating PivotChart / Changing PivotChart data range | Charts and Charting in Excel | |||
Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
problem updating link from Novell server to windows server #REF er | Excel Discussion (Misc queries) | |||
Late Binding examples of binding excel application | Excel Programming | |||
EARLY binding or LATE binding ? | Excel Programming |