Grid UrlAdaptor datasource and update

And, I want to perform CRUD actions on that grid.

Thank!

Bernard.

Hi Bernard, 

 

Thanks for contacting Syncfusion support. 

 

We have analyzed your query and We suggest you to refer to the below documentations to bind data to Grid using UrlAdaptor. 

 

Documentations :  

https://ej2.syncfusion.com/aspnetcore/documentation/grid/data-binding/?no-cache=1#handling-on-demand-grid-actions 

https://ej2.syncfusion.com/aspnetcore/documentation/grid/edit/#persisting-data-in-server 

https://ej2.syncfusion.com/aspnetcore/documentation/grid/data-binding/#sending-additional-parameters-to-the-server 

 

As we could see that you are using ASP.NET Core application. We suggest you to refer to the below general documentation link on linq to sql, 

General Link : https://stackoverflow.com/questions/51671408/linq-to-sql-tools-how-to-use-it-with-asp-net-core-2-1-project 

 

Please refer the below code example, 

 

[index.cshtml]        <ejs-grid id="Grid" toolbar="@(new List<string>() {"ExcelExport", "Add", "Update", "Cancel" })">          <e-data-manager url="/Home/UrlDatasource/" updateUrl="/Home/Update/" insertUrl="/Home/Insert/" removeUrl="/Home/Delete/" adaptor="UrlAdaptor" crossdomain="true"></e-data-manager>          <e-grid-editsettings allowEditing="true" allowAdding="true"></e-grid-editsettings>          ...     </ejs-grid>    [HomeController.cs]    public class HomeController : Controller  {          private NORTHWNDContext _context;          public HomeController(NORTHWNDContext context)          {              _context = context;          }            public IActionResult UrlDataSource([FromBody]DataManagerRequest dm)          {              IEnumerable DataSource = _context.Orders.Take(100).ToList();              var count = _context.Orders.AsQueryable().Count();              DataOperations operation = new DataOperations();              if (dm.Where != null && dm.Where.Count > 0) //Filtering              {                  DataSource = operation.PerformFiltering(DataSource, dm.Where, dm.Where[0].Operator);              }              if (dm.Skip != 0)              {                  DataSource = operation.PerformSkip(DataSource, dm.Skip);   //Paging              }              if (dm.Take != 0)              {                  DataSource = operation.PerformTake(DataSource, dm.Take);              }              return dm.RequiresCounts ? Json(new { result = DataSource, count = count }) : Json(DataSource);           }          public ActionResult Insert([FromBody]EditParams value)          {              var datas = _context;             datas.Orders.Add(value.value);              datas.SaveChanges();              return Json(value);          }          public ActionResult Update([FromBody]EditParams value)          {              var db = _context;              db.Entry(value.value).State = EntityState.Modified;              db.SaveChanges();              return Json(value);          }          public ActionResult Delete([FromBody]EditParams value)          {              var db = _context;              Orders order = db.Orders.Where(c => c.OrderID == Convert.ToInt32(value.key)).FirstOrDefault();              db.Orders.Remove(order);              db.SaveChanges();              return Json(order);          }  }

 

 

Please get back to us if you need further assistance. 

 

Regards, 

Pavithra S. 

and thank you for the answer. Please, can you check my other post about UrlAdaptor?

https://www.syncfusion.com/forums/141644/empty-grid-with-urladaptor

Thanks!

Bernard.

Hi Bernard, 

 

We have checked the forum #141644 and to render the Grid data, column’s field name and the data source field name should be same. Due to serialization problem, your datasource field name is changed to camel case(firmaId) and so there is a mismatch in the column’s field which is in pascal case(FirmaId). This is why you don’t have data in Grid.  

 

To overcome this serialization problem, we suggest you to use the below solution in the Startup.cs file. 

 

[startup.cs] 

public void ConfigureServices(IServiceCollection services)          {              // Add framework services.              services.AddMvc().AddJsonOptions(options =>              {                  options.SerializerSettings.ContractResolver = new Newtonsoft.Json.Serialization.DefaultContractResolver();              });          }

 

 

Please get back to us if you need further assistance. 

 

Regards, 

Pavithra S. 

I tried your solution with startup.cs and now I have my grid with rendered data in it, and it is ok. But everytime when I try tu update one of the rows, the value is null, like this:

What type is the posted object on NormalUpdate if my GridDatasource is some linq to sql query?

I attached my complete solution and my database. Login is admin@mail.com / Lozinka1.1

Thanks!

Regards,

Bernard.

Bernard.

Hi Bernard, 

 

Thanks for contacting Syncfusion support. 

 

We have analyzed the screenshot and the codes you have shared with us. We could see that you have not handled CRUD model class. You need to define CRUDModel(as generic) like below code example. Please find the below code example and sample for your reference. 

 

public ActionResult Update([FromBody]CRUDModel<OrdersDetails> value)          {              var ord = value.value;              ...              return Json(value.value);          }            public class CRUDModel<T> where T : class          {                public T value { get; set; }          }

 

 

Sample : http://www.syncfusion.com/downloads/support/directtrac/general/ze/RemoteSaveAdaptor1019811572 

 

Please refer the screenshot below, 

 

 

 

Please get back to us if you need further assistance. 

 

Regards, 

Pavithra S.