http handler to export data to excel in jquery

Hey Neeraj,

 

I had created an article where data is send from Sql Server to Excel:

 

http://www.c-sharpcorner.com/UploadFile/cd7c2e/export-sql-data-to-excel-using-Asp-Net/

 

and as you said that you want to use jquery and ajax for that you can use WebAPI/WebService and then can call it from AJAX, calling an API is very simple and easy.

 e.g. 

1. jQuery.ajax({
2. type: 'POST',
3. contentType: "application/json; charset=utf-8",
4. url: 'WebService1.asmx/getCityData',
5. data: "{'stateName':'" + stateName + "'}",
6. dataType: 'JSON',
7. success: function (response) {
8. StateCityChart(response);
9. return false;
10. },
11. error: function (er, sw, sq) {
    
12. //alert("Error occured in application");
13. }

 

 http://www.c-sharpcorner.com/UploadFile/cd7c2e/dynamic-chart-creation-using-jquerygoogle-charts/

 

You can check this article to check How I had called the WEB Service