e

Question

I'm using ASP .NET Core and Syncfusion.EJ2. I added the dependency of Syncfusion.EJ2 with NuGet, I added @addTagHelper "*, Syncfusion.EJ2" in _ViewImports.cshtml, I added script manager , , in _layout.cshtml and I converted my grid to use Syncfusion 2 like this:

This is what I have on codebehind: the parameter "id" is sent from another page and it has values in debuger, also ViewBag.DataSource receives values : public IActionResult SalesFulfillmentFileContent(string id) { if (!String.IsNullOrEmpty(id)) { var salesFileContentLines = _salesContentFilesStorage.GetSalesFileContentLines(id); ViewBag.DataSource = salesFileContentLines; } return View(); }The grid isn't created, it looks like in the attached image:

Amalia Ipatiov · Answer

I found that if I remove e-grid-editsettings and e-datamanager , the grid show data in the grid. But I need the Update action in the grid . On controller I have the actions methods:

public IActionResult SalesFulfillmentFileContent(string id)

{

if (!String.IsNullOrEmpty(id))

{

var salesFileContentLines = _salesContentFilesStorage.GetSalesFileContentLines(id);

ViewBag.datasource = salesFileContentLines;

}

return View();

}

[HttpPut]

public ActionResult Update(Syncfusion.EJ2.Grids.Grid detailsGrid, string id)

{

.......

return View();

}

Dhivya Rajendran · Answer

Hi Amalia, Thanks for using Syncfusion Products, We have analyzed your query, and we suspect that you have missed to mention the url property in your sample so that data is not displayed in grid. By default, data are fetched from remote data and bound to the grid using url property of DataManager and CRUD operations are performed by using URL mentioned in the updateUrl property. Kindly refer the below code snippet and documentation link for more information about URL Adaptor and updateUrl.

. . . . . .

Demo link: URL Adaptor sample : https://aspdotnetcore.syncfusion.com/Grid/UrlAdaptor#/material Documentation Link: URL Adaptor : http://ej2.syncfusion.com/16.1.24/aspnet/documentation/grid/edit.html?syntax=tag#url-adaptor Update Record : http://ej2.syncfusion.com/16.1.24/aspnet/documentation/grid/edit.html?syntax=tag#update-record If we have misunderstood your query could you please share more details of your query or could you please share issue reproducible sample that will be helpful for us to provide a better solution as early as possible. Regards,R.Dhivya

Amalia Ipatiov · Answer

Hello,Thanks for the reply, but it's the same behaivor even if I added  the URL property as you have recommended:   where Sales is the directory. In the Controller , this is the UrlDatasource method: public IActionResult UrlDatasource([FromBody]Data dm, string id)        {            //var id = HttpContext.Request.Query["id"].ToString();            IList salesFileContentLines = null;            TempData["ID"] = id;            ViewBag.ParamID = id;            if (TempData["BlobName"] != null)            {                salesFileContentLines = _salesContentFilesStorage.GetSalesFileContentLines(TempData["BlobName"].ToString());            }            else if (!String.IsNullOrEmpty(id))            {                salesFileContentLines = _salesContentFilesStorage.GetSalesFileContentLines(id);            }            if (salesFileContentLines != null)            {                int count = salesFileContentLines.Count;                var returnResult = dm.requiresCounts ? Json(new { result = salesFileContentLines.Skip(dm.skip).Take(dm.take).ToList(), count = count }) : Json(salesFileContentLines);                return returnResult;            }            else            {                return null;            }        }public class Data        {            public bool requiresCounts { get; set; }            public int skip { get; set; }            public int take { get; set; }        }

Amalia Ipatiov · Answer

I created a blank project using Syncfusion 2 with the grid and controller that will manage the grid.

- In the layout page I added the script manager and the reference to the syncfusion scripts: <script src="https://cdn.syncfusion.com/ej2/dist/ej2.min.js"></script>;

- in _ViewImports I added @addTagHelper "*, Syncfusion.EJ2", and the packages were included with NuGet.

I attached the project. Can you please review it and tell me what it's wrong?

Attachment: Syncfusion2Demo_deea0a62.zip

Dhivya Rajendran · Answer

Hi Amalia, We have analyzed and validated your sample. In the above sample shows 404 error because the url path is not referred the controller UrlDatasource method so that the data is not rendered in Grid. Here I have mentioned the code snippet and modified sample link. . . . . .

. . . . .

