syncfusion tools greyed out

Question

Hi,I've run Toolbox installer, I've followed the guidance at https://www.syncfusion.com/kb/4324/how-to-resolve-the-toolbox-configuration-issue but in Toolbox/show all the Syncfusion Tools are greyed out. How can I resolve this?Thanks,Jim

Manivannan Sundararajan · Answer

Hi Jim,We are sorry for the inconvenience.We suspect that the reported issue occurred as the toolbox was not opened in the Designer page. If so, please open the designer and then open the Visual Studio toolbox. Now, Syncfusion controls will be enabled in toolbox. If you still face the reported issue, please share us the following details. It would be much helpful for us to analyze the reported issue. 1. Follow the steps suggested in the below KB article link and send us the zip file which consists of complete Syncfusion Installer logs generated by our tool. http://www.syncfusion.com/kb/2331  2. Syncfusion Essential Studio version you are using.3. Screen shot of the issue.4. Screen shot of the Visual Studio About window.Regards,Manivannan S.

Jim · Answer

Hi,I went back to a clean slat by uninstalling then reinstalling Syncfusion and VS2017 and used the Syncfusion ASP.NET Core Web  Application template so now I can use the controls, which is excellent since they are so effective, but nothing shows in the Toolbox. Since I can use the controls probably better to close this off. T hanks,Jim

Manivannan Sundararajan · Answer

Hi Jim,Thanks for the update.We are not providing toolbox support for ASP.NET Core platform. We are providing the toolbox support only for the following Essential Studio platforms. 1. ASP.NET2. ASP.NET (Classic)3. Windows Forms4. WPF5. Universal Windows PlatformAs you are using the Syncfusion ASP.NET Core template, you can continue using it. Please let us know if you face any issues.Regards,Manivannan S.

Jim · Answer

Hi Manivannan,Thanks for letting me know  that Toolbox does not apply to ASP.NET Core - disappointing that the documentation does not seem to make that clear.I'm finding it quite difficult to benefit from  the extensive documentation and I've spent a while looking for samples to implement a master and a detail grid where when one click on an entry in  the master (say Order) it would  then display  the order items in a separate grid.If you could point me at relevant documentation I would be grateful.Thanks,Jim

Prem Kumar Madhan Raj · Answer

Hi Jim, 
 
Sorry for the inconvenience, 
 
Query1: Toolbox does not apply to ASP.NET Core - disappointing that the documentation does not seem to make that clear. 

Answer:  Since there is no support for tool box provided by Microsoft in ASP.NET Core platform, we haven’t provided tool box support for our components in ASP.NET Core from our end. If this support is enabled in future, we will provide tool box support for Syncfusion ASP.NET Core components at our end. 
 
Query2: I'm finding it quite difficult to benefit from the extensive documentation and I've spent a while looking for samples to implement a master and a detail grid where when click on an entry in the master (say Order) it would then display the order items in a separate grid. 


Answer: We have checked the query and found that you need about master detail grid.  
  
Please refer the following documentation and online sample.  

Online Sample: http://mvc.syncfusion.com/demos/web/grid/masterdetails  
  
If this not meet your requirement please refer the document link of hierarchy grid.   
  
Documentation: https://help.syncfusion.com/aspnet-core/grid/hierarchy-grid  
  
Online sample link: http://mvc.syncfusion.com/demos/web/grid/hierarchygrid  
 
 
Regards, 
 Prem Kumar. M

Preethi Nesakkan Gnanadurai · Answer

Sent: Wednesday, January 10, 2018 4:44 PMSubject: RE: Syncfusion support community forum 135361, Syncfusion tools greyed out, has been updated. 

Hi Prem  
  
Thanks for this and, yes, I had tried to follow the hierarchy binding but kept running into invocation errors. I had also tried to grasp the complex binding guidance at Syncfusion Data Binding but couldn't make sense of it because it was not clear where "Designation" was defined. 
  
In the project I am trying to modify to use the Syncfusion grid I scaffolded tables and in the views it created related data showed up with the integer for a related ID being replaced by the characters found in that particular record e.g. an EmployeeID of 10 would show as Jones. The scaffolded view shows related data in the form @Html.DisplayFor(modelItem => item.CustomerNavigation.LastName) – I can’t see similar options in Syncfusion but if there could you point  me at them. 
  
If you could point me at (say) a Syncfusion sample rather like Contoso University sample created by Microsoft that would be helpful. 
  
Thanks, 
  
Jim

Sathyanarayanamoorthy Eswararao · Answer

Hi Jim, 

We could not understand you requirement quite right. Please provide the following details. 


You mentioned about scaffolded tables by this do you expect to edit the details of the particular row in a different view.
 

The hierarchy binding  can be used to create a grid with parent and child relationship in which the details of particular row can be viewed in the child grid. Do you want to bind the data to the grid using hierarchical binding.
 

If possible share the complete code snippets of grid in your project.
 

Share the Essential studio versions
 
The provided information will help us to provide solution as quickly as possible. 

Regards, 
Sathyanarayanamoorthy

Jim · Answer

