public void LoadPlace()
{
try
{
using (var webClient = new System.Net.WebClient())
{
var json = webClient.DownloadString(this.get_place_api);
Dictionary <string, string>[] p = JsonConvert.DeserializeObject <Dictionary <string, string>[]>(json);
Dictionary <string, string> item = new Dictionary <string, string>();
DataSet1TableAdapters.tb_placeTableAdapter tb_place = new DataSet1TableAdapters.tb_placeTableAdapter();
tb_place.TruncateData();
foreach (Dictionary <string, string> pp in p)
{
System.Console.WriteLine(Convert.ToInt32(pp["id"]));
item.Add(pp["id"], pp["place_name"]);
try
{
int insert_id = (int)tb_place.InsertQuery(Convert.ToInt32(pp["id"]), pp["place_name"]);
Console.WriteLine("ID:" + insert_id);
}
catch (InvalidDataException de)
{
Console.WriteLine(de.Message);
}
}
dlPlace.DataSource = new BindingSource(item, null);
dlPlace.DisplayMember = "Value";
dlPlace.ValueMember = "Key";
DataTable dt = tb_place.GetData();
Console.WriteLine("Data Count:" + tb_place.CountAll());
// Now parse with JSON.Net
}
}
catch (JsonException ex)
{
Console.WriteLine(ex.Message);
}
}