Loading

Insert data from sqlserver2005 to excel

gokilavasan m

14y1.6k.NET

Hi ,

I want to Insert data from SqlServer to Excel using visual studio web application(using c# language) and sqlserver 2005.In my sqlserver,I have stock table with the columns.the stock table rows increased every day depending upon stock items.I want to give startdate and enddate control in web app.when i click the submit button means it will show the records in excel.what can i do.please help me.

Thanks&Regards,

Gokilavasan.M

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Santhosh Kumar Jayaraman14y ago
Accepted answer
What u have to do is write a stored procedure to pull data from the table with 2 parameters and fill it in datatable.
Then you can export to excel easily.
Refer this article to know how to export datatable to excel.

http://www.c-sharpcorner.com/UploadFile/1a81c5/export-datatable-to-excel-with-formatting-in-C-Sharp/