How to export all records(1000) from Datagrid in asp.net

Question

Hi All,

 

I need a help, actually i am trying to get all records(1000) from datagrid to excel. But i am not able to do that. Many of the examples are in Gridview to export data from Gridview to excel, but my requirement is export all records(1000) from datagrid to excel.

 

Can anyone please suggest how to complete that work.It would be very helpful.

 

 

 

Thanks,

 

Vamsi