Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

asp.net 2.0 c#

Posted on 2007-09-28
2
Medium Priority
?
2,080 Views
Last Modified: 2013-11-07
Asp.net 2.0 c# I want to allow my user to upload their excel sheet from the website to my server, and also automatically export the data from excel to my database. Let say that the columns from the excel and database are exactly the same. Is that a way to do it in asp.net ? or any dlls will help for this?
0
Comment
Question by:riskyricky1972
2 Comments
 
LVL 21

Expert Comment

by:surajguptha
ID: 19982823
0
 
LVL 14

Accepted Solution

by:
raja_ind82 earned 2000 total points
ID: 19984164
1) with the same method u can modify it and add the concept of bulk insert,
http://msdn2.microsoft.com/en-us/library/system.data.common.dataadapter.update(vs.71).aspx

2) Have a look at DTS (data transformation services) of SQL server .. have a look at this link www.sqldts.com for code samples and explanation on what can be acheived using DTS ..

3) The file will have to be on the server to read it.  What we are doing is this.  Upload the file.  Name is something specific to the user.  Use code like this link here
http://www.aspfree.com/c/a/ASP.NET-Code/Read-Excel-files-from-ASPNET/
http://www.dotnetjohn.com/articles.aspx?articleid=54
Read the data into a data set.

Regards,
M.Raja
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question