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=statlogs;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()