We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

help to connect it with local data

Thread ID:





129795 Apr 4,2017 07:52 AM UTC Apr 5,2017 07:31 AM UTC ASP.NET Core 1
Tags: Grid
Asked On April 4, 2017 08:01 AM UTC

Hi,I would like to use Visual studio 2017 withASP.net Core 1.1, Entity Framework Core 1.1*scaffolding controllersand SYNCFUSION GRID,I managed to bind grid to remote odata as described here https://help.syncfusion.com/aspnet-core/grid/getting-startedbut i would like your help to make it work with local data.The sample application with local data that i try to convert to Syncfusion/GRID etc can be downloaded from here.https://github.com/aspnet/Docs/tree/master/aspnetcore/data/ef-mvc/intro/samples/cu-finalDo you have a simple sample or you can create something very simple  for us so we can learn from that? A very good starting point for newbies coming from Ms lightswiitch like me would be a very small CRUD application with .net core1.1, efcore1.1, and Syncfusion best practices implemented for local data.Grid with filtering/search capabilities for one to many,one to one & many to many relations would solve all cases needed. thank you

Seeni Sakthi Kumar Seeni Raj [Syncfusion]
Replied On April 5, 2017 07:31 AM UTC

Hi Danil,  
Thanks for contacting Syncfusion Support.  
We could see you would like to perform the CRUD operations in Grid after populating them using the local data and perform the filtering and sorting operations in the Grid. We have prepared a sample with your requirement that can be downloaded from the following location. 
CRUD Operations in the Grid can be achieved using the certain adaptor support provided by the ejDataMananger which can be referred from the following Help Document. 
Among these adaptors, we have used removeSaveAdaptor to achieve your requirement which will bind local data to the Grid and serves the CRUD Urls for performing the editing/deleting/adding actions in the Grid. Refer to the following code example. 
<ej-grid id="Grid1" allow-sorting="true" allow-filtering="true" allow-paging="true"> 
    <e-datamanager json="ViewBag.order" insert-url="/Home/CellEditInsert" update-url="/Home/CellEditUpdate" remove-url="/Home/CellEditDelete" adaptor="remoteSaveAdaptor" /> 
    <e-edit-settings allow-adding="true" allow-deleting="true" allow-editing="true" />  
    <e-filter-settings filter-type="Menu" /> 
        <e-column field="ID" header-text="Employee ID" is-primary-key="true"></e-column> 
         . . .  
                    . .  
Please make a note that is-primary-key is necessary while performing editing operation in the Grid. To enable edit/add/delete operations in the Grid, you have to set the allow-editing, allow-adding and allow-deleting properties of the Grid e-edit-settings. Please refer to the following Help Documents. 
To enable the filtering and sorting properties in the Grid, you have to set the allow-sorting and allow-filtering properties of the Grid. Grid also provides several filtering types, which can be referred from the following Help Documents. 
Refer to the following ShowCase demos. 
Seeni Sakthi Kumar S. 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon