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

[Solved] An internal 500 error thrown when try to play the related grid sample

8 Answers 140 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.

ady zhu asked on 18 Nov 2009, 05:36 AM

I tried to play around the related grid and here is my sample code

At Controller

public partial class CPRScrumController : Controller

{

public ActionResult ViewScrumNotes()

{

ViewData["CPRScrumNote"] = GetScrumNote();

ViewData["CPRs"] = GetCPRForScrumNote("222181");

return View(GetScrumNote());

}

[GridAction]

public ActionResult _ViewScrumNotes_CPRs(string cprID)

{

cprID = cprID ?? "222181";

return View(new GridModel<VantiveCPR>

{

Data = GetCPRForScrumNote(cprID)

});

}

[GridAction]

public ActionResult _ViewScrumNotes_ScrumNotes()

{

return View(new GridModel<SYS2CPRScrumNote>

{

Data = GetScrumNote()

});

}

At View:

<%= Html.Telerik().Grid<SYSIISCRUM.Models.SYS2CPRScrumNote>()

.Name("CPRScrumNotes")

.Columns(columns =>

{

columns.Add(c => c.ScrumCPRID).Width(20);

columns.Add(c => c.ScrumCPRTitle).Width(200);

columns.Add(c => c.ScrumDate).Width(100).Format("{0:dd/MM/yyyy}");

columns.Add(c => c.ScrumTest).Width(200);

columns.Add(c => c.ScrumDev).Width(200);

columns.Add(c => c.ScrumTeam).Width(200);

columns.Add(c => c.ScrumNotes).Width(200);

columns.Add(c => c.ScrumCPRProduct).Width(200);

columns.Add(c => c.ScrumCPRPriority).Width(200);

})

.Ajax(ajax => ajax.Action("_ViewScrumNotes_ScrumNotes", "CPRScrum"))

.Pageable()

.Sortable()

.Filterable()

.RowAction(row =>

{

if (row.DataItem.ScrumCPRID == "222181")

{

row.HtmlAttributes["class"] = "t-state-selected";

}

})

.BindTo((IEnumerable<SYSIISCRUM.Models.SYS2CPRScrumNote>)ViewData["CPRScrumNote"])

<%= Html.Telerik().Grid<SYSIISCRUM.Models.VantiveCPR>()

.Name("CPRs")

.Columns(columns=>

{

columns.Add(c => c.CPRID).Width(100);

columns.Add(c => c.CPRTitle).Width(100);

columns.Add(c => c.CPRCreateDate).Width(200).Format("{0:dd/MM/yyyy}");

columns.Add(c => c.CPRComponent);

columns.Add(c => c.CPRFeature).Width(200);

columns.Add(c => c.CPRDescription);

})

.Pageable()

.Sortable()

.Ajax(ajax => ajax.Action("_ViewScrumNotes_CPRs", "CPRScrum", new { CPRID = "222181" }))

.BindTo((IEnumerable<SYSIISCRUM.Models.VantiveCPR>)ViewData["CPRs"])

Html.Telerik().ScriptRegistrar()

.OnDocumentReady(() =>

{

var cprsGrid = $('#CPRs').data('tGrid');

$('#CPRScrumNotes tbody tr')

.live("click", function() {

// `this` == clicked row

var cprID = this.cells[0].innerHTML;

// add selected style to clicked row

$(this).addClass('t-state-selected')

.siblings()

.removeClass('t-state-selected');

// update ui text

$('#cprID').text(cprID);

// rebind the related grid

cprsGrid.rebind({

CPRID: cprID

});

})

/* add hover effects */

.live("mouseenter", $.telerik.hover)

.live("mouseleave", $.telerik.leave);

});

Initial view shows fine, but when i try to refresh the main grid (scrum notes) or child grid (cpr) or click on the one row of the main grid, i got internal server error of 500 thrown by the _ViewScrumNotes_ScrumNotes and _ViewScrumNotes_CPRs.

What is the possible reason i got this type of error?

thx

8 Answers, 1 is accepted

answered on 25 Nov 2009, 02:00 PM

Hi ady zhu,

The described behavior is expected, because the action method returns view and there is no corresponding page with the same name. The error 500 could be produced when circular reference is detected when the IEnumerable collection is serialized.

Nevertheless I am not able to advice you further without the text of the error returned from the server. As I mentioned earlier in this thread you can use Fiddler or Firebug and investigate the response of the problematic request. In the response header you can find the required text which describes what 500 error actually means.

Sincerely yours,
Georgi Krustev
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

answered on 04 Dec 2009, 09:56 AM

I was having this exact same problem. The grid was giving me a 500 error, and the debug complained that it could not find the _AjaxBinding view even though I had the [GridAction] attribute there.

I believe this is because of what you said - there were circular relationships in the Linq entities I was trying to bind to. The way I fixed this was to add the GridWithAnonimousTypes extension method and use it to bind to explicit properties via anonymous type.

Is there any other way to get around this? Using anonymous types all the time is fairly annoying, and I'm losing type safety.

Am I just constructing my database poorly? Any advice would be appreciated.