Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Imort Excel data to oracle database using ASP.NEt & C#

Posted on 2014-10-08
5
Medium Priority
?
2,128 Views
Last Modified: 2014-10-14
Hi Team,
I have one excel file.I want to import excel file to data base using asp.net and C#.

Database is oracle.

Can u plz send example code

Thanks In Advance
0
Comment
Question by:mannevenu26
5 Comments
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 40368121
You could do it easily if you have access to any of the GUI tools like SQL Developer or Toad

There are various examples on net with screenshots(on how to do this via tools) see one below for toad

http://www.c-sharpcorner.com/UploadFile/1326ef/upload-exceltxt-file-data-into-oracle-table-using-toad/

However, if you want to do it via ASP.NEt then refer to this post where in you have to place your table name and connection strings and you are good to go and use it on your own

http://forums.asp.net/post/5372020.aspx
0
 

Author Comment

by:mannevenu26
ID: 40368133
I think above is sql server database.Can you please post code for ORACLE database
0
 
LVL 12

Accepted Solution

by:
Ramkisan Jagtap earned 1500 total points
ID: 40368167
You can do it using Oracle data provider.
For reference check following link:
http://dotnetslackers.com/articles/ado_net/BulkOperationsUsingOracleDataProviderForNETODPNET.aspx

Download the Oracle Data Provider for .net:
http://www.oracle.com/technetwork/topics/dotnet/index-085163.html 

you can download the getting started sample[ODP.NET]:
http://www.oracle.com/technetwork/indexes/samplecode/dotnet-sample-522126.html
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40368200
I cannot provide a specific example as I've never gone from Excel to Oracle.

I have written code using OpenXML SDK:
http://msdn.microsoft.com/en-us/library/office/bb448854(v=office.15).aspx

That takes data from Oracle and inserts the data into an Excel 'template' that I have.

The OpenXML SDK allows you to work with native Office files quite easily.

I agree with the link above:  ODP.Net is the best way to use Oracle in .Net.

I've been using the new 12c Managed Driver for a little while and have been quite happy with it.  The bonus to using it is it doesn't require any Oracle client install like the regular ODP drivers.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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!
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Suggested Courses

886 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