Pie Chart and XML File call | Infragistics Forums

110

Pie Chart and XML File call

David posted over 16 years ago

I'm calling an XML file and using a pie chart. Only have 2 columns of data.

Getting the error. Pie Chart Error: PieChart.ColumnIndex must be a numeric column (or -1 for auto-search)

I've tried setting this property and keep getting same error.

I'm using DataSource and Databind.

Me.chartLPS.DataSource = ds.Tables(0).DefaultView

Me.chartLPS.DataBind()

When I bind this same DS to a GridView, the data displays in the grid perfect. Any help would be greatly appreciated.

Parents

28496

Offline David Negley posted over 16 years ago

at least one of the columns needs to be Typed as numeric so the chart knows it is usable for numeric data. try setting the DataType property of the Columns in that DataTable.
Cancel
Reply

Cancel

Reply

110

David posted over 16 years ago in reply to David Negley

That worked great!! Here is my very sloppy code however. I'm sure there is a better way but this works.

Dim strURL As String
Dim xml_doc As XmlDocument
xml_doc = New XmlDocument

strURL = "c:\test.xml"

Dim ds As New DataSet
ds.ReadXml(strURL)

Dim dt As DataTable
dt = New DataTable
With dt.Columns
.Add(New DataColumn("name", GetType(String)))
.Add(New DataColumn("complete", GetType(Int32)))
End With

For x As Integer = 1 To (ds.Tables(0).Rows.Count - 1)
dt.Rows.Add(ds.Tables(0).Rows(x).Item("name"), ds.Tables(0).Rows(x).Item("complete"))

Next

Me.chartLPS.DataSource = dt
Me.chartLPS.DataBind()
Cancel
Reply

Cancel

Children

No Data