Break data from json and bind with datagrid.

Question

Hello; I have a json file(API) and need to fetch some data and bind with datagrid My JSON FIle is: { "records": [ { "status": null, "version": 1, "id": "89fc25ea-721b-42ca-9ff1-756a7d386dd8", "created_at": "2017-02-15T04:29:23Z", "updated_at": "2017-02-15T04:29:23Z", "client_created_at": "2017-02-15T04:24:44Z", "client_updated_at": "2017-02-15T04:29:08Z", "created_by": "Graham Patterson", "created_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f", "updated_by": "Graham Patterson", "updated_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f", "created_location": null, "updated_location": null, "created_duration": 264, "updated_duration": 264, "edited_duration": 264, "form_id": "a8ac8685-21d4-4e72-9ecc-705254fb3f80", "project_id": null, "assigned_to": null, "assigned_to_id": null, "form_values": { "6963": { "other_values": [], "choice_values": [ "Fine", "Hot", "Sunny" ] }, "7705": "Xyz", "e7ba": "Structure number", "c353": "Name of line
", "576f": [ { "id": "4d7acf29-c342-4c2c-95d9-ea3c57efa10f", "created_at": "1487132878", "form_values": { "3962": "Issue 1", "bd46": [ { "caption": null, "photo_id": "3d68109b-fd3f-4d77-9634-a872daca87b7" } ] }, "geometry": null, "created_duration": 18, "updated_at": "1487132896", "updated_duration": 18, "edited_duration": 18, "version": 1, "created_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f", "updated_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f", "changeset_id": "6a0ac5b9-0063-4993-a0eb-0ea448b232bf" }, { "id": "49541964-4a2e-414b-bcd9-76863004ee59", "created_at": "1487132899", "form_values": { "3962": "Issue 2", "bd46": [ { "caption": null, "photo_id": "1d1434c7-6795-47f7-aa98-33fb550dcaa7" } ] }, "geometry": null, "created_duration": 13, "updated_at": "1487132912", "updated_duration": 13, "edited_duration": 13, "version": 1, "created_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f", "updated_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f", "changeset_id": "6a0ac5b9-0063-4993-a0eb-0ea448b232bf" } ], "cf63": [ { "created_location": { "latitude": -27.2264784317734, "longitude": 152.984398535856, "altitude": 26, "horizontal_accuracy": 65 }, "id": "8a3a27c5-69d0-4017-85b6-1e52aefc2717", "created_at": "1487132922", "form_values": { "794f": { "other_values": [], "choice_values": [ "U71-776" ] } }, "geometry": { "type": "Point", "coordinates": [ 152.984398535856, -27.2264784317734 ] }, "updated_location": { "latitude": -27.2264784317734, "longitude": 152.984398535856, "altitude": 26, "horizontal_accuracy": 65 }, "created_duration": 6, "updated_at": "1487132929", "updated_duration": 6, "edited_duration": 6, "version": 1, "created_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f", "updated_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f", "changeset_id": "6a0ac5b9-0063-4993-a0eb-0ea448b232bf" }, { "created_location": { "latitude": -27.2264784317734, "longitude": 152.984398535856, "altitude": 26, "horizontal_accuracy": 65 }, "id": "6bc31253-1512-415c-94d4-d243f42b0d29", "created_at": "1487132937", "form_values": { "794f": { "other_values": [], "choice_values": [ "680-SZJ" ] } }, "geometry": { "type": "Point", "coordinates": [ 152.984398535856, -27.2264784317734 ] }, "updated_location": { "latitude": -27.2264784317734, "longitude": 152.984398535856, "altitude": 26, "horizontal_accuracy": 65 }, "created_duration": 5, "updated_at": "1487132942", "updated_duration": 5, "edited_duration": 5, "version": 1, "created_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f", "updated_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f", "changeset_id": "6a0ac5b9-0063-4993-a0eb-0ea448b232bf" } ], "5dd8": "10:29", "d0c9": { "other_values": [], "choice_values": [ "Back to base Training - 12003" ] }, "e17c": "Work completed today", "7f8a": { "other_values": [], "choice_values": [ "Staff" ] }, "f3af": "2017-02-15", "06ab": [ { "id": "7e4e4b66-1256-46e1-8f2b-b5afa339e6f9", "created_at": "1487132693", "form_values": { "2533": "14:24", "34f7": "yes", "96d2": { "other_values": [], "choice_values": [ "112.78" ] }, "719c": { "other_values": [], "choice_values": [ "Gerald Clifton" ] }, "54b0": "14:24" }, "geometry": null, "created_duration": 11, "updated_at": "1487132705", "updated_duration": 11, "edited_duration": 11, "version": 1, "created_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f", "updated_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f", "changeset_id": "6a0ac5b9-0063-4993-a0eb-0ea448b232bf" }, { "id": "77d5fc68-0929-4ab0-97fa-2cdd0f24e015", "created_at": "1487132706", "form_values": { "2533": "14:25", "34f7": "no", "96d2": { "other_values": [], "choice_values": [ "112.78" ] }, "719c": { "other_values": [], "choice_values": [ "Maxinr Rhind" ] }, "54b0": "08:25" }, "geometry": null, "created_duration": 22, "updated_at": "1487132728", "updated_duration": 22, "edited_duration": 22, "version": 1, "created_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f", "updated_by_id": "571fdc4a-28ee-4fd8-8c2d-7d6758f3910f", "changeset_id": "6a0ac5b9-0063-4993-a0eb-0ea448b232bf" } ], "bf00": "14:27", "dd43": "Bus was late" }, "latitude": null, "longitude": null, "altitude": null, "speed": null, "course": null, "horizontal_accuracy": null, "vertical_accuracy": null } ] } I need to fetch values of "createdby" ,"bf00","d0c9" and "7705" and need to bind in datagrid in windows application. Please help.

Ankit Shukla · Answer

Ok Sir, I will check and reply you soon. Thank you.

Ramesh Palanivel · Answer

Hi Ankit, Kindly try my code, Don't forget to install Newtonsoft . Json in Nuget package Manager

Ramesh Palanivel · Answer

Hi Ankit, Try this link, http://www.c-sharpcorner.com/forums/how-to-read-json-file-locally-in-c-sharp http://ourcodeworld.com/articles/read/186/how-to-manipulate-and-use-json-with-c-sharp-and-winforms http://stackoverflow.com/questions/13297563/read-and-parse-a-json-file-in-c-sharp https://social.msdn.microsoft.com/Forums/windowsapps/en-US/fe813fc2-9fdb-4155-9529-7eb9f9f50837/how-to-read-json-file-locally-in-c?forum=wpdevelop http://windowsapptutorials.com/windows-phone/general/deserialize-json-data-using-newtonsoft-json-net-library/