http handler to export data to excel in jquery

Question

how to export data to excel using database  jquery ajax call and http handler

neeraj gandhi · Answer

thank you for reply. but here You are using web service but i am using httpHandler so can i get using http handler

Anubhav Chaudhary · Answer

If you still face any problem then let me know.

Anubhav Chaudhary · Answer

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. jQuery.ajax({ type: 'POST'  contentType: application/json; charset=utf-8  url: 'WebService1.asmx/getCityData'  data: {'stateName':' + stateName + '}  dataType: 'JSON'  success: function (response) { StateCityChart(response); return false ; } error: function (er sw sq) { //alert(Error occured in application); } 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