c#xml转json（c# json解析）

一、c#对xml格式数据的解析

1、用xmldocument来解析

?

1 2 3 4 5 6 7 8 9 10 11 12

xmldocument xmldocument = new xmldocument(); xmldocumentload("testxml"); //创建新节点 xmlelement nn = xmldocumentcreateelement("image"); nnsetattribute("imageurl", "jpg"); xmlnode node = xmldocumentselectsinglenode("content/section/page/gall/folder");//定位到folder节点 nodeappendchild(nn);//附加新节点 //保存 xmldocumentsave("testxml");

2、用linq to xml来解析

可以通过遍历，来获得你想要的节点的内容或属性

?

1 2 3 4 5 6

xelement root = xelementload("testxml"); foreach (xattribute att in rootattributes()) { rootadd(new xelement(attname, (string)att)); } consolewriteline(root);

3、附一个详细点的例子

比如要解析如下的xml文件，将其转化为ilist对象。

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

<?xml version="0" encoding="utf-8"?> <car> <carcost> <id>20130821133126</id> <uptime>60</uptime> <downtime>30</downtime> <price>4</price> </carcost> <carcost> <id>20130821014316</id> <uptime>120</uptime> <downtime>60</downtime> <price>3</price> </carcost> <carcost> <id>20130822043127</id> <uptime>30</uptime> <downtime>0</downtime> <price>5</price> </carcost> <carcost> <id>20130822043341</id> <uptime>120以上！</uptime> <downtime>120</downtime> <price>2</price> </carcost> </car>

在控制台应用程序中输入如下代码即可。

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

class program { static void main(string[] args) { ilist<carcost> resultlist = new list<carcost>(); xmldocument xmldocument = new xmldocument(); xmldocumentload("testxml"); xmlnodelist xmlnodelist = xmldocumentselectsinglenode("car")childnodes; foreach (xmlnode list in xmlnodelist) { carcost carcost = new carcost ( listselectsinglenode("id")innertext, listselectsinglenode("uptime")innertext, listselectsinglenode("downtime")innertext, floatparse(listselectsinglenode("price")innertext) ); resultlistadd(carcost); } ienumerator enumerator = resultlistgetenumerator(); while (enumeratormovenext()) { carcost carcost = enumeratorcurrent as carcost; consolewriteline(carcostid + " " + carcostuptime + " " + carcostdowntime + " " + carcostprice); } } } public class carcost { public carcost(string id, string uptime, string downtime, float price) { thisid = id; thisuptime = uptime; thisdowntime = downtime; thisprice = price; } public string id { get; set; } public string uptime { get; set; } public string downtime { get; set; } public float price { get; set; } }

二、c#对json格式数据的解析

引用newtonsoftjsondll文件，来解析。

比如：有个要解析的json字符串

?

1

[{"taskrolespaces":"","taskroles":"","proxyuserid":"5d9ad5dc1c5e494db1d1b4d8d79b60a7","userid":"5d9ad5dc1c5e494db1d1b4d8d79b60a7","username":"姓名","usersystemname":"2234","operationname":"送合同负责人","operationvalue":"同意","operationvaluetext":"","signdate":"2013-06-19 10:31:26","comment":"同意","formdatahashcode":"","signaturedivid":""},{"taskrolespaces":"","taskroles":"","proxyuserid":"2c96c3943826ea93013826eafe6d0089","userid":"2c96c3943826ea93013826eafe6d0089","username":"姓名2","usersystemname":"1234","operationname":"送合同负责人","operationvalue":"同意","operationvaluetext":"","signdate":"2013-06-20 09:37:11","comment":"同意","formdatahashcode":"","signaturedivid":""}]

首先定义个实体类：

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

public class jobinfo { public string taskrolespaces { get; set; } public string taskroles { get; set; } public string proxyuserid { get; set; } public string userid { get; set; } public string username { get; set; } public string usersystemname { get; set; } public string operationname { get; set; } public string operationvalue { get; set; } public string operationvaluetext { get; set; } public datetime signdate { get; set; } public string comment { get; set; } public string formdatahashcode { get; set; } public string signaturedivid { get; set; } }

然后在控制台main函数内部输入如下代码：

?

1 2 3 4 5 6 7 8 9

string json = @"[{'taskrolespaces':'','taskroles':'','proxyuserid':'5d9ad5dc1c5e494db1d1b4d8d79b60a7','userid':'5d9ad5dc1c5e494db1d1b4d8d79b60a7','username':'姓名','usersystemname':'2234','operationname':'送合同负责人','operationvalue':'同意','operationvaluetext':'','signdate':'2013-06-19 10:31:26','comment':'同意','formdatahashcode':'','signaturedivid':''},{'taskrolespaces':'','taskroles':'','proxyuserid':'2c96c3943826ea93013826eafe6d0089','userid':'2c96c3943826ea93013826eafe6d0089','username':'姓名2','usersystemname':'1234','operationname':'送合同负责人','operationvalue':'同意','operationvaluetext':'','signdate':'2013-06-20 09:37:11','comment':'同意','formdatahashcode':'','signaturedivid':''}] "; list<jobinfo> jobinfolist = jsonconvertdeserializeobject<list<jobinfo>>(json); foreach (jobinfo jobinfo in jobinfolist) { consolewriteline("username:" + jobinfousername + "userid:" + jobinfouserid); }

