Home arrow XML arrow Page 3 - Extracting XML content from an XML file from within SQL Server 2000 using Managed Code
XML

Extracting XML content from an XML file from within SQL Server 2000 using Managed Code


This article explains how to develop a .NET based component, which can extract XML content from an XML file and return the same to SQL Server 2000 with the help of T-SQL (Transact-SQL).

Author Info:
By: Jagadish Chaterjee
Rating: 5 stars5 stars5 stars5 stars5 stars / 6
November 29, 2005
TABLE OF CONTENTS:
  1. · Extracting XML content from an XML file from within SQL Server 2000 using Managed Code
  2. · Developing the .NET component
  3. · Deploying the .NET component
  4. · Testing the .NET component from within SQL Server 2000
  5. · Creating a stored function to call the .NET component and testing it

print this article
SEARCH DEVARTICLES

Extracting XML content from an XML file from within SQL Server 2000 using Managed Code - Deploying the .NET component
(Page 3 of 5 )

In the previous section, you just completed developing the component.  Now you need to register as COM component and also deploy into GAC cache.  Proceed with the following steps to do this:

  • If you didn’t open your Visual Studio command prompt, do it by going to Start -> Programs -> Microsoft Visual Studio.NET 2003 -> Visual Studio.NET tools -> Visual Studio.NET 2003 Command Prompt.
  • Go to the “bin” folder of your project folder (which is “Utility”), using the command prompt.
  • Type the following command to register the assembly as COM component:

Regasm /tlb:Utility Utility.dll

  • After receiving a successful message, again type the following command to get the component registered within GAC cache.

gacutil /I Utility.dll

The screen should look something like the following (Fig1):

That completes your deployment. 

In case you want to unregister the component (say you may want to modify the code after successful registration), you can use the following commands (separately) to do the same (from the same bin folder):

gacutil /u Utility
regasm /unregister Utility.dll


blog comments powered by Disqus
XML ARTICLES

- Open XML Finally Supported by MS Office
- XML Features Added to Two Systems
- Using Regions with XSL Formatting Objects
- Using XSL Formatting Objects
- More Schematron Features
- Schematron Patterns and Validation
- Using Schematron
- Datatypes and More in RELAX NG
- Providing Options in RELAX NG
- An Introduction to RELAX NG
- Path, Predicates, and XQuery
- Using Predicates with XQuery
- Navigating Input Documents Using Paths
- XML Basics
- Introduction to XPath

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 
Support 

Developer Shed Affiliates

 




© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials