http://stackoverflow.com/questions/34002355/loop-through-json-results-using-json-net

CSharp · Console

/Program.cs

using System;
using Newtonsoft.Json.Linq;
					
public class Program
{
	public static void Main()
	{
		string json = @"
            {
	            ""SUCCESS"": 1,
	            ""ERRMSG"": """",
	            ""COLUMNSANDDATA"": {
		            ""COLUMNS"": [""LASTNAME"", ""FIRSTNAME"", ""EMAILADDRESS"", ""COURSENAME"", ""PROGRAMID"", ""ENROLLMENTSTARTDATE"", ""COMPLETIONDATE"", ""GRADE"", ""SCORE"", ""PASSED_NOTPASSED"", ""TYPEOFCREDITS"", ""CREDITSEARNED"", ""INSTRUCTORNAME"", ""INSTRUCTOREMAILADDRESS"", ""CLIENTNAME"", ""COMMUNITYNAME"", ""CERTIFICATESENTDATE"", ""DURATIONTYPE"", ""DURATIONMINUTES"", ""LOGIN""],
		            ""DATA"": [
			            [""Beane"", ""Coffee"", ""[email protected]"", ""Program with One Essay Test"", null, ""January, 06 2014 18:06:56"", ""January, 06 2014 18:57:53"", ""Incomplete"", null, ""Not Passed"", ""Musical Note"", 0.00, ""Ray Bradbury"", ""[email protected]"", ""Hogarth's Flying Circus"", ""Captain's Club"", null, null, null, ""[email protected]""],
			            [""Beane"", ""Navy"", ""[email protected]"", ""Program with One Essay Test"", null, ""January, 06 2014 18:06:56"", ""January, 06 2014 18:36:39"", ""Pass"", 95.00, ""Passed"", ""Musical Note"", 1.00, ""Ray Bradbury"", ""[email protected]"", ""Hogarth's Flying Circus"", ""Captain's Club"", ""January, 06 2014 08:00:00"", null, null, ""NavyB""]
		            ]
	            }
            }";
		
		JObject root = JObject.Parse(json);
		JObject colsAndData = (JObject)root["COLUMNSANDDATA"];
		JArray cols = (JArray)colsAndData["COLUMNS"];
		foreach (JArray row in colsAndData["DATA"])
		{
			for (int i = 0; i < row.Count; i++)
			{
				string colName = (string)cols[i];
				string value = (string)row[i];
				Console.WriteLine(colName + ": " + value);
			}
			Console.WriteLine();
		}
	}
}