Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
125
Usage of nullable decimal with MVC chaining does result in SyntaxError yellow page
posted

Greetings,

i'm using the MVC Chaining variant with igGrid and remote usage as in samples displayed.

While tell my grid the Columns to be displayed, Compiler works finde, but the page results in an errorpage.

Detail: Infragistics.Web.Mvc.ParseException: Syntax error.

Stack: [ParseException: Syntax error.]
   Infragistics.Web.Mvc.ExpressionParser.ValidateToken(TokenId t, String errorMessage) +103
   Infragistics.Web.Mvc.ExpressionParser.Parse(Type resultType) +315
   Infragistics.Web.Mvc.DynamicExpression.ParseLambda(ParameterExpression[] parameters, Type resultType, String expression, Object[] values) +92
   Infragistics.Web.Mvc.DynamicExpression.ParseLambda(Type itType, Type resultType, String expression, Object[] values) +132
   Infragistics.Web.Mvc.FilteringExtensions.Where(IQueryable source, String predicate, Object[] values) +235
   Infragistics.Web.Mvc.GridGroupBy.TransformInternal(WrappedGridResponse response) +3214
   Infragistics.Web.Mvc.GridGroupBy.HandleResponse(LargeJsonResult result) +76
   Infragistics.Web.Mvc.GridModel.RenderFlatQueryable(IQueryable queryable) +821
   Infragistics.Web.Mvc.GridModel.DataBind() +488
   Infragistics.Web.Mvc.Grid`1.DataBind() +47
   ASP._Page_Areas_Album_Views_Albums_Index_cshtml.Execute() in g:\Projects\Pilots\In Work\DemoWebPilotMVC - MassDataLoad\DemoWebPilotMVC\Areas\Album\Views\Albums\Index.cshtml:22
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy() +270
   System.Web.Mvc.WebViewPage.ExecutePageHierarchy() +122
   System.Web.WebPages.StartPage.RunPage() +63
   System.Web.WebPages.StartPage.ExecutePageHierarchy() +100
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +131
   System.Web.Mvc.RazorView.RenderView(ViewContext viewContext, TextWriter writer, Object instance) +695
   System.Web.Mvc.BuildManagerCompiledView.Render(ViewContext viewContext, TextWriter writer) +382
   System.Web.Mvc.ViewResultBase.ExecuteResult(ControllerContext context) +431
   System.Web.Mvc.ControllerActionInvoker.InvokeActionResult(ControllerContext controllerContext, ActionResult actionResult) +39
   System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList`1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult) +116
   System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList`1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult) +529
   System.Web.Mvc.ControllerActionInvoker.InvokeActionResultWithFilters(ControllerContext controllerContext, IList`1 filters, ActionResult actionResult) +106
   System.Web.Mvc.Async.<>c__DisplayClass2b.<BeginInvokeAction>b__1c() +321
   System.Web.Mvc.Async.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult) +185
   System.Web.Mvc.Async.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult) +42
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +133
   System.Web.Mvc.Async.AsyncResultWrapper.End(IAsyncResult asyncResult, Object tag) +56
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +40
   System.Web.Mvc.Controller.<BeginExecuteCore>b__1d(IAsyncResult asyncResult, ExecuteCoreState innerState) +34
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +70
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +133
   System.Web.Mvc.Async.AsyncResultWrapper.End(IAsyncResult asyncResult, Object tag) +56
   System.Web.Mvc.Async.AsyncResultWrapper.End(IAsyncResult asyncResult, Object tag) +37
   System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +44
   System.Web.Mvc.Controller.<BeginExecute>b__15(IAsyncResult asyncResult, Controller controller) +39
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +62
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +133
   System.Web.Mvc.Async.AsyncResultWrapper.End(IAsyncResult asyncResult, Object tag) +56
   System.Web.Mvc.Async.AsyncResultWrapper.End(IAsyncResult asyncResult, Object tag) +37
   System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) +39
   System.Web.Mvc.Controller.System.Web.Mvc.Async.IAsyncController.EndExecute(IAsyncResult asyncResult) +39
   System.Web.Mvc.MvcHandler.<BeginProcessRequest>b__5(IAsyncResult asyncResult, ProcessRequestState innerState) +39
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +70
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +133
   System.Web.Mvc.Async.AsyncResultWrapper.End(IAsyncResult asyncResult, Object tag) +56
   System.Web.Mvc.Async.AsyncResultWrapper.End(IAsyncResult asyncResult, Object tag) +37
   System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +40
   System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) +38
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +9644037
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155

>I'm using a smal Table with a decimal not required.

>This results through EFramework in a decimal? (means nullable)

>i created 10.000 rows in DBTable with decimals set like '5.32'

>I pass my Table as IQueryable<tablename> and use DataSourceUrl into another decorated action

> The DataSourceUrl is async await

so far so good, it works like expected without that field, but as soon as i set the column i see the error above.

To be complete:

here's my View Data:

@(Html.Infragistics()

.Grid(Model)

.AutoGenerateColumns(false)

.Columns(column =>

{

column.For(x => x.ID).HeaderText("ID");

column.For(x => x.Interpret).HeaderText("Interpret");

column.For(x => x.Release).HeaderText("Release");

column.For(x => x.Owned).HeaderText("Owned");

column.For(x => x.SongCount).HeaderText("SongCount");

column.For(x => x.Laenge).HeaderText("Laenge");

})

.Features(f =>

{

f.RowSelectors()

.EnableCheckBoxes(false);

f.Selection()

.MultipleSelection(true)

.Mode(SelectionMode.Row);

 

f.Filtering()

.FilterDialogContainment("window")

.Mode(FilterMode.Advanced)

.AdvancedModeEditorsVisible(false);

f.Sorting()

.Mode(SortingMode.Multiple)

.SortingDialogContainment("window");

f.Resizing();

f.Tooltips()

.Visibility(TooltipsVisibility.Always)

.Style(TooltipsStyle.Popover);

f.ColumnMoving()

.ColumnMovingDialogContainment("window")

.HideHeaderContentsDuringDrag(true);

f.GroupBy()

.GroupByDialogContainment("window");

f.Hiding()

.ColumnChooserContainment("window");

f.Paging()

.PageSize(25);

})

.DataSourceUrl(Url.Action("GetRemoteData"))

.DataBind()

.Render())

And here Comes my Controller

// GET: Album/Albums

public ActionResult Index()

{

ViewBag.page = Session["pageidx"];

ViewBag.pageSize = Session["pagesize"];

ViewBag.selection = Session["selection"];

IQueryable<M.Album_Data> myData = db.Album_Data.OrderBy(album => album.ID).AsQueryable();

return View(myData);

}

[GridDataSourceAction]

public async Task<ActionResult> GetRemoteData()

{

List<M.Album_Data> myData = await db.Album_Data.ToListAsync();

return View(myData.AsQueryable());

}

My Browser and OS is in German language

Pleas help me to Display that field.

Many Thanks

Dominic

Parents Reply Children
No Data