How to Autometically Fire the Trigger for Export toExcel.

Question

Hi All This is Balesh Rani. I need Your help. I have a task export the Grid View data to excel according to the user date and time Schedule.

Balesh Rani · Answer

Hi Praveen Thanks for response Actually I bind the data into grid through Api I not used the database.Please guide me for this.

Praveen K · Answer

Hi Balesh Can u explain ur requirement briefly ? If your gridview data comes from the database table  then we can export the data into excel/ other formats using EXEC master..xp_cmdshell command from database (sql server ) and we can automate this using sql server Job. refer the below link to export using jquery http://www.c-sharpcorner.com/Blogs/49578/export-to-excel-using-jquery.aspx