How To Convert And Bind JSON String In To ASP.NET GridView With C#

Requirement

If we don't know about JSON string/objects and how many columns there are or the column names, then we won't be able to create a C# class for an object deserializeObject, and I mean wrapper class. Here, the requirement is to bind GridView from JSON object without AJAX/jQuery and loop in C# also without wrapper class.

1. Create a Web Application in Visual Studio.
   
   
   

2. Right click on the project and add a Web form by clicking Web Form.
   
   
   
   
3. Afterwards, open a Windows popup. In this, enter your Web Form name and click Add button.
   
   
   

4. Open your Web form .aspx source/design part and go to ToolBox. Drag and drop ASP.NET GridView control in to the Web form and set GridView style, as per your requirement.
   
   
   

5. Here, a way to bind GridView from JSON is given below.
   
   
   1. Use dynamic keyword with JsonConvert.DeserializeObject. Here, you need to import Newtonsoft.Json.
   2. Use DataTable with JsonConvert.DeserializeObject. Here, you need to import, using System.Data.
      
      
      

Dynamic

This is a data type, dynamic data type introduced since .NET Framework 4.0. The dynamic data type allows you to perform any operation and will be resolved at the run time. It does not require explicit type casting for any operation at run-time, because it identifies the types at run-time only. Dynamic type can be passed as a function argument and function can also return an object type. It is useful when coding , using reflection or dynamic language support or with the COM objects, because we need to write less code. [http://www.c-sharpcorner.com/blogs/variable-object-and-dynamic-data-type-in-c-sharp1]

DataTable

In .NET, it's a class, which represents a table of in-memory data.

CODE

.ASPX