问题

var persons = JsonConvert.DeserializeObject<List<Member>>(AccountDetails);

DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("InNumber", typeof(System.String)));
dt.Columns.Add(new DataColumn("OutNumber", typeof(System.String)));

foreach (var item in persons)
{
    DataRow dr = dt.NewRow();
    dr["InNumber"] = item.InNumber;
    dr["OutNumber"] = item.OutNumber;

    dt.Rows.Add(dr);
}

{
  "AccountDetails": [
    {
      "InNumber": "123453333",
      "OutNumber": "125666666"
    },
    {
      "InNumber": "2345543334",
      "OutNumber": "4556666667"
    },
    {
      "InNumber": "9793543333",
      "OutNumber": "2345543333"
    }
  ]
}

var persons = JsonConvert.DeserializeObject<List<Member>>(AccountDetails);

    DataTable dt = new DataTable();
    dt.Columns.Add(new DataColumn("InNumber", typeof(System.String)));
    dt.Columns.Add(new DataColumn("OutNumber", typeof(System.String)));
    

    foreach (var item in persons)
    {
        DataRow dr = dt.NewRow();
        dr["InNumber"] = item.InNumber;
        dr["OutNumber"] = item.OutNumber;

        dt.Rows.Add(dr);
    }

答案1

得分: 2

以下是代码部分的翻译：

这是对我的评论的详细说明。

这里我创建了一个类来保存您的帐户详细信息：

public class AccountDetail
{
    public string InNumber { get; set; }
    public string OutNumber { get; set; }
}

但是，您的JSON数据表示一个具有表示这些详细信息集合的单个属性的对象，所以我还需要这个：

public class Account
{
    public List<AccountDetail> AccountDetails { get; set; }
}

现在我可以将您的数据反序列化为一个Account实例：

public static void Test()
{
    const string data = @"
         {
          ""AccountDetails"": [
            {
                ""InNumber"": ""123453333"",
                ""OutNumber"": ""125666666""
            },
            {
                ""InNumber"": ""2345543334"",
                ""OutNumber"": ""4556666667""
            },
            {
                ""InNumber"": ""9793543333"",
                ""OutNumber"": ""2345543333""
            }
          ]
        }";
    var result = JsonConvert.DeserializeObject<Account>(data);
}

在回复我的评论中，您说：“我能够列出所有的InNumber和Outnumber，但很难确定哪个InNumber与Outnumber标记在一起 - 请问我该如何显示记录 - 以便很容易地识别两个相关的号码，因为最终我需要将InNumber和相应的Outnumber存储在数据库中。”

我不太明白。您有一个AccountDetail对象的列表，每个对象都有一个InNumber / OutNumber对。这很容易通过任何现代数据库访问机制（或者只需在INSERT语句周围循环）插入到数据库中。您没有显示您的数据库访问代码，所以我无法告诉您。

我可以告诉您的是，除非我正在处理非常古老的代码，否则我几乎不使用DataTable。

由于您似乎非常希望它在一个DataTable中，所以将以下代码添加到Test的末尾（在以var result =开头的行之后）：

DataTable dataTable = new DataTable();
dataTable.Columns.Add(new DataColumn("InNumber", typeof(System.String)));
dataTable.Columns.Add(new DataColumn("OutNumber", typeof(System.String)));

foreach (var accountDetail in result.AccountDetails)
{
    DataRow dr = dataTable.NewRow();
    dr["InNumber"] = accountDetail.InNumber;
    dr["OutNumber"] = accountDetail.OutNumber;

    dataTable.Rows.Add(dr);
}

public class AccountDetail
{
    public string InNumber { get; set; }
    public string OutNumber { get; set; }
}

public class Account
{
    public List<AccountDetail> AccountDetails { get; set; }
}

public static void Test()
{
    const string data = @"
         {
          ""AccountDetails"": [
            {
                ""InNumber"": ""123453333"",
                ""OutNumber"": ""125666666""
            },
            {
                ""InNumber"": ""2345543334"",
                ""OutNumber"": ""4556666667""
            },
            {
                ""InNumber"": ""9793543333"",
                ""OutNumber"": ""2345543333""
            }
          ]
        }";
    var result = JsonConvert.DeserializeObject<Account>(data);
}

DataTable dataTable = new DataTable();
dataTable.Columns.Add(new DataColumn("InNumber", typeof(System.String)));
dataTable.Columns.Add(new DataColumn("OutNumber", typeof(System.String)));

foreach (var accountDetail in result.AccountDetails)
{
    DataRow dr = dataTable.NewRow();
    dr["InNumber"] = accountDetail.InNumber;
    dr["OutNumber"] = accountDetail.OutNumber;

    dataTable.Rows.Add(dr);
}

答案2

得分: 1

如果你想要一个 DataTable

DataTable dt = JObject.Parse(jsonString)["AccountDetails"].ToObject();

如果你想要一个 List

List persons = JObject.Parse(jsonString)["AccountDetails"].ToObject<List>();

public class AccountDetail
{
public string InNumber { get; set; }
public string OutNumber { get; set; }
}

<details>
<summary>英文:</summary>

if you want a DataTable 

DataTable dt = JObject.Parse(jsonString)["AccountDetails"].ToObject<DataTable>();

if you want a List

List<AccountDetail> persons = JObject.Parse(jsonString)["AccountDetails"].ToObject<List<AccountDetail>>();

public class AccountDetail
{
public string InNumber { get; set; }
public string OutNumber { get; set; }
}

</details>



# 答案3
**得分**: 1

你所展示的JSON是一个包含名为AccountDetails的属性的对象，其中包含了你的数组。请注意外部的JSON由{ }括起来，而不是[ ]，这就是你看到那个错误的原因。

这是https://stackoverflow.com/questions/45066930/deserialize-json-into-c-sharp-collection的重复问题。

你可以像这样解决它：

[示例代码][1]

或者你可以从JSON对象中解析出集合（下面的答案）

创建一个包含AccountDetails列表的对象

```csharp
public class ListContainingObject
{
    public List<Member> AccountDetails;
}
```

将其反序列化为

```csharp
var listcontainingobject = JsonConvert.DeserializeObject<ListContainingObject>(jsontext);
```

[1]: https://dotnetfiddle.net/n15KRR

<details>
<summary>英文:</summary>

The JSON you&#39;ve shown is an Object with a Property called AccountDetails that contains your array. Note how the outer Json is surrounded by { } and not [ ] which is why you&#39;re seeing that error.

This is a duplicate of https://stackoverflow.com/questions/45066930/deserialize-json-into-c-sharp-collection

You could solve that, for instance, like this:

[working example][1]

or you parse the collection out of the JSON Object (the answer below)

Create an object that contains a list of AccountDetails

    public class ListContainingObject
    {
    	public List&lt;Member&gt; AccountDetails;
    }

deserialize to that 

    var listcontainingobject = JsonConvert.DeserializeObject&lt;ListContainingObject&gt;(jsontext);


https://dotnetfiddle.net/NXCrDC


  [1]: https://dotnetfiddle.net/n15KRR

</details>