这种类型的json应该怎么去获取里面的值,然后存入数据库,搞了很久搞不定,刚刚接触编程,请问这种问题应该怎么去解决呢

这种类型的json应该怎么去获取里面的值,然后存入数据库,搞了很久搞不定,刚刚接触编程,请问这种问题应该怎么去解决呢

找这个 dll,添加引用 Newtonsoft.Json.dll
var str = "[[\"123\",\"456\",\"789\"],[\"asd\",\"zxc\",\"bnm\"]]";
[{"time":"4/27/2018","Name":"一楼","No":"2"},{"time":"4/28/2018","Name":"一楼","No":"3"},{"time":"4/24/2018","Name":"一楼","No":"7"}]
static void Main(string[] args)
{
var str = "[[\"123\",\"456\",\"789\"],[\"asd\",\"zxc\",\"bnm\"]]";
var m = Newtonsoft.Json.JsonConvert.DeserializeObject(str);
var arr = (Newtonsoft.Json.Linq.JArray)m;
var ls = arr[0].ToArray(); //第一组
foreach (var item in arr)
{
var ar = item.ToArray();
Console.WriteLine(ar[0]);
Console.WriteLine(ar[1]);
Console.WriteLine(ar[2]);
}
Console.WriteLine(str);
Console.ReadLine();
}