ASP.NET SQLSERVER EXCEL

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

Latest Posts