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

http handler to export data to excel in jquery

Answers (3)