ASP.NET SQLSERVER EXCEL

Posted by Srinathgb under ASP.NET on 7/6/2013 | Points: 10 | Views : 682 | Status : [Member] | Replies : 1
Hi Friends

I want to read sql server table data into excel sheet (using stored procedure) and should be able to edit the values and should be
able to use excel formula in the sheet and should update once save in excel and to be stored in database using stored procedure

I want to give excel interface to user but backend should be sql server and using asp.net code.

Does anybody has done similar req. what are the tips for the same.

Also suggest is it good practice.

Thanks in advance

Srinath




Responses

Posted by: Rimi1289 on: 7/8/2013 [Member] Starter | Points: 25

Up
0
Down
You can do this using Asp.Net "SqlBulkCopy" and its simple. This article can help you. Its written both in C# and Vb.Net.

http://www.encodedna.com/2013/01/asp.net-import-from-excel.htm

Srinathgb, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response