using System.Net;
using System.IO;
using Newtonsoft.Json.Linq;
using System.Data;
//访问url,返回json
string url = "";
HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(url);
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Stream responseStream = response.GetResponseStream();
StreamReader sr = new StreamReader(responseStream, Encoding.GetEncoding("utf-8"));
string responseText = sr.ReadToEnd();
sr.Close();
sr.Dispose();
responseStream.Close();
string jsonData = responseText;
jsonData = jsonData.Replace("<br />", "");//有换行符就截取掉
//
DataTable dtRuslet = new DataTable();
dtRuslet.Columns.Add("Date", typeof(string));
dtRuslet.Columns.Add("Money", typeof(int));
DataRow dr = null;
//解析josn,转换成DataTable
JObject mJObj = JObject.Parse(jsonData);
JArray mData = (JArray)mJObj["data"];
foreach (JObject obj in mData)
{
dr = dtRuslet.NewRow();
dr["Date"] = obj["date"].ToString();
dr["Money"] = Convert.ToInt32(obj["money"]);
dtRuslet.Rows.Add(dr);
}