C1 Community

Hi there,

 I've some serious issue here regarding the webchart. I've try to bind an sqldatasource with webchart using the chart wizard. But whenever i attempt to select the desire datasource under the binding tab. The chart wizard will immediately exit. I've try to reinstall the webchart but still the issue remains. By the way, i'm using visual studio 2005 with ComponentOne Studio Enterprise 2006 v1 for dotNet2.0. Hope someone can shed some light into this problem. TQ

Dim sql As String = "select * from products"

Dim conn As String = "provider=… nwind.mdb" '

Dim da As New OleDbDataAdapter(sql, conn)

da.Fill(dt)

' bind chart to table (each series will bind to a field on the table)_
   c1chart.DataSource = dt

' clear data series collection

Dim dsc As ChartDataSeriesCollection = c1chart.ChartGroups(0).ChartData.SeriesList

dsc.Clear()

' add unit price series

Dim ds As ChartDataSeries = dsc.AddNewSeries()

'ds.AutoEnumerate = true' (in case you don't want to set the X values)

ds.X.DataField = "ProductName"

ds.Y.DataField = "UnitPrice"

' add units in stock series

ds = dsc.AddNewSeries()

ds.X.DataField = "ProductName"

ds.Y.DataField = "UnitsInStock"

' apply filters, sorting, etc

dt.DefaultView.RowFilter = "CategoryID = 4"
 

<chongws2006> wrote in message news:205596@10.0.1.98...

Hi there,

 I've some serious issue here regarding the webchart. I've try to bind an sqldatasource with webchart using the chart wizard. But whenever i attempt to select the desire datasource under the binding tab. The chart wizard will immediately exit. I've try to reinstall the webchart but still the issue remains. By the way, i'm using visual studio 2005 with ComponentOne Studio Enterprise 2006 v1 for dotNet2.0. Hope someone can shed some light into this problem. TQ

---

http://helpcentral.componentone.com/cs/forums/p/75464/205596.aspx#205596