Hi Sathyanarayanamoorthy, Thanks for this and the patience you and your colleagues show when dealing with pretty basic queries. I've tried to answer your points and I attach a zip of the project. You mentioned about scaffolded tables by this do you expect to edit the details of the particular row in a different view. My reference to scaffolded was to indicate that I had used the Entity Framework feature which looks at a model and then scaffolds controller/views to enable CRUD The hierarchy binding can be used to create a grid with parent and child relationship in which the details of particular row can be viewed in the child grid. Do you want to bind the data to the grid using hierarchical binding. Yes, and as you can see from the attached code I tried to do exactly that for Order/OrderItem but received errors as follows AspNetCore._Views_Bookings_Index_cshtml+d__27.MoveNext() in Index.cshtml at line 7+ AspNetCore._Views_Bookings_Index_cshtml+<b__27_0>d.MoveNext() in Index.cshtml at line 13 If possible share the complete code snippets of grid in your project.

I had also tried the following but that also failed

Syncfusion Grid Test

Share the Essential studio versions 15.4.0.20 Thanks, Jim

Sathyanarayanamoorthy Eswararao · Answer

Hi Jim,

We have analyzed your query and as per your requirement we have prepared a sample using Entity Framework using relational database to bind the data to the grid and the same can be found below.

Sample: http://www.syncfusion.com/downloads/support/directtrac/195768/ze/responsive925829840.zip

Please refer the following code example.

<ej-grid id="FlatGrid" allow-paging="true">

<e-datamanager json="ViewBag.datasource" update-url="/Home/NormalUpdate" insert-url="/Home/NormalInsert" remove-url="/Home/NormalDelete" adaptor="remoteSaveAdaptor" />

<e-columns>

<e-column field="OrderID" header-text="Order ID" text-align="Right" width="75" is-primary-key="true"></e-column>

---------------------

</e-columns>

</ej-grid>

[controller]

public class HomeController : Controller

