[Solved] Bind Grid to JSON object?

[Sam Daniels]

I'm curious if it's possible to bind a grid to a JSON object, much like it's done in the TreeView example here:

http://demos.telerik.com/aspnet-mvc/treeview/clientsidebinding

I'd like to be able to construct a JSON object that includes the entire grid, and then just bind the grid to the JSON object.  I don't want to bind the grid to my Model, and I don't want to have to statically define my columns.

[Atanas Korchev]

Hi Sam Daniels,

It is possible to bind the grid to a JavaScript object. However the columns must be predefined. Here is a short code snippet:

var data = {data : [{CustomerID:1}, {CustomerID:2}], total:2 };
grid.dataBind(data);

Regards,
Atanas Korchev
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Sam Daniels]

Thanks for the quick response.

Is this something that's likely to be implemented in a future release?  We are evaluating our options with Grids and we don't know the column names until run time.  I've looked at the AutoGeneratedColumn example, but our Model doesn't work for that either.  Ideally we would be able to create a JSON object that IS the grid, and then bind without having to predefine columns.

If it's not a current feature request, can we add it?

Thanks again,
Sam

[Atanas Korchev]

Hi Sam Daniels,

We will consider this as a feature request and add it should more users start requesting it.

Regards,
Atanas Korchev
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Godson Menezes]

Hello ,

My requirement is to search the list as you type for this I am trying to bind the grid to json object on onDataBinding ,but i am getting the grid object as undefined.
Here is the code,

 

 

 

View:

<div id ="VisitPtList" >

  

<%= Html.Telerik().Grid<UserViewForms.PersonViewModel>()

  

.Name("Grid")

  

.Columns(columns =>

  

{

  

columns.Template(o => { }).Width(200).Title("Name");

  

columns.Template(o => { }).Width(200);

  

columns.Template(o => { }).Width(200);

  

columns.Template(o => { }).Width(100);

  

})

  

.ClientEvents(events => events

  

.OnDataBinding("onDataBinding")

  

)

  

.Sortable()

  

.Scrollable()

  

%>

  

</div>

  

  

  

var url = '<%= Url.Action("GetPersonList","PersonExistCheck") %>';

  

var grid = $(this).data('tGrid');

  

  

function onDataBinding(e) {

  

  

var sName = "test";

  

$.getJSON(url , { familyName: $('#Name').val() }, function(data) {

  

grid.dataBind(data);

  

});

  

   

  

  

}

  

  

Controller:

  

  

public ActionResult GetPersonList(string Name)

  

{

  

var data = GetPersons(Name);

  

  

return Json(data, JsonRequestBehavior.AllowGet);

  

}

Can you please provide me an sample to bind grid to json object. I want to do the search on client .

Thanks

[Atanas Korchev]

Hello Godson Menezes,

 Try putting that code in the ondatabinding handler:

  

  

function onDataBinding(e) {

  

var grid = $(this).data('tGrid');




  

var sName = "test";

  

$.getJSON(url , { familyName: $('#Name').val() }, function(data) {

  

grid.dataBind(data);

  

});

}

Regards,
Atanas Korchev
the Telerik team