Instead of using JSON to create a pie chart in Dataviz, it would be so much easier to use an SQLDataSource, So that the pie chart can be dynamically updated.
you can use the SQLDataSource with our ASP.NET server wrappers, but we won't be adding support for this source to the client-based DataSource