这样就可以正常输出内容了。

我想肯定有人会问，如果有多层关系的json字符串该如何处理呢？没关系，一样的处理。

比如如何解析这个json字符串：[{'phantom':true,'id':'20130717001','data':{'mid':1019,'name':'aaccccc','des':'cc','disable':'启用','remark':'cccc'}}] ？

首先还是定义实体类：

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

public class info { public string phantom { get; set; } public string id { get; set; } public data data { get; set; } } public class data { public int mid { get; set; } public string name { get; set; } public string des { get; set; } public string disable { get; set; } public string remark { get; set; } }

然后在main方法里面，键入：

?

1 2 3 4 5 6 7

string json = @"[{'phantom':true,'id':'20130717001','data':{'mid':1019,'name':'aaccccc','des':'cc','disable':'启用','remark':'cccc'}}]"; list<info> infolist = jsonconvertdeserializeobject<list<info>>(json); foreach (info info in infolist) { consolewriteline("id:" + infodatamid); }

按照我们的预期，应该能够得到1019的结果。

截图为证：

再附一个json解析的例子，来自于兔子家族—二哥在本篇博客下的回复。

json字符串1：{success:true,data:{id:100001,code:\"jtl-z38005\",name:\"奥迪三轮毂\",location:\"a-202\",qty:100,bins:[{code:\"jtl-z38001\",name:\"奥迪三轮毂\",location:\"a-001\",qty:100},{ code:\"jtl-z38002\",name:\"奥迪三轮毂\",location:\"a-002\",qty:100}]}}

定义数据结构：

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

public class data { public boolean success { get; set; } public data1 data { get; set; } } public class data1 { public int32 id { get; set; } public string code { get; set; } public string name { get; set; } public string location { get; set; } public int32 qty { get; set; } public list<data2> bins { get; set; } } public class data2 { public string code { get; set; } public string name { get; set; } public string location { get; set; } public int32 qty { get; set; } }

main函数：

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14

class program { static void main(string[] args) { string json = "{success:true,data:{id:100001,code:\"jtl-z38005\",name:\"奥迪三轮毂\",location:\"a-202\",qty:100,bins:[{code:\"jtl-z38001\",name:\"奥迪三轮毂\",location:\"a-001\",qty:100},{ code:\"jtl-z38002\",name:\"奥迪三轮毂\",location:\"a-002\",qty:100}]}}"; data data = jsonconvertdeserializeobject<data>(json); foreach (var item in datadatabins) { //输出：jtl-z38001、jtl-z38002，其它类似 consolewriteline(itemcode); } } }

json字符串2：

?

1	{\"success\":true,\"data\":{\"name\":\"张三\",\"moulds\":{\"stockimport\":true,\"stockexport\":true,\"justifylocation\":true,\"justifybin\":false,\"binrelease\":false}}}

在控制台应用程序下的完整代码：

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33

namespace consoleapplication1 { class program { static void main(string[] args) { string json = "{\"success\":true,\"data\":{\"name\":\"张三\",\"moulds\":{\"stockimport\":true,\"stockexport\":true,\"justifylocation\":true,\"justifybin\":false,\"binrelease\":false}}}"; data data = jsonconvertdeserializeobject<data>(json); consolewriteline(datadatamouldsbinrelease);//输出false } } public class data { public boolean success { get; set; } public data1 data { get; set; } } public class data1 { public string name { get; set; } public data2 moulds { get; set; } } public class data2 { public boolean stockimport { get; set; } public boolean stockexport { get; set; } public boolean justifylocation { get; set; } public boolean justifybin { get; set; } public boolean binrelease { get; set; } } }

json字符串3：

?

1 2 3 4 5 6 7 8 9 10 11 12

{ "success": true, "data": { "id": 100001, "bin": "jit-3js-2k", "targetbin": "jit-3js-3k", "batchs": [ "b20140101", "b20140102" ] } }

他的问题主要是不知道batchs这里怎么处理，其实很简单就是一个数组而已。

完整代码如下：

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34

namespace consoleapplication1 { class program { static void main(string[] args) { string json = "{\"success\": true,\"data\": {\"id\": 100001,\"bin\": \"jit-3js-2k\",\"targetbin\": \"jit-3js-3k\",\"batchs\": [\"b20140101\",\"b20140102\"]}}"; data data = jsonconvertdeserializeobject<data>(json); foreach (var item in datadatabatchs) { consolewriteline(item);//输出：b20140101、b20140102 } } } public class data { public boolean success { get; set; } public data1 data { get; set; } } public class data1 { public int32 id { get; set; } public string bin { get; set; } public string targetbin { get; set; } public string[] batchs { get; set; } } }

除了上述返回类的实体对象做法之外，jsonnet还提供了jobject类，可以取自己指定节点的内容。

比如：

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

namespace consoleapplication1 { class program { static void main(string[] args) { string j = "{success:true,data:{ bin:{code:\"jtl-z38001\",name:\"奥迪三轮毂\",location:\"a-001\",qty:100}}}"; jobject jo = (jobject)jsonconvertdeserializeobject(j); consolewriteline(jo); } } public class data { public boolean success { get; set; } public data1 data { get; set; } } public class data1 { public data2 bin { get; set; } } public class data2 { public string code { get; set; } public string name { get; set; } public string location { get; set; } public int32 qty { get; set; } } }

直接运行，返回结果如下：

如果输出内容修改为：

?

1	consolewriteline(jo["data"]);

继续取bin节点。

?

1	consolewriteline(jo["data"]["bin"]);

最后我们取其中name对应的value。

?

1	consolewriteline(jo["data"]["bin"]["name"]);

一步一步的获取了json字符串对应的value。

——————————————————————————————————————————————————

群里有人提出一个问题，比如我要生成如下的json字符串，该如何处理呢？

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32

{ "id": 1, "value": "cate", "child": [ { "id": 1, "value": "cate", "child": [ ] }, { "id": 1, "value": "cate", "child": [ { "id": 2, "value": "cate2", "child": [ { "id": 3, "value": "cate3", "child": [ ] } ] } ] } ] }

通过观察我们会发现，其实规律比较好找，就是包含id、value、child这样的属性，child又包含id、value、child这样的属性，可以无限循环下去，是个典型的树形结构。

完整的代码如下：

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47

namespace consoleapplication1 { class program { static void main(string[] args) { data data = new data(); dataid = 1; datavalue = "cate"; datachild = new list<data>() { new data(){ id=1,value="cate",child=new list<data>(){}} , new data(){ id=1,value="cate",child=new list<data>() { new data() { id=2, value="cate2" , child = new list<data>() { new data() { id = 3, value = "cate3", child = new list<data>(){}, } }, } }} , }; //序列化为json字符串 string json = jsonconvertserializeobject(data); consolewriteline(json); //反序列化为对象 data jsondata = jsonconvertdeserializeobject<data>(json); } } public class data { public int id { get; set; } public string value { get; set; } public list<data> child { get; set; } } }

我们验证一下生成的结果：

?

1 2	jobject jo = (jobject)jsonconvertdeserializeobject(json); consolewriteline(jo);

再来一个复杂点的json结构：

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46

[ { "downlist": [], "line": { "id": -1, "name": "admin", "iccard": "1" }, "uplist": [ { "endtime": "18:10", "starttime": "06:40", "sid": 385, "stype": "38" }, { "endtime": "18:10", "starttime": "06:40", "sid": 1036, "stype": "38" } ] }, { "downlist": [], "line": { "id": -1, "name": "admin", "iccard": "1" }, "uplist": [ { "endtime": "18:10", "starttime": "06:40", "sid": 385, "stype": "38" }, { "endtime": "18:10", "starttime": "06:40", "sid": 1036, "stype": "38" } ] } ]

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57

namespace consoleapplication1 { class program { static void main(string[] args) { string jsonstring = "[{\"downlist\": [],\"line\": {\"id\": -1,\"name\": \"admin\",\"iccard\": \"1\"},\"uplist\": [{\"endtime\": \"18:10\",\"starttime\": \"06:40\",\"sid\": 385,\"stype\": \"38\"},{\"endtime\": \"18:10\",\"starttime\": \"06:40\",\"sid\": 1036,\"stype\": \"38\"}]},{\"downlist\": [],\"line\": {\"id\": -1,\"name\": \"admin\",\"iccard\": \"1\"},\"uplist\": [{\"endtime\": \"18:10\",\"starttime\": \"06:40\",\"sid\": 385,\"stype\": \"38\"},{\"endtime\": \"18:10\",\"starttime\": \"06:40\",\"sid\": 1036,\"stype\": \"38\"}]}]"; data[] datas = jsonconvertdeserializeobject<data[]>(jsonstring); foreach (data data in datas) { downlist[] downlist = datadownlist; line line = dataline; uplist[] uplists = datauplist; //输出 consolewriteline(stringjoin(",", lineid, linename, lineiccard)); foreach (uplist uplist in uplists) { consolewriteline(stringjoin(",", uplistendtime, upliststarttime, uplistsid, upliststype)); } consolewriteline("-----------------------------------------------"); } } } public class data { public downlist[] downlist { get; set; } public line line { get; set; } public uplist[] uplist { get; set; } } public class downlist { } public class line { public int id { get; set; } public string name { get; set; } public string iccard { get; set; } } public class uplist { public string endtime { get; set; } public string starttime { get; set; } public int sid { get; set; } public string stype { get; set; } } }

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持服务器之家。

原文链接：http://blog.csdn.net/chinacsharper/article/details/9246627