在我的asp。net web API,JSON字符串返回如下。
[
{
"Company": "Company A",
"ProjectName": "Project A",
"Developer": "No developer assigned",
"Hour": 0,
"Overtime": 0,
"Contribution": "0"
},
{
"Company": "Company A",
"ProjectName": "Project B",
"Developer": "paul",
"Hour": 36,
"Overtime": 27,
"Contribution": "71.5909%"
},
{
"Company": "Company A",
"ProjectName": "Project B",
"Developer": "kalpa",
"Hour": 16,
"Overtime": 9,
"Contribution": "28.4091%"
},
{
"Company": "Company B",
"ProjectName": "Project C",
"Developer": "shane",
"Hour": 40,
"Overtime": 14,
"Contribution": "78.2609%"
},
{
"Company": "Company B",
"ProjectName": "Project C",
"Developer": "kal",
"Hour": 10,
"Overtime": 5,
"Contribution": "21.7391%"
},
{
"Company": "Company C",
"ProjectName": "Project D",
"Developer": "No developer assigned",
"Hour": 0,
"Overtime": 0,
"Contribution": "0"
},
{
"Company": "Company D",
"ProjectName": "Project E",
"Developer": "No developer assigned",
"Hour": 0,
"Overtime": 0,
"Contribution": "0"
}
]
当我在C#桌面应用程序上使用API并显示JSON字符串时,如下图所示:
这是我的C#桌面应用程序代码,用于显示JSON对象
datagridview
在
setGrid
方法,该方法将JSON对象作为参数并显示在
datgridview
。
public void setGrid(string obj)
{
try
{
var json = JsonConvert.DeserializeObject<dynamic>(obj);
dataGridView1.DataSource = json;
}
catch (Exception)
{
throw;
}
}
但我需要将此结果显示为下图。我需要为相同的值合并公司列。此图显示了预期结果:
我该怎么做?