json数据格式:
{"Id":20547,"Name":"中南大学","NameEn":"central-south university","AreaId":190},{"Id":20548,"Name":"湖南大学","NameEn":"Hunan university","AreaId":190},{"Id":20549,"Name":"湖南师范大学","NameEn":"hunan normal university","AreaId":190}
首先还是介绍下实体类吧,在这切记类名和json的大小写什么的都要一致。
public class School
{
[System.Runtime.Serialization.DataMember]
public string Id { get; set; }
[System.Runtime.Serialization.DataMember]
public string Name { get; set; }
[System.Runtime.Serialization.DataMember]
public string NameEn { get; set; }
[System.Runtime.Serialization.DataMember]
public string AreaId { get; set; }
}
获取单单一条结果集我参考了下别人的写法:
public static School getOneJson(string jsonText)
{
using (MemoryStream ms = new MemoryStream(Encoding.UTF8.GetBytes(jsonText)))
{
DataContractJsonSerializer serializer = new DataContractJsonSerializer(typeof(School));
return (School)serializer.ReadObject(ms);
}
}