Can we Bind Json directly?

Jaya Prakash

Can we Bind Json String data directly to the gridview

until what i've done is

string dtRecon = oReportsBLL.Initiate3WayRecon(objreports);
if(dtRecon !=null && dtRecon.Length > 0)
{
    grd3wayInitiate.DataSource =  dtRecon ; 
    grd3wayInitiate.DataBind();
}

and my response is like

i just want to bind the result as it is to my gridview

Can this be done? if ok pls help me
if this can't be then give me a suggestion
and i dont want to deserialize it just show as it is in the grid like json pls help me
and my grid design

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty2y ago

Accepted answer

No, you cannot directly bind JSON string data to a GridView control. However, you can parse the JSON string into a collection of objects (such as a list of custom classes or a DataTable) and then bind that collection to the GridView.

Example 1: By DataTable

DataTable dt = JsonConvert.DeserializeObject(yourJsonString);

GridView1.DataSource = dt;
GridView1.DataBind();

Example 2: By Custom Class

List customClasses = DeserializeJson>(yourJsonString);

gridView.DataSource = customClasses;
gridView.DataBind();



private T DeserializeJson(string jsonString)
{
    JavaScriptSerializer serializer = new JavaScriptSerializer();
    return serializer.Deserialize(jsonString);
}

public class CustomClass
{
    public string PropertyOne{ get; set; }
    public int PropertyTwo{ get; set; }
}

Jignesh Kumar2y ago

Hello Jaya Prakash,

Please deserialize your jason string in to data table,

string strJsonRecon = oReportsBLL.Initiate3WayRecon(objreports);

// Add this line to deserialize your json data to datatable.
DataTable dtRecon = JsonConvert.DeserializeObject(strJsonRecon);  

if(dtRecon !=null && dtRecon.Length > 0)
{
    grd3wayInitiate.DataSource =  dtRecon ;
    grd3wayInitiate.DataBind();
}

Sam Hobbs2y ago
If the sample JSON data you show here was shown as text then I could be more specific but it is instead shown here as an image.

If I understand your question then you must deserialize the JSON.
Vishal Yelve2y ago
Hi Jaya,

do refer below article

https://www.c-sharpcorner.com/article/how-to-convert-and-bind-json-string-in-to-asp-net-gridview-with-c-sharp/
Rajeesh Menoth2y ago
Hi,

You can try this :

https://learn.microsoft.com/en-us/answers/questions/715354/how-to-display-json-data-into-gridview