This is a migrated thread and some comments may be shown as answers.

[Solved] Loosing formats when paging through the grid (Ajax Binding)

5 Answers 138 Views

Grid

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

Ben asked on 04 Apr 2011, 01:41 PM

a1.png

a2.png

Hi there,

i`ve got a problem with the Ajax Binding of the ASP.NET MVC Grid. I retrieve data from a WebService as a List<T> and bind this to the Grid. When the View is loaded, the Grid looks fine and the first 10 Rows are filled correctly, but when the User pages through the grid the data looses their format.

List<DocumentItemDto> data = ArticleHistoryProvider.GetDocumentItems(clienReportingRequest);

return View("SearchResult", data);

Here`s the Razor of the appropiate view with the Grid definition.

@(Html.Telerik().Grid(Model)

.Name("Items")

.Columns(columns =>

{

columns.Bound(o => o.GTIN);

columns.Bound(o => o.ArticleNumber).Title("Artikelnummer");

columns.Bound(o => o.BranchNumber).Title("Filiale");

columns.Bound(o => o.Currency).Title("Währung").Width(80);

columns.Bound(o => o.DateTime).Format("{0:dd/MM/yyyy}").Title("Datum");

columns.Bound(o => o.ManufArticleNumber).Title("Hersteller");

columns.Bound(o => o.Quantity).Title("Menge");

columns.Bound(o => o.RetailPrice).Title("VK");

columns.Bound(o => o.Type).Title("Vorgang");

})

.DataBinding(dataBinding => dataBinding.Ajax().Select("AjaxBinding", "ArticleHistory"))

.Scrollable()

.Filterable()

.Sortable()

.Groupable()

.Pageable(paging => paging.PageSize(10))

.Footer(true)

)

For example, the Column "Vorgangsart" shows the name of the transaction like Sales, GoodsReceipt, etc... but after paging only the Int-Values are shown. To illustrate this issue I attached the screeshots!

Here`s the code for the Ajax Binding in the Controller

#region AjaxBinding

[GridAction]

public ActionResult AjaxBinding()

{

return View("SearchResult", new GridModel<DocumentItemDto>

{

Data = GetCachedData()

});

}

#endregion

#region GetCachedData

private IEnumerable<DocumentItemDto> GetCachedData()

{

return Session[Cache] as IEnumerable<DocumentItemDto>;

}

#endregion

I believe that it`s a JSON problem, but don`t know. I hope that someone can give me a tip on this. Thanks in advance.

5 Answers, 1 is accepted

answered on 04 Apr 2011, 02:19 PM

Hi Kevin,

I checked it with Fiddler and there is the same result as in the Grid.

For example:

{"data":[{"DateTime":"\/Date(1188813240000)\/","Type":2,"ArticleNumber":"13430000200","GTIN":"7610441817353","BranchNumber":"10","ManufArticleNumber":"15533","RetailPrice":39.9500007629395,"Quantity":1,"Currency":"___"}

But in the VS2010 Debugger the correct data is shown. Maybe the GridModel object converts the List<T> into JSON. As you can see in the Fiddler-Log the "Type":2 should be "Type":GoodsReceipt.

Do you have a tip, how I can solve this problem? As I said, when i retireve the Data from the web-service in the first step the data looks fine in the grid.