这个json怎么读取

Question

本帖最后由 gzw13999 于 2012-08-18 19:31:52 编辑

Answer 1

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web.Script.Serialization;namespace ConsoleApplication1
{
    class Program
    {
        class A
        {
            public List<List<string>> s { get; set; }
            public B c { get; set; }
        }
        class B
        {
            public List<List<string>> 北京 { get; set; }
        }
        static void Main(string[] args)
        {
            string jsondata = @"{'s':[['——','0'],['安徽','34'],['澳门','82'],['北京','11'],['福建','35'],['甘肃','62'],['广东','44'],['广西','45'],['贵州','52'],['海南','46'],['河北','13'],['河南','41'],['黑龙江','23'],['湖北','42'],['湖南','43'],['吉林','22'],['江苏','32'],['江西','36'],['辽宁','21'],['内蒙古','15'],['宁夏','64'],['青海','63'],['山东','37'],['山西','14'],['陕西','61'],['上海','31'],['四川','51'],['台湾','71'],['天津','12'],['西藏','54'],['香港','81'],['新疆','65'],['云南','53'],['浙江','33'],['重庆','50']],'c':{'——':[['——','0']],'安徽':[['——','0'],['安庆','8'],['蚌埠','3'],['亳州','16'],['巢湖','14'],['池州','17'],['滁州','11'],['阜阳','12'],['合肥','1'],['淮北','6'],['淮南','4'],['黄山','10'],['六安','15'],['马鞍山','5'],['宿州','13'],['铜陵','7'],['芜湖','2'],['宣城','18']],'澳门':[['——','0'],['花地玛堂区','OLF'],['圣安多尼堂区','ANT'],['大堂区','CAT'],['望德堂区','LAW'],['风顺堂区','LAZ'],['氹仔','TPA'],['路环','CLN']],'北京':[['——','0'],['昌平','21'],['朝阳','5'],['崇文','3'],['大兴','24'],['东城','1'],['房山','11'],['丰台','6'],['海淀','8'],['怀柔','27'],['门头沟','9'],['密云','28'],['平谷','26'],['石景山','7'],['顺义','13'],['通州','12'],['西城','2'],['宣武','4'],['延庆','29']],'福建':[['——','0'],['福州','1'],['龙岩','8'],['南平','7'],['宁德','9'],['莆田','3'],['泉州','5'],['三明','4'],['厦门','2'],['漳州','6']],'甘肃':[['——','0'],['白银','4'],['定西','11'],['甘南','30'],['嘉峪关','2'],['金昌','3'],['酒泉','9'],['兰州','1'],['临夏','29'],['陇南','12'],['平凉','8'],['庆阳','10'],['天水','5'],['武威','6'],['张掖','7']],'广东':[['——','0'],['潮州','51'],['东莞','19'],['佛山','6'],['广州','1'],['河源','16'],['惠州','13'],['江门','7'],['揭阳','52'],['茂名','9'],['梅州','14'],['清远','18'],['汕头','5'],['汕尾','15'],['韶关','2'],['深圳','3'],['阳江','17'],['云浮','53'],['湛江','8'],['肇庆','12'],['中山','20'],['珠海','4']],'广西':[['——','0'],['百色','10'],['北海','5'],['崇左','14'],['防城港','6'],['贵港','8'],['桂林','3'],['河池','12'],['贺州','11'],['来宾','13'],['柳州','2'],['南宁','1'],['钦州','7'],['梧州','4'],['玉林','9']],'贵州':[['——','0'],['安顺','4'],['毕节','24'],['贵阳','1'],['六盘水','2'],['黔东南','26'],['黔南','27'],['黔西南','23'],['铜仁','22'],['遵义','3']],'海南':[['——','0'],['白沙','A30'],['保亭','A35'],['昌江','A31'],['澄迈','A27'],['儋州','93'],['定安','A25'],['东方','97'],['海口','1'],['乐东','A33'],['临高','A28'],['陵水','A34'],['南沙','A38'],['琼海','92'],['琼中','A36'],['三亚','2'],['屯昌','A26'],['万宁','96'],['文昌','95'],['五指山','91'],['西沙','A37'],['中沙','A39']],'河北':[['——','0'],['保定','6'],['沧州','9'],['承德','8'],['邯郸','4'],['衡水','11'],['廊坊','10'],['秦皇岛','3'],['石家庄','1'],['唐山','2'],['邢台','5'],['张家口','7']],'河南':[['——','0'],['安阳','5'],['鹤壁','6'],['济源','18'],['焦作','8'],['开封','2'],['洛阳','3'],['漯河','11'],['南阳','13'],['平顶山','4'],['濮阳','9'],['三门峡','12'],['商丘','14'],['新乡','7'],['信阳','15'],['许昌','10'],['郑州','1'],['周口','16'],['驻马店','17']],'黑龙江':[['——','0'],['大庆','6'],['大兴安岭','27'],['哈尔滨','1'],['鹤岗','4'],['黑河','11'],['鸡西','3'],['佳木斯','8'],['牡丹江','10'],['七台河','9'],['齐齐哈尔','2'],['双鸭山','5'],['绥化','12'],['伊春','7']],'湖北':[['——','0'],['鄂州','7'],['恩施','28'],['黄冈','11'],['黄石','2'],['荆门','8'],['荆州','10'],['潜江','95'],['神农架','A21'],['十堰','3'],['随州','13'],['天门','96'],['武汉','1'],['仙桃','94'],['咸宁','12'],['襄樊','6'],['孝感','9'],['宜昌','5']],'湖南':[['——','0'],['长沙','1'],['常德','7'],['郴州','10'],['衡阳','4'],['怀化','12'],['娄底','13'],['邵阳','5'],['湘潭','3'],['湘西','31'],['益阳','9'],['永州','11'],['岳阳','6'],['张家界','8'],['株洲','2']],'吉林':[['——','0'],['白城','8'],['白山','6'],['长春','1'],['吉林','2'],['辽源','4'],['四平','3'],['松原','7'],['通化','5'],['延边','24']],'江苏':[['——','0'],['常州','4'],['淮安','8'],['连云港','7'],['南京','1'],['南通','6'],['苏州','5'],['宿迁','13'],['泰州','12'],['无锡','2'],['徐州','3'],['盐城','9'],['扬州','10'],['镇江','11']],'江西':[['——','0'],['抚州','10'],['赣州','7'],['吉安','8'],['景德镇','2'],['九江','4'],['南昌','1'],['萍乡','3'],['上饶','11'],['新余','5'],['宜春','9'],['鹰潭','6']],'辽宁':[['——','0'],['鞍山','3'],['本溪','5'],['朝阳','13'],['大连','2'],['丹东','6'],['抚顺','4'],['阜新','9'],['葫芦岛','14'],['锦州','7'],['辽阳','10'],['盘锦','11'],['沈阳','1'],['铁岭','12'],['营口','8']],'内蒙古':[['——','0'],['阿拉善','29'],['巴彦淖尔','8'],['包头','2'],['赤峰','4'],['鄂尔多斯','6'],['呼和浩特','1'],['呼伦贝尔','7'],['通辽','5'],['乌海','3'],['乌兰察布','9'],['锡林郭勒','25'],['兴安','22']],'宁夏':[['——','0'],['固原','4'],['石嘴山','2'],['吴忠','3'],['银川','1'],['中卫','5']],'青海':[['——','0'],['果洛','26'],['海北','22'],['海东','21'],['海南','25'],['海西','28'],['黄南','23'],['西宁','1'],['玉树','27']],'山东':[['——','0'],['滨州','16'],['德州','14'],['东营','5'],['菏泽','17'],['济南','1'],['济宁','8'],['莱芜','12'],['聊城','15'],['临沂','13'],['青岛','2'],['日照','11'],['泰安','9'],['威海','10'],['潍坊','7'],['烟台','6'],['枣庄','4'],['淄博','3']],'山西':[['——','0'],['长治','4'],['大同','2'],['晋城','5'],['晋中','7'],['临汾','10'],['吕梁','11'],['朔州','6'],['太原','1'],['忻州','9'],['阳泉','3'],['运城','8']],'陕西':[['——','0'],['安康','9'],['宝鸡','3'],['汉中','7'],['商洛','10'],['铜川','2'],['渭南','5'],['西安','1'],['咸阳','4'],['延安','6'],['榆林','8']],'上海':[['——','0'],['宝山','13'],['长宁','5'],['崇明','30'],['奉贤','26'],['虹口','9'],['黄浦','1'],['嘉定','14'],['金山','16'],['静安','6'],['卢湾','3'],['闵行','12'],['南汇','25'],['浦东新','15'],['普陀','7'],['青浦','29'],['松江','17'],['徐汇','4'],['杨浦','11'],['闸北','8']],'四川':[['——','0'],['阿坝','32'],['巴中','19'],['成都','1'],['达州','17'],['德阳','6'],['甘孜','33'],['广安','16'],['广元','8'],['乐山','11'],['凉山','34'],['泸州','5'],['眉山','14'],['绵阳','7'],['内江','10'],['南充','13'],['攀枝花','4'],['遂宁','9'],['雅安','18'],['宜宾','15'],['资阳','20'],['自贡','3']],'台湾':[['——','0'],['高雄市','2'],['高雄县','19'],['花莲县','23'],['基隆市','3'],['嘉义市','7'],['嘉义县','17'],['苗栗县','12'],['南投县','15'],['澎湖县','21'],['屏东县','20'],['台北市','1'],['台北县','8'],['台东县','22'],['台南市','5'],['台南县','18'],['台中市','4'],['台中县','13'],['桃园县','10'],['新竹市','6'],['新竹县','11'],['宜兰县','9'],['云林县','16'],['彰化县','14']],'天津':[['——','0'],['宝坻','24'],['北辰','13'],['大港','9'],['东丽','10'],['汉沽','8'],['和平','1'],['河北','5'],['河东','2'],['河西','3'],['红桥','6'],['蓟县','25'],['津南','12'],['静海','23'],['南开','4'],['宁河','21'],['塘沽','7'],['武清','22'],['西青','11']],'西藏':[['——','0'],['阿里','25'],['昌都','21'],['拉萨','1'],['林芝','26'],['那曲','24'],['日喀则','23'],['山南','22']],'香港':[['——','0'],['中西区','HCW'],['东区','HEA'],['九龙城区','KKC'],['观塘区','KKT'],['南区','HSO'],['深水埗区','KSS'],['黄大仙区','KWT'],['湾仔区','HWC'],['油尖旺区','KYT'],['离岛区','NIS'],['葵青区','NKT'],['北区','NNO'],['西贡区','NSK'],['沙田区','NST'],['屯门区','NTM'],['大埔区','NTP'],['荃湾区','NTW'],['元朗区','NYL']],'新疆':[['——','0'],['阿克苏','29'],['阿拉尔','92'],['阿勒泰','43'],['巴音郭楞','28'],['博尔塔拉','27'],['昌吉','23'],['哈密','22'],['和田','32'],['喀什','31'],['克拉玛依','2'],['克孜勒苏','30'],['石河子','91'],['塔城','42'],['图木舒克','93'],['吐鲁番','21'],['乌鲁木齐','1'],['五家渠','94'],['伊犁','40']],'云南':[['——','0'],['保山','5'],['楚雄','23'],['大理','29'],['德宏','31'],['迪庆','34'],['红河','25'],['昆明','1'],['丽江','7'],['临沧','9'],['怒江','33'],['普洱','8'],['曲靖','3'],['文山','26'],['西双版纳','28'],['玉溪','4'],['昭通','6']],'浙江':[['——','0'],['杭州','1'],['湖州','5'],['嘉兴','4'],['金华','7'],['丽水','11'],['宁波','2'],['衢州','8'],['绍兴','6'],['台州','10'],['温州','3'],['舟山','9']],'重庆':[['——','0'],['巴南','13'],['北碚','9'],['璧山','27'],['长寿','21'],['城口','29'],['大渡口','4'],['大足','25'],['垫江','31'],['丰都','30'],['奉节','36'],['涪陵','2'],['合川','82'],['江北','5'],['江津','81'],['九龙坡','7'],['开县','34'],['梁平','28'],['南岸','8'],['南川','84'],['彭水','43'],['綦江','22'],['黔江','39'],['荣昌','26'],['沙坪坝','6'],['石柱','40'],['双桥','11'],['铜梁','24'],['潼南','23'],['万盛','10'],['万州','1'],['巫山','37'],['巫溪','38'],['武隆','32'],['秀山','41'],['永川','83'],['酉阳','42'],['渝北','12'],['渝中','3'],['云阳','35'],['忠县','33']]}}";
            var result = new JavaScriptSerializer().Deserialize<A>(jsondata);
            var bjid = result.s.Where(x => x[0] == "北京").First()[1];
            Console.WriteLine(bjid);
            var bj = result.c.北京;
            Console.WriteLine(string.Join(",", bj.Select(x => x[0]).ToArray()));
        }
    }
}引用System.Web和System.Web.Extensions

Answer 2

.net 3.5啊。   
项目必须用.net 2.0  所以我才选用了 Newtonsoft.Json

Answer 3

用Newtonsoft.Json 还是不会。 不过非常感谢 caozhy耐心指点。

Answer 4

大致是：public class X
{
    public string[,] s;     //或者是 string[],[] s？你自己测试一下
}
然后进行反序列化：var obj= JsonConvert.DeserializeObject<X>(input);

Answer 5

你的数据读起来忒麻烦。请你先自己写class定义出来，把你的这个文字说明变成class。再来问。

Answer 6

我用正则读取反而感觉还挺方便。
十分感谢 caozhy  和 sp1234  。