1. Home
  2. Forum
  3. ASP.NET Core
  4. syncfusion tools greyed out

syncfusion tools greyed out

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

18 Replies
MS Manivannan Sundararajan Syncfusion Team January 3, 2018 12:19 PM UTC

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.


JI Jim January 5, 2018 07:03 PM UTC

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  

MS Manivannan Sundararajan Syncfusion Team January 8, 2018 12:42 PM UTC

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.NET

2. ASP.NET (Classic)

3. Windows Forms

4. WPF

5. Universal Windows Platform

As 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.


JI Jim January 8, 2018 05:50 PM UTC

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 

PK Prem Kumar Madhan Raj Syncfusion Team January 10, 2018 01:03 PM UTC

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.  

  
If this not meet your requirement please refer the document link of hierarchy grid.   
  
  
 
 
Regards, 
 
Prem Kumar. M

PN Preethi Nesakkan Gnanadurai Syncfusion Team January 11, 2018 04:29 AM UTC


Sent: Wednesday, January 10, 2018 4:44 PM

Subject: 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 


SE Sathyanarayanamoorthy Eswararao Syncfusion Team January 11, 2018 12:49 PM UTC

Hi Jim, 

We could not understand you requirement quite right. Please provide the following details. 

  1. You mentioned about scaffolded tables by this do you expect to edit the details of the particular row in a different view.
 
  1. 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.
 
  1. If possible share the complete code snippets of grid in your project.
 
  1. Share the Essential studio versions
 
The provided information will help us to provide solution as quickly as possible. 

Regards, 
Sathyanarayanamoorthy 


JI Jim January 11, 2018 04:09 PM UTC

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+<ExecuteAsync>d__27.MoveNext() in Index.cshtml at line 7+

<ej-grid id="HierarchyGrid" datasource="ViewBag.OrdersSource" allow-paging="true">

 

AspNetCore._Views_Bookings_Index_cshtml+<<ExecuteAsync>b__27_0>d.MoveNext() in Index.cshtml at line 13

 

<ej-grid query-string="OrderID" allow-paging="true" datasource="ViewBag.OrderItemsSource"> 

  • If possible share the complete code snippets of grid in your project.

  •  

    <ej-grid id="HierarchyGrid" datasource="ViewBag.OrdersSource" allow-paging="true">

            <e-columns>

                <e-column field="BookingID" header-text="Booking" text-align="Right" width="85"></e-column>

                <e-column field="OrderDate" header-text="Time" width="100"></e-column>

                <e-column field="Coverse"></e-column>

            </e-columns>

            <ej-grid query-string="OrderID" allow-paging="true" datasource="ViewBag.OrderItemsSource">

                <e-page-settings page-size="5"></e-page-settings>

                <e-columns>

                    <e-column field="OrderID" header-text="OrderID" text-align="Right" width="75"></e-column>

                    <e-column field="MenuItem" header-text="Item" width="100"></e-column>

                    <e-column field="MenuItemPrice" width="120"></e-column>

                </e-columns>

            </ej-grid>

        </ej-grid>

     

     

    I had also tried the following but that also failed

    <h2>Syncfusion Grid Test</h2>

    <ej-grid id="TestGrid" datasource="@ViewBag.BookingsSource" allow-paging="true" allow-resize-to-fit="true">

            <e-datamanager json="(IEnumerable<object>)ViewBag.BookingsSource" />

            <e-edit-settings allow-adding="true" allow-deleting="true" allow-editing="true"></e-edit-settings>

            <e-toolbar-settings show-toolbar="true" toolbar-items="@(new List<string>() {"add","edit","delete","cancel","update" })"></e-toolbar-settings>

        </ej-grid>
  • Share the Essential studio versions

15.4.0.20

 

Thanks,

 

Jim


SE Sathyanarayanamoorthy Eswararao Syncfusion Team January 12, 2018 02:39 PM UTC

Hi Jim, 

We have analyzed your query and found that you want to display the data for a particular column from other table. We have achieved your requirement using foreignkey column feature of grid. 

For example in the below sample we have displayed the FirstName values corresponding to  EmployeeID value from another table. 

Also we have used the hierarchy binding to bind the child grid and used the server side CRUD operations using Remotesave Adaptor. 


Refer the below help documentations. 




We have prepared a sample which can be downloaded from below location. 




Refer the code example below. 

 
<div id="ControlRegion"> 
    <ej-grid id="FlatGrid"   allow-paging="true"> 
 
        <e-datamanager id="myData" json="(IEnumerable<object>)ViewBag.datasource" adaptor="remoteSaveAdaptor" update-url="/Grid/Update"></e-datamanager> 
 
        <e-edit-settings allow-adding="true" allow-editing="true" allow-deleting="true"></e-edit-settings> 
        <e-toolbar-settings show-toolbar="true" toolbar-items='@new List<string> {"add","edit","update","cancel"}' /> 
        <e-columns> 
 
            …………………… 
 
            <e-column field="EmployeeID" header-text="FirstName" width="80" foreign-key-field="EmployeeID" foreign-key-value="FirstName" datasource="@ViewBag.dataSource2"></e-column> 
            
       ……………………….. 
 
        </e-columns> 
 
        <ej-grid query-string="EmployeeID" datasource="ViewBag.child"> 
            <e-columns> 
 
                ……………………….. 
 
           </e-columns> 
        </ej-grid> 
 
 
    </ej-grid> 
</div> 
 
 
 
 
    


Regards, 
Sathyanarayanamoorthy 



AP Ashwini Paranthaman Syncfusion Team January 16, 2018 04:43 AM UTC

From: Jim McKinlay 
Sent: Monday, January 15, 2018 7:42 AM
To: 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 


JI Jim January 18, 2018 04:02 PM UTC

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
 
            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 

SE Sathyanarayanamoorthy Eswararao Syncfusion Team January 19, 2018 02:05 PM UTC

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. 
 



Regards, 
Sathyanarayanamoorthy 



JI Jim January 19, 2018 03:18 PM UTC

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

SE Sathyanarayanamoorthy Eswararao Syncfusion Team January 22, 2018 12:14 PM UTC

Hi Jim, 

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

 
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 



AP Ashwini Paranthaman Syncfusion Team January 24, 2018 04:09 AM UTC

From: Jim McKinlay  
Sent: Tuesday, January 23, 2018 9:35 AM
To: 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 


SE Sathyanarayanamoorthy Eswararao Syncfusion Team January 31, 2018 06:23 PM UTC

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.  
 
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  


PG Pon Geetha A J Syncfusion Team February 1, 2018 11:54 AM UTC

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 


SE Sathyanarayanamoorthy Eswararao Syncfusion Team February 2, 2018 01:20 PM UTC

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. 



Please refer the below 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-edit-settings allow-adding="true" allow-editing="true" allow-deleting="true"></e-edit-settings> 
    <e-columns> 
 
               --------------------------- 
 
        <e-column field="EmployeeID" header-text="First Name" width="80" foreign-key-field="EmployeeID" foreign-key-value="FirstName" datasource="@ViewBag.datasource1"></e-column> 
 
-------------------- 
            </e-columns> 
</ej-grid> 
 
[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 



Loader.
Up arrow icon