使用第三方API数据源绑定数据网格
问题描述:
我正在使用C# 4.5
。我创建了一个Windows应用程序。使用第三方API数据源绑定数据网格
根据项目要求,我需要绑定一个第三方api响应,将json
对象数组返回到datagrid
。
我使用RestClient
和取出的数据已经转换他们使用JDynamic
包作为
IRestResponse response = client.Execute(request);
dynamic result = new JDynamic(response.Content);
到对象是否有我可以结合该数组的对象作为gridview的的一个数据源的任何技术?
另外,如果我只需要显示某些列,该怎么办?
编辑:
的JSON的反应是一样的东西:
[
{
"id": 7,
"username": "[email protected]",
"first_name": "Carlos",
"middle_name": "",
"last_name": "Alaiz",
"gender": "male",
"addr1": "",
"addr2": "",
"state": "",
"city": "",
"country": "",
"post_code": "",
"email_id": "[email protected]",
"email_id_alt": "",
"phone1": "1800777333",
"phone2": "",
"photo": "2015-09-09-17-14-29-2015-01-22-06-26-15-400-don-passport-lighting-test 044-3-100pc_pp-ps.jpg",
"populations": [{
"id": 8,
"population_name": "Pop 8"
}]
},
{
"id": 8,
"username": "[email protected]",
"first_name": "Pedro",
"middle_name": "",
"last_name": "Montero",
"gender": "male",
"addr1": "",
"addr2": "",
"state": "",
"city": "",
"country": "",
"post_code": "",
"email_id": "[email protected]",
"email_id_alt": "",
"phone1": "1800999222",
"phone2": "",
"photo": "2015-09-09-17-13-40-2014-10-27-06-59-56-bilde.jpeg",
"populations": [{
"id": 8,
"population_name": "Pop 8"
}]
},
{
"id": 9,
"username": "[email protected]",
"first_name": "Mario",
"middle_name": "",
"last_name": "Sanz",
"gender": "male",
"addr1": "",
"addr2": "",
"state": "",
"city": "",
"country": "",
"post_code": "",
"email_id": "[email protected]",
"email_id_alt": "",
"phone1": "1800288299",
"phone2": "",
"photo": "2015-09-09-17-13-17-2014-10-27-06-28-30-Jim-Smith.jpg",
"populations": [{
"id": 7,
"population_name": "Pop 7"
}]
},
{
"id": 10,
"username": "[email protected]",
"first_name": "Parikshit",
"middle_name": "",
"last_name": "Thakur",
"gender": "male",
"addr1": "",
"addr2": "",
"state": "",
"city": "",
"country": "",
"post_code": "",
"email_id": "[email protected]",
"email_id_alt": "",
"phone1": "1800299200",
"phone2": "",
"photo": "2015-09-10-11-52-05-parikshit.jpg",
"populations": [{
"id": 8,
"population_name": "Pop 8"
}]
},
{
"id": 11,
"username": "[email protected]",
"first_name": "Nidhi ",
"middle_name": "",
"last_name": "Patel",
"gender": "female",
"addr1": "",
"addr2": "",
"state": "",
"city": "",
"country": "",
"post_code": "",
"email_id": "[email protected]",
"email_id_alt": "",
"phone1": "1800200300",
"phone2": "",
"photo": "female.jpg",
"populations": []
}
]
我创建了一个新的类就如下图所示:现在
namespace DemoAutoLogin
{
public class patient
{
public int id { get; set; }
public string username { get; set; }
public string first_name { get; set; }
public string middle_name { get; set; }
public string last_name { get; set; }
public string gender { get; set; }
public string addr1 { get; set; }
public string addr2 { get; set; }
public string state { get; set; }
public string city { get; set; }
public string country { get; set; }
public string post_code { get; set; }
public string email_id { get; set; }
public string email_id_alt { get; set; }
public string phone1 { get; set; }
public string phone2 { get; set; }
public string photo { get; set; }
public List<Population> populations { get; set; }
}
public class Population
{
public int id { get; set; }
public string population_name { get; set; }
}
}
,什么我可以在网格视图中显示JSON记录吗?
答
然后你可以简单地将结果反序列化到IEnumerable<patient>
。使用Json.NET来做到这一点。您可以绑定到网格IEnumerable<patient>
。
public void BindMyData()
{
IEnumerable<patient> patients = JsonConvert.DeserializeObject<IEnumerable<patient>>(resultAsJson);
datagrid.DataSource = patients;
}
应该以这种方式工作..
,如果你没有一个POCO:
public void BindMyData()
{
IEnumerable<Dictionary<string, object>> patients = JsonConvert.DeserializeObject<List<Dictionary<string, object>>>(resultAsString);
// if this works, i'm not sure:
datagrid.DataSource = patients;
}
,如果你不能斌的IEnumerable<Dictionary<string, object>>
到网格,你也许可以绑定数据表。 添加此ToDataTable
扩展:
public static class Exts
{
public static DataTable ToDataTable(this IEnumerable<Dictionary<string, object>> list)
{
DataTable result = new DataTable();
if (!list.Any())
return result;
var columnNames = list.SelectMany(dict => dict.Keys).Distinct();
result.Columns.AddRange(columnNames.Select(c => new DataColumn(c)).ToArray());
foreach (var item in list)
{
var row = result.NewRow();
foreach (var key in item.Keys)
row[key] = item[key];
result.Rows.Add(row);
}
return result;
}
}
然后将它绑定这样:
public void BindMyData()
{
IEnumerable<Dictionary<string, object>> patients = JsonConvert.DeserializeObject<List<Dictionary<string, object>>>(resultAsString);
datagrid.DataSource = patients.ToDataTable();
}
创建一个自定义的POCO(_without_要忽略的列),你可以反序列化这个数据到。将其反序列化为POCO的“IENUMERABLE”或“ILIST”。你可以将它绑定到你的DataGrid。我使用[这个工具](http://jsonutils.com/)来帮助我。 –
@HanletEscaño请问我有一个示例代码吗? – Dev