.NET
  Home arrow .NET arrow .NET Stored Proceedures: Reading Excel Fil...
ASP Free Forums 
.NET  
ASP  
ASP Code  
ASP.NET  
ASP.NET Code  
BrainDump  
C#  
Code Examples  
Database  
Database Code  
IIS  
Microsoft Access  
MS SQL Server  
Silverlight  
Visual Basic.NET  
Windows Scripting  
Windows Security  
XML  
Mobile Linux 
App Generation ROI 
IBM® developerWorks 
ASP Web Hosting  
ASP.NET Web Hosting 
Windows Web Hosting
 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
.NET

.NET Stored Proceedures: Reading Excel Files or Transferring SQL Server Tables into Oracle Tables
By: Jagadish Chaterjee
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 4 stars4 stars4 stars4 stars4 stars / 38
    2006-01-03

    Table of Contents:
  • .NET Stored Proceedures: Reading Excel Files or Transferring SQL Server Tables into Oracle Tables
  • Developing an Oracle based .NET CLR stored procedure using Visual Studio.NET
  • Understanding the .NET CLR Stored Procedure (working with Excel)
  • Deploying and testing Oracle based .NET CLR stored procedure using Visual Studio.NET
  • Understanding the .NET CLR Stored Procedure (working with SQL Server 2000 table)

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    .NET Stored Proceedures: Reading Excel Files or Transferring SQL Server Tables into Oracle Tables


    (Page 1 of 5 )

    In this article, I shall introduce you to developing a .NET based CLR stored procedure which can read a simple Excel file and transfer that information into an Oracle database using Visual Studio.NET. Once we have completed the stored procedure with the Excel file, we will further extend it with a SQL Server 2000 table.
    This article has two downloadable files associated with it. You can get them here and here.

    Getting prepared before developing the .NET CLR stored procedure

    I already introduced the subject of .NET based stored procedures in an Oracle database at ".NET CLR stored procedures within Oracle database: Another breaking revolution ."   If you are very new to this concept (or having trouble working with the Oracle wizard in this article), I suggest you go through that article before proceeding further.

    Before proceeding further with this article, make sure that all of the following software is properly installed and configured on your system:

    As we are trying to read an Excel file from the file system, the first need is to create a simple Excel file (in this article, I named the file “book1.xls”) with a few rows of information.  The most important issue to remember is that the file needs to reside at the Oracle database server, and not at the client (or with required shared permissions, if on network drive).

    As this is a demonstration, I simply worked with the table “emp” which relies on the SCOTT schema.  My entire source code focuses on the “SCOTT” schema.  I request you make the necessary changes to the source code, if you create (or modify) the table in a different schema.

    I assume that you already connected to the Oracle database using “Oracle Explorer” using Visual Studio.NET 2003.  If you are not familiar with “Oracle Explorer”, I request you refer to my article at “.NET CLR stored procedures within Oracle database: Another breaking revolution," linked above.

    Now we shall proceed to the next section, which deals with creating the stored procedure.

    More .NET Articles
    More By Jagadish Chaterjee


       · Now I contributed .NET stored procedure to read and transfer Excel files and SQL...
       · i've used your third page information to insert records from excel into oracle db,...
       · Even though, I could not get a proper solution for your problem, I can provide you...
       · Sorry for troubling...I think i found the rootcause - my memory control...
       · Hai,I am very happy that you could find the root of your problem. In fact, your...
       · Hi,I have used your code example to export data from an Excel spreadsheet and...
     

    .NET ARTICLES

    - Building Applications with Windows Workflow ...
    - Building the Data and Business Layers Using ...
    - The Transformed XML Explorer in MFC
    - List Control and Property Grid with the MFC ...
    - Font, Shell and Masked Edit Controls for MFC
    - Color, Link and Image Editor Controls for M...
    - New Controls for MFC
    - The Windows Ribbon Framework
    - Markup Language for the Ribbon Framework
    - Visually Upgrade Your MFC Project
    - New Features for the Statusbar in MFC
    - Working with the Statusbar in MFC
    - Iron Speed Design v60 Review
    - Binary and XML Serialization
    - Using CrystalReportViewer to Display Crystal...





    © 2003-2009 by Developer Shed. All rights reserved. DS Cluster 1 Hosted by Hostway
    For more Enterprise Application Development news, visit eWeek