C#序列化和反序列化综合案例(3)_H5之家 - 中国HTML5教程资源分享第一站

1.首先创建一个JsonToDataTable的通用方法

Json 字符串转换为 DataTable数据集合 public DataTable JsonToDataTable(string json) { DataTable dataTable = new DataTable(); //实例化 DataTable result; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); javaScriptSerializer.MaxJsonLength = Int32.MaxValue; //取得最大数值 ArrayList arrayList = javaScriptSerializer.Deserialize<ArrayList>(json); if (arrayList.Count > 0) { foreach (Dictionary<string, object> dictionary in arrayList) { if (dictionary.Keys.Count == 0) { result = dataTable; return result; } if (dataTable.Columns.Count == 0) { foreach (string current in dictionary.Keys) { dataTable.Columns.Add(current, dictionary[current].GetType()); } } DataRow dataRow = dataTable.NewRow(); foreach (string current in dictionary.Keys) { dataRow[current] = dictionary[current]; } dataTable.Rows.Add(dataRow); //循环添加行到DataTable中 } } } catch { } result = dataTable; return result; }

2.新建一个json字符串并赋值。然后调用上面的方法就可以转为DataTable了。

string json = string.Empty; json = "name\":\"Jason\",\"id\":20130001,\"phone\":\"13579246810\"}," + "," + ""; DataTable dt = JsonToDataTable(json); 3.如何把DataTable转为JSON string

1.新建一个DataTableToJson的方法

Converts datatable to JSON string. (DataTable dt) { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); javaScriptSerializer.MaxJsonLength = Int32.MaxValue; //取得最大数值 ArrayList arrayList = new ArrayList(); foreach (DataRow dataRow in dt.Rows) { Dictionary<string, object> dictionary = new Dictionary<string, object>(); //实例化一个参数集合 foreach (DataColumn dataColumn in dt.Columns) { dictionary.Add(dataColumn.ColumnName, dataRow[dataColumn.ColumnName].ToString()); } arrayList.Add(dictionary); //ArrayList集合中添加键值 } return javaScriptSerializer.Serialize(arrayList); //返回一个json字符串 }

2.调用方法，传入一个DataTable就可以。哪个DataTable都可以的。

string json = DataTableToJson(dt); 4.如何序列化？

1.创建一个方法

ConvertS an object to a JSON string When the string length is long (Object o) { JavaScriptSerializer j = new JavaScriptSerializer(); j.MaxJsonLength = Int32.MaxValue; return j.Serialize(o); }

2.就这样传入一个对象就行了。
比如：Person p = new Person();string json = ToJson2(p);
上面在DataTable中也用到过序列化的Demo，可以参考用到大量数据时进行转JSON

5.如何从txt文件中读取JSON格式的数据并反序列化

简述下流程：
1.判断txt的存在
2.读取txt的内容
3.通过下面的代码把JSON对象存入一个泛型中

List<Person> people = jss.Deserialize<List<Person>>(json);

4.通过映射，自动获取到JSON对应类(Class)的属性名，实现自动化并通过遍历输出

PropertyInfo[] piArr = typeof(Person).GetProperties(BindingFlags.Instance | BindingFlags.NonPublic | BindingFlags.Public); if (people.Count == 0) { DeserializeToObject(json); return; } //Get the name and value of the specified class Person automatically. foreach (var person in people) { sb.Clear(); foreach (PropertyInfo pi in piArr) { sb.Append(pi.Name + "=" + pi.GetValue(person)); sb.Append("\t "); } listAll.Items.Add(sb.ToString()); //listAll.Items.Add("name=" + person.Name + "\tid=" + person.Id + "\tphone=" + person.Phone); }