Can we Bind Json directly?

Question

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();
}

C#

Copy

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

<asp:GridView ID="grd3wayInitiate" class="table table-bordered table-hover dataTable"  HeaderStyle-BackColor="#334d88" runat="server"
    EmptyDataText="No Records Found"
    AutoGenerateColumns="false"
    ShowFooter="true">
    <PagerStyle CssClass="paginate_btns" HorizontalAlign="left" />
    <PagerSettings FirstPageText="Previous" LastPageText="Next" PageButtonCount="5" />
    <FooterStyle BackColor="#334d88" ForeColor="white" CssClass="tab1" />
    <HeaderStyle BackColor="#334d88" Font-Bold="True" ForeColor="white" CssClass="tab1" />
</asp:GridView>

Markup

Copy

Answer 1

 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<DataTable>(yourJsonString);

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

Example 2: By Custom Class

List<CustomClass> customClasses = DeserializeJson<List<CustomClass>>(yourJsonString);

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



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

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

Answer 2

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<DataTable>(strJsonRecon);  

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

Answer 3

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.

Answer 4

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/

Answer 5

Hi,

You can try this :

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