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}")