我如何可以解析使用ASP.NET JSON字符串？ [英] How can I parse a JSON string using ASP.NET?

问题描述

我使用Sendgrid API来发送和接收发送的邮件的统计数据。我想存储API在数据库中的响应。

I am using Sendgrid API to send and retrieve statistics of mail sent. I want to store the response of API in database.

protected void btnBounces_Click(object sender, EventArgs e)
{
    try
    {
        string url = "https://api.sendgrid.com/api/bounces.get.json";
        GetResult(url);
    }
    catch (Exception ex)
    {
        lblError.Text = ex.Message.ToString();
    }
}
 public void GetResult(string url)
{
    string parameters = "api_user=xxxx&api_key=xxxx&date=1&start_date="+txtStartDate.Text+"&end_date="+txtEndDate.Text;
    // Start the request
    HttpWebRequest req = (HttpWebRequest)HttpWebRequest.Create(url);
    req.Method = "POST";
    req.ContentType = "application/x-www-form-urlencoded";
    StreamWriter streamWriter = new StreamWriter(req.GetRequestStream());
    streamWriter.Write(parameters);
    streamWriter.Flush();
    streamWriter.Close();
    // Get the response
    HttpWebResponse res = (HttpWebResponse)req.GetResponse();
    StreamReader streamReader = new StreamReader(res.GetResponseStream());
    string result = streamReader.ReadToEnd();
}

我会得到的响应将是这样的：

The response I will get will be like:

[
  {
    "status": "4.0.0",
    "created": "2011-09-16 22:02:19",
    "reason": "Unable to resolve MX host sendgrid.ne",
    "email": "[e-mail]"
  },
  {
    "status": "4.0.0",
    "created": "2011-09-19 17:47:15",
    "reason": "Connection timed out",
    "email": "[e-mail]"
  }
]

我怎么能提取四个领域的价值，并将其存储在包含四个字段的表？

How can i extract value of each of the four fields and store them in table containing four fields?

推荐答案

如果您不希望创建一个Movie类，你可以使用 System.Web.Script.Serialization 解析并获得动态对象。

If you do not want to create a Movie class, you can use System.Web.Script.Serialization to parse and get a dynamic object.

JavaScriptSerializer js = new JavaScriptSerializer();
dynamic movie = js.Deserialize<dynamic>(json);

这篇关于我如何可以解析使用ASP.NET JSON字符串？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！