google-datatable

How to create the Google DataTable JSON expected source using C#?

How can I create the JSON source expected by the google.visualization.datatable using C#? Obviously using the JavaScriptSerializer is out of the question since the expected JSON has a weird structure as described on the documentation: var dt = new google.visualization.DataTable( { cols: [{id: 'task', label: 'Task', type: 'st...

Google SQL Pivot make 0 show NULL

I have a pivot table that I need to have return NULL whenever there is not a value in the database. This seems pretty simple when you look at the Google API for their query language: http://code.google.com/apis/visualization/documentation/querylanguage.html#Pivot The Google example is the first image. Notice how it contains null, th...