I am new to jQuery and the IgniteUI controls. Is it possible to display data from a SQL Server database in igGrid and igDataChart, etc. without using MVC? I just want to return a standard datatable...or possibly XML...
Any code samples would be greatly appreciated. Thank you!
Hello Chris,
Thank you for posting in our community.
The IgniteUI™ grid, or igGrid™, is a client-side grid control built entirely with JavaScript, HTML and CSS. The client-only nature of the control makes the grid agnostic to server-side technologies allowing seamless interaction with applications built in PHP, Ruby on Rails®, Java™, Python™, Microsoft® ASP.NET™ and more.
I believe you will find the following article from our documentation (igGrid/igDataspurce Architecture Overview) helpful:
http://help.infragistics.com/doc/jQuery/2014.2/CLR4.0/?page=igGrid_igDataSource_Architecture_Overview.html
Please let me know if you need any further assistance with this matter.
Please let me know if you have any additional questions regarding this matter.
Hello Vasya,
I hope you don't mind my following up on Chris' question. I am a little confused by your saying that the igGrid is client-side. In the end, even server-side grids like Telerik's RadGrid are served to the browser as HTML, JavaScript, and CSS.
It seems the difference is where the grid's data source resides. With the igGrid, the data source is also on the client side and has to be filled either locally or by a call to a web service. The igDataSource component required by igGrid manages the calls needed to refresh the client data store, and the grid itself just handles events and display.
With the older-style RadGrid (which is designed for now politically incorrect web forms), the grid is bound directly to a server-side data source like SQL Server, and client-side paging is accomplished via Ajax calls. There is no need for a web service between the grid and the database with this older architecture.
Please correct me if I have any of this wrong. Please also add anything you can to compare the architectures of grids like RadGrid and igGrid.
Thank you,
Jeffrey Roughgarden