1 //Jsonstr as JSON string2Jarray array = jsonconvert.deserializeobject (JSONSTR) asJarray;//Deserialize an array3 if(Array. Count >0)4 {5StringBuilder columns =NewStringBuilder ();6DataTable table =NewDataTable ();7Jobject objcolumns = array[0] asJobject;8 //construct a table header9 foreach(Jtoken JkoninchObjcolumns.asenumerable<jtoken>())Ten { One stringName =( (Jproperty) (Jkon)). Name; AColumns. Append (name +","); - table. Columns.Add (name); - } the //adding data to a table - for(inti =0; I < array. Count; i++) - { -DataRow row =table. NewRow (); +Jobject obj = array[i] asJobject; - foreach(Jtoken JkoninchObj. Asenumerable<jtoken>()) + { A at stringName =( (Jproperty) (Jkon)). Name; - stringValue =( (Jproperty) (Jkon)). Value.tostring (); -Row[name] =value; - } - table. Rows.Add (row); - } in}
Deserializing JSON data to a DataTable using Newtonsoft JsonConvert