or
@{ var dbRenewal = Database.Open("RenewalDataConnection"); var sql = "SELECT donorID, title, firstname, middlename, lastname, address, city, state ,zipcode, homephone, workphone, cellphone, email FROM donor"; var data = dbRenewal.Query(sql); var json = Json.Encode(data); Response.Write(json); }
[{"donorID":152,"title":"title","firstname":"firstname","middlename":"Middlename","lastname":"lastname","address":"100 Main Street","city":"Los Angeles","state":"CA","zipcode":"90067","homephone":"3105528809","workphone":"3105528809","cellphone":"3105528809","email":null},{"donorID":157,"title":"Rabbi","firstname":"Yehuda","middlename":"Lein","lastname":"Smith","address":"100 Main Street","city":"Los Angeles","state":"CA","zipcode":"91678","homephone":"3105528809","workphone":"3105528809","cellphone":"3105528809","email":null}]
columns.Bound(p => p.quantity).Format("{0:#,0}")
var daysOfWeekArray = new Array();daysOfWeekArray[0] = "Mon";daysOfWeekArray[1] = "Tue";daysOfWeekArray[2] = "Wed";daysOfWeekArray[3] = "Thu";daysOfWeekArray[4] = "Fri";daysOfWeekArray[5] = "Sat";daysOfWeekArray[6] = "Sun";var daysOfWeekJSON = [ { "DayOfWeek": "Mon" }, { "DayOfWeek": "Tues" }, { "DayOfWeek": "Wed" }, { "DayOfWeek": "Thur" }, { "DayOfWeek": "Fri" }, { "DayOfWeek": "Sat" }, { "DayOfWeek": "Sun" }];var customersByDayOfWeek = [ { "DayOfWeek": 1, "TableType_Id": "Bar ", "Seated": 285 }, { "DayOfWeek": 1, "TableType_Id": "Lounge ", "Seated": 39 }, { "DayOfWeek": 1, "TableType_Id": "Dining ", "Seated": 36 }, { "DayOfWeek": 2, "TableType_Id": "Bar ", "Seated": 195 }, { "DayOfWeek": 2, "TableType_Id": "Lounge ", "Seated": 32 }, { "DayOfWeek": 2, "TableType_Id": "Dining ", "Seated": 18 }, { "DayOfWeek": 3, "TableType_Id": "Bar ", "Seated": 193 }, { "DayOfWeek": 3, "TableType_Id": "Lounge ", "Seated": 28 }, { "DayOfWeek": 3, "TableType_Id": "Dining ", "Seated": 21 }, { "DayOfWeek": 4, "TableType_Id": "Bar ", "Seated": 199 }, { "DayOfWeek": 4, "TableType_Id": "Lounge ", "Seated": 30 }, { "DayOfWeek": 4, "TableType_Id": "Dining ", "Seated": 12 }, { "DayOfWeek": 5, "TableType_Id": "Bar ", "Seated": 195 }, { "DayOfWeek": 5, "TableType_Id": "Lounge ", "Seated": 29 }, { "DayOfWeek": 5, "TableType_Id": "Dining ", "Seated": 19 }, { "DayOfWeek": 6, "TableType_Id": "Bar ", "Seated": 195 }, { "DayOfWeek": 6, "TableType_Id": "Lounge ", "Seated": 23 }, { "DayOfWeek": 6, "TableType_Id": "Dining ", "Seated": 24 }, { "DayOfWeek": 7, "TableType_Id": "Bar ", "Seated": 191 }, { "DayOfWeek": 7, "TableType_Id": "Lounge ", "Seated": 30 }, { "DayOfWeek": 7, "TableType_Id": "Dining ", "Seated": 21 } ] $("#customersByDayOfWeek").kendoChart({ theme: $(document).data("kendoSkin") || "default", dataSource: { data: customersByDayOfWeek, //transport: { // read: { // url: reportsAPI, // dataType: "json" // } //}, group: { field: "TableType_Id" } }, title: { text: "Customers Per Month, By Table Type" }, legend: { position: "bottom" }, seriesDefaults: { type: "column", labels: { visible: true, format: "{0:n0}" } }, series: [{ field: "Seated", name: "", colorField: "userColor" }], valueAxis: { labels: { format: "{0}" } }, categoryAxis: { data: daysOfWeekJSON, field: "DayOfWeek" }});