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
The fix for development issue 214741 is available in the latest service release which can be downloaded from the My Keys and Downloads page.
Hi Martin,
thanks for information that we hit a issue.
- we try to use that field in our POCO/Data as duplicate with type string, might be more flexible than changing regional Settings.
I'll followup that case.
Greeez,
Hello Dominic,
The reason that you see this error is the German locale which formats the decimals with "," as a separator while the parser expects ".". I logged an internal issue with Development ID 214741 so that we can fix it in our codebase.
I also created a case on your behalf with number CAS-170133-S0M9S2, so that you can be notified when there is a resolution for the issue.
You can find your active cases under Account - Support Activity in our website. Select your ticket and go to Development Issues tab to view the status of related development issues.
As a temporary workaround I can suggest that you run the web application with a user which have English regional settings.
Best regards,Martin PavlovInfragistics, Inc.
I'm currently investigating it. Will write back.
I'm still out there.
Was the question taken note?