[Solved] Grid initial Load - custom columns

[orim]

Hi,
i am coding in VB:NET. I need to load a Grid from SERVERBINDING. No strongly type view.

View (code)

<%: Html.Telerik.Grid(Of TestModels.RequestQueue)("GridRequests").Name("GridRequests")%>

Controller (code this works)

 Function RequestsByLogin() As ActionResult
 
            'Initial load for Telerik Grid
            ViewData("GridRequests") = a4gContext.RequestQueue.ToList
                                        
 
            Return PartialView()
 
        End Function


Controller (code does not work, Grid shows no Data, want to request only 4 columns)
 Function RequestsByLogin() As ActionResult
 
            'Initial load for Telerik Grid
            ViewData("GridRequests") =  (From req In a4gContext.RequestQueue
                    Where req.CreatedUser = User.Identity.Name
                    Select req.RequestGuid, req.Status, req.CTI, req.CreatedDate).ToList                                        
 
            Return PartialView()
 
        End Function

Whats the problem ? 

[Daniel]

Hello,

You should to create a strongly typed ViewModel in the projection with the needed properties instead  
of an anonymous type and specify the type to the Grid in this scenario e.g.

Html.Telerik.Grid(Of TestModels.RequestQueueViewModel)("GridRequests").Name("GridRequests")

ViewData("GridRequests") = (From req In a4gContext.RequestQueue
                  Where req.CreatedUser = User.Identity.Name
                  Select New RequestQueueViewModel With {.RequestGuid = req.RequestGuid, .Status = req.Status,.CTI = req.CTI,.CreatedDate = req.CreatedDate).ToList

The alternative is not to use projection and specify the Grid columns so that only the four properties are displayed.

Kind regards,
Daniel
the Telerik team