Modified sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/Syncfusion2DemoModified-400791495 Regards,R.Dhivya

Amalia Ipatiov · Answer

Thanks for the review. My problem is partial resolved. Now my demo app that you review it is working, but if I return to my real project and I add the following data manager the rows from grid isn't ok rendered. In the debuger I checked and I have the rows in the Json Result but the rows from the grid are displayed empty. I don't have any other css styles.

<e-datamanager url="/Sales/[email protected]" adaptor="UrlAdaptor" updateUrl="/Sales/Update"></e-datamanager>

Amalia Ipatiov · Answer

I solved the second issue with empty rows from the grid. Now the rows are displayed fine but this ssecond issue was generated by the columns field names that in my page , they started with uppercase letter, such as CustomerName, ArticleCode, like I saw in the documentation. After I changed the column names to start with lowercase letters(JSON format) the issue was solved.

This means that your documentation is confusing because on all the resources , the fields names appears with uppercase letters, which is wrong!

https://ej2.syncfusion.com/16.1.24/aspnet/documentation/grid/how-to.html?syntax=tag#display-custom-tooltip-for-columns-in-grid

Dhivya Rajendran · Answer

Hi Amalia , 
Sorry for the inconvenience caused.We have analyzed your problem this is because of the JSON serialize setting no longer default to the DefaultContractResolver instead  it defaults to the CamelCasePropertyNamesContractResolver. You can use the following code in your Startup.cs file to resolve your problem and we have provide a sample for your reference. 




  public void ConfigureServices(IServiceCollection services) 
        { 
            services.AddMvc(). 
            AddJsonOptions(options => 
                { 
                    // JSON serialization not defaulting to default? 
                    options.SerializerSettings.ContractResolver = new Newtonsoft.Json.Serialization.DefaultContractResolver(); 
                }); 
        } 

Sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/SyncfusionDemonew411067878 

Regards,R.Dhivya

Amalia Ipatiov · Answer

Thanks, yes this solution  solved my issue  and now in the grid I added the column with uppercase letters. Please update the documentation, I spent 1 week to solve these issues.

Dhivya Rajendran · Answer

Hi Amalia,Sorry for the inconvenience caused , 
we will update the documentation which is in live. 
Regards,R.Dhivya

Mihai Moisei · Answer

Hi Amalia,Sorry for the inconvenience caused , 
we will update the documentation which is in live. 
Regards,R.Dhivya How can  localize  this grid ?

Isuriya Rajan · Answer

Hi Amalia, We can apply the localization using the locale property. Please refer the below code example

Refer the sample for your reference: Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/CORE-L~1-235126472.zip We will include this in our documentation link and will release in any one of the release. Regards Isuriya R

Mihai Moisei · Answer

Thanks very much. Can extend this sample with a CRUD on mssql  database ?

Mohammed Farook J · Answer

Hi Amalia, Based on your request , we have created a sample with ‘CRUD’ operation with “UrlAdaptor” Grid. Please find the code example. [index.cshtml]

[controller] public class HomeController : Controller { public IActionResult Index() { return View(); } public IActionResult UrlDatasource([FromBody]Data dm) { var order = OrdersDetails.GetAllRecords(); var Data = order.ToList(); int count = order.Count(); return dm.requiresCounts ? Json(new { result = Data.Skip(dm.skip).Take(dm.take), count = count }) : Json(Data); } public ActionResult Update([FromBody]CRUDModel value) { var ord = value.value; OrdersDetails val = OrdersDetails.GetAllRecords().Where(or => or.OrderID == ord.OrderID).FirstOrDefault(); val.OrderID = ord.OrderID; val.EmployeeID = ord.EmployeeID; val.CustomerID = ord.CustomerID; val.Freight = ord.Freight; val.OrderDate = ord.OrderDate; val.ShipCity = ord.ShipCity; return Json(value.value); } //insert the record public ActionResult Insert([FromBody]CRUDModel value) { OrdersDetails.GetAllRecords().Insert(0, value.value); return Json(value.value); } //Delete the record public ActionResult CellEditDelete([FromBody]CRUDModel value) { OrdersDetails.GetAllRecords().Remove(OrdersDetails.GetAllRecords().Where(or => or.OrderID == int.Parse(value.key.ToString())).FirstOrDefault()); return Json(value); } Please find the sample for your reference Sample : http://www.syncfusion.com/downloads/support/directtrac/general/ze/UrlAdaptorSample1307827815.zip Regards, J.Mohammed Farook