{

private NORTHWNDContext _context;

public HomeController(NORTHWNDContext context)

{

_context = context;

}

public IActionResult Index()

{

ViewBag.datasource = _context.Orders.ToList();

return View();

}

public JsonResult NormalInsert([FromBody]CRUDModel<Orders> param)

{

----------------

}

public JsonResult NormalUpdate([FromBody]CRUDModel<Orders> param)

{

------------------

}

public JsonResult Remove([FromBody]CRUDModel<Orders> param)

{

----------------

}

Regards,

Sathyanarayanamoorthy

…………………… ………………………..

………………………..

Regards, Sathyanarayanamoorthy

Ashwini Paranthaman · Answer

From: Jim McKinlay 
Sent: Monday, January 15, 2018 7:42 AMTo: Syncfusion Support 
Subject: RE: Syncfusion support community forum 135361, syncfusion tools greyed out, has been updated. 

Hi Sathyanarayanamoorthy 
  
Many thanks for your response and the sample you provided but I still have a problem: your sample uses in-memory lists whereas my source is a database with various tables many of which are linked.  
  
With this statement  
          ViewBag.BookingsSource = _context.Booking.ToList(); 
I receive the error  
JsonSerializationException: Self referencing loop detected with type 'JimSyncTest.Models.Booking'. Path '[0].BookingType.Booking'. 
 
If I amend my Startup.s to the following as recommended here https://stackoverflow.com/questions/13510204/json-net-self-referencing-loop-detected 
            services.AddMvc() 
                .AddJsonOptions(options => options.SerializerSettings.ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore); 
I still get the error. 
  
If I use the following statement I can see 147 records returned but the view shows the column headers but states “No records to display”. 
            var DataSource1 = _context.Booking.AsNoTracking(); 
ViewBag.BookingsSource = DataSource1; 
  
Thanks in advance for any assistance. 
  
Jim

Jim · Answer

Hi,Could someone please respond to my query of 15 January i.e. I still have a problem: your sample uses in-memory lists whereas my source is a database with various tables many of which are linked.  
  
With this statement  
          ViewBag.BookingsSource = _context.Booking.ToList(); 
I receive the error  
JsonSerializationException: Self referencing loop detected with type 'JimSyncTest.Models.Booking'. Path '[0].BookingType.Booking'. 
 
If I amend my Startup.s to the following as recommended here https://stackoverflow.com/questions/13510204/json-net-self-referencing-loop-detected 
            services.AddMvc() 
                .AddJsonOptions(options => options.SerializerSettings.ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore); 
I still get the error. 
  
If I use the following statement I can see 147 records returned but the view shows the column headers but states “No records to display”. 
            var DataSource1 = _context.Booking.AsNoTracking(); 
ViewBag.BookingsSource = DataSource1; 
  
Thanks in advance for any assistance. 
  
Jim

Sathyanarayanamoorthy Eswararao · Answer

Hi Jim, 

Query: I receive the error JsonSerializationException: Self referencing loop detected with type 'JimSyncTest.Models.Booking'. Path '[0].BookingType.Booking'. 

We are binding  the data using ViewBag and accessing from the controller to client side for databinding . During this time serialization takes place and if the data is in a relational binding, the circular reference error will occur which is a common issue and It does not related to Syncfusion controls. So please refer the following stackoverflow articles for the Reference Looping errors. 
 
Link: https://github.com/aspnet/IISIntegration/issues/285 

https://stackoverflow.com/questions/11979637/what-does-referenceloophandling-ignore-in-newtonsoft-json-exactly-do 


Regards, 
Sathyanarayanamoorthy

Jim · Answer

Hi Sathyanarayanamoorthy,Sorry, I should have been more precise in my query. I understand this is not a Syncfusion grid error but a response to the use of JSON by Syncfusion when looking at a database table which has related tables. My only experience in accessing multiple related tables is through using the standard Visual Studio scaffold mechanism which happily copes with related tables and I was hoping Syncfusion would have a similar tool available. The only alternative seems to require writing code to extract data in its bare SQL form from two related tables, then making lists of each from those extracts, and then using those lists as separate data sources and that seems an awful lot of effort to achieve something which the Microsoft scaffold feature does in one pass.Thanks and sorry if it seemed I was criticising Syncfusion!Jim

Sathyanarayanamoorthy Eswararao · Answer

Hi Jim, 

We have analyzed your query and we suggest you to refer the following Knowledge Base document for this query. 

KB link: https://www.syncfusion.com/kb/6290/circular-reference-error-while-using-entity-framework-linq-2-sql 
 
In the above Knowledge Base document we have used select query to select the required tables. So we suggest you to use the above method which helps to solve the circular reference error issue. 
 
 
Regards, 
Sathyanarayanamoorthy

Ashwini Paranthaman · Answer

From: Jim McKinlay  
Sent: Tuesday, January 23, 2018 9:35 AMTo: Syncfusion Support Subject: RE: Syncfusion support community forum 135361, syncfusion tools greyed out, has been updated. 

Hi Sathyanarayanamoorthy, 
 
Thanks for this. I tried to follow your recommendation to use the select query but, as with many examples in Syncfusion documentation the explanation really not that helpful and falls a bit short e.g. the last line states “return Json(data, JsonRequestBehavior.AllowGet);” yet that generates the error “Json doesn’t exist in current context” with suggested fixes including “change JSON to MvcJsonOptionsreferences”. 
 
I’ve now spent an inordinate amount of time trying to get to grips with the fact that Syncfusion uses the JSON approach in the knowledge that it can never work unless additional steps are taken when it encounters relationships in a relationship database. 
 
If you could point me at a sample that shows how this can be done in an ASP.NET Core project that would be good otherwise I’ll just stay with the effective Microsoft approach which easily copes with relationships.  
 
Regards, 
 
Jim McKinlay

Sathyanarayanamoorthy Eswararao · Answer

Hi Jim,

We have analyzed your query and we suggest you to refer the following Knowledge Base document for this query.

KB link: https://www.syncfusion.com/kb/6290/circular-reference-error-while-using-entity-framework-linq-2-sql

In the above Knowledge Base document we have used select query to select the required tables. So we suggest you to use the above method which helps to solve the circular reference error issue.

Regards,

Sathyanarayanamoorthy

---------------------

[controller] public class HomeController : Controller { private NORTHWNDContext _context; public HomeController(NORTHWNDContext context) { _context = context; } public IActionResult Index() { ViewBag.datasource = _context.Orders.ToList(); return View(); } public JsonResult NormalInsert([FromBody]CRUDModel param) { ---------------- } public JsonResult NormalUpdate([FromBody]CRUDModel param) { ------------------ } public JsonResult Remove([FromBody]CRUDModel param) { ---------------- } } } Regards, Sathyanarayanamoorthy

Pon Geetha A J · Answer

Hi, 
  
Thanks for the sample but it generates the following error on my system: 
System.Data.SqlClient.SqlException 
  HResult=0x80131904 
  Message=The database 'C:\USERS\JIM\DOCUMENTS\VISUAL STUDIO 2017\PROJECTS\RESPONSIVE\WEBAPPLICATION1\DATA\NORTHWND.MDF' cannot be opened because it is version 852. This server supports version 782 and earlier. A downgrade path is not supported. 
  
I had a brief look at your code and it seemed as if you were displaying Orders in your grid rather than the relationship between orders and employees 
  
Jim

Sathyanarayanamoorthy Eswararao · Answer

Hi Jim, Sorry for the inconvenience caused. As per your requirement we have prepared a sample with grid using foreign key field for EmployeeID column which uses the relation between the Orders table and Employees table and the same can be found below. Sample http://www.syncfusion.com/downloads/support/directtrac/197568/ze/responsive-1586243187.zip Please refer the below code example.

--------------------------- --------------------

[controller] private NORTHWNDContext _context; public HomeController(NORTHWNDContext context) { _context = context; } public IActionResult Index() { ViewBag.datasource = _context.Orders.ToList(); ViewBag.datasource1 = _context.Employees.ToList(); return View(); } In the above code example grid uses the data from the orders table and the data for the EmployeeID column is displayed based on the Employees table. Regards, Sathyanarayanamoorthy