DataManager - SQL bindings?

Question

Hi All,Do you have any samples or pointers which would get me started on using the DataManager (in Vue) to query SQL directly, please, rather than via an http API?Even some documentation which shows me what methods get called and would need to be overridden maybe?Thank you!Miles

Thiyagu Subramani · Answer

Hi Miles, 

Thanks for your contacting Syncfusion support. 

Based on your query we suspect that you need to bind the SQL Server data in Grid using the DataManager. We have a knowledge base documentation to bind the SQL server data and find the documentation from the below link, 

KB Link : https://www.syncfusion.com/kb/11452/how-to-bind-sql-server-data-in-typescript-datagrid-using-sqlclient-data-provider 

Please check the above documentation and if we misunderstood your query please get back to with more details it will help us to provide the proper solution. 

Regards, 
Thiyagu S

Miles Benson · Answer

Hi Thiyagu,Thanks.  Yes, I found that example.  It's actually even more confusing - what's C# doing in there?  Can I do it in pure javascript?  Do I derive a custom class from UrlAdaptor? If so, is that documented somewhere?ThanksMiles

Prasanna Kumar Viswanathan · Answer

Hi Miles, 
 
Sorry for the late reply, 
 
Based on your query you need to handle the SQL query using DataManager. To handle the SQL query we need a C# to form the SQL Query string and retrieve the data from the database using SqlDataAdapter. And then, we process the query string and fill the result into DataSet. Then the DataSet will be converted into List and returned as result and count pair. 
 
The URL Adaptor is our in-built adaptor and we have an inbuilt server side (dataManager) classes to access the backend. For the DataManager classes you need to add the Syncfusion.EJ2.MVC5 Nuget package using the Nuget Package Manager.  
 
For more information please refer the below help document, 
 
https://ej2.syncfusion.com/aspnetmvc/documentation/grid/data-binding/#handling-on-demand-grid-actions 
 
In this we also the attached the documentation of Data Adaptors which will support the Syncfusion Grid. For more information please refer the below document, 
 
https://ej2.syncfusion.com/aspnetmvc/documentation/grid/data-binding/#data-binding 
 
Please check the above documentation and if still we misunderstood your query please get back to us with the below details, 
 
1. Share the complete grid rendering code and data that you have bounded to the Grid. 
 
2. Share the screenshot of an issue that you have faced while rendering the grid. 
 
Regards, 
Prasanna Kumar N.S.V