Selecting Specific Data with the JSON Selector Generator

The JSON Selector Generator at work!

Last post of the year, I promise! Something I forgot to mention in yesterday’s post: I found a great tool for finding the correct JSON selector! The JSON Selector Generator allows you to put in a JSON string, and it parses it such that you can then select which block or item you wish to … Read more

Converting a SQL Table to JavaScript Objects Using the ASP.NET MVC Web API

ASP.NET MVC Web API logo

Happy Independence Day! Here I will describe an alternative to an earlier post that described using a SQL stored procedure to convert a SQL table into a JavaScript object. One of the comments left on that post made me wonder why someone would not want to use the stored procedure method. After querying a large … Read more

Converting a SQL Server Table into a JavaScript Object Using a Stored Procedure

JSON logo

A couple of weeks ago, I attended Houston’s first Open Innovation Hackathon and joined the team that had the goal of redeveloping the City of Houston City-Wide Fee Schedule. The current fee schedule is an ASP.NET Web application with a SQL Server back end. At the end of the hackathon, my team had put together … Read more