#title JSON에서 데이터 추출하기

{{{
/*
 * Created by SharpDevelop.
 * User: dwa2007
 * Date: 2012-12-21
 * Time: 오후 4:04
 * 
 * To change this template use Tools | Options | Coding | Edit Standard Headers.
 */
using System;
using Newtonsoft.Json.Linq;

namespace json
{
	class Program
	{
		public static void Main(string[] args)
		{
			string json = @"{
			   ""이름"": ""테스트"",
			   ""나이"": 25,
			   ""성별"": ""여"",
			   ""기혼"": true,
			   ""주소"": ""서울특별시 양천구 목동"",
			   ""특기"": [""농구"", ""도술""],
			   ""가족관계"": {""#"": 2, ""아버지"": ""홍판서"", ""어머니"": ""춘섬""},
			   ""회사"": ""경기 안양시 만안구 안양7동""
			}";
			
			//Newtonsoft.Json.
			JObject obj = JObject.Parse(json);
			
			string name = (string)obj["이름"];
			int age = (int)obj["나이"];
			string gender = (string)obj["성별"];		

			//Type
			Console.WriteLine(obj["특기"].Type);	
			Console.WriteLine(obj["가족관계"].Type);	
			
			//Array
			JArray specialty = (JArray)obj["특기"];
			string specialty1 = (string)specialty[0];
			string specialty2 = (string)specialty[1];
			
			//Object
			JObject obj_family = JObject.Parse(obj["가족관계"].ToString());
			int family_cnt = (int)obj_family["#"];
			
			
			Console.WriteLine("이름= {0}, 나이={1}, 성별={2}, 특기={3}, 가족수={4}", name, age, gender, specialty1, family_cnt);
			
			// TODO: Implement Functionality Here
			
			Console.Write("Press any key to continue . . . ");
			Console.ReadKey(true);
		}
	}
}
}}}


{{{
참조추가 
- Microsoft.CSharp
- Microsoft.Web.Extensions

using System.Web.Script.Serialization; //추가
using Microsoft.CSharp; //추가

try
{
    var jss = new JavaScriptSerializer();
    var data = jss.Deserialize<dynamic>(Row.json);

    Row.key_tinyint = Convert.ToByte(data["키1"]);
    Row.key_smallint = Convert.ToInt16(data["키2"]);
    Row.key_int = Convert.ToInt32(data["키3"]);
    Row.key_bigint = Convert.ToInt64(data["키4"]);
    Row.key_datetime = Convert.ToDateTime(data["키5"]);
    Row.key_varchar = Convert.ToString(data["키6"]);
    Row.key_bit = Convert.ToBoolean(data["키7"]);
    Row.erroryn = false;
}
catch
{
    Row.erroryn = true;
}
}}}
----
ㅉㅉ -- 김용석 2016-12-03 15:31:32