C# XML×¢ÊÍ
×÷Õß: J. Andrew Schafer
ÕâÆªÎÄÕ¼ÙÉèÄã¶Ô XML, XSLT, ºÍ C# ÊìϤ
ÏÂÔØÕâÆªÎÄÕµÄÔ´´úÂë: XMLC.exe (76KB)
ÒëÕß˵Ã÷£ºÕâÆªÎÄÕÂÊǺÜÔçÒÔǰ¾Í·¢±íÁË£¬ËüÌṩµÄÔ´´úÂëÊÇ»ùÓÚ VS.net ²âÊ԰棨RTM ºÍ Beta 2£©µÄ¡£
ÕªÒª
C# ÔÊÐí¿ª·¢ÈËÔ±ÔÚÔ´´úÂëÖвåÈëXML×¢ÊÍ£¬ÕâÔÚ¶àÈËÐ×÷¿ª·¢µÄʱºòÏÔµÃÌØ±ðÓÐÓᣠC#½âÎöÆ÷¿ÉÒÔ°Ñ´úÂëÎļþÖеÄÕâЩXML±ê¼ÇÌáÈ¡³öÀ´£¬²¢×÷½øÒ»²½µÄ´¦ÀíΪÍⲿÎĵµ¡£ ÕâÆªÎÄÕ½«Õ¹Ê¾ÈçºÎʹÓÃÕâЩXML×¢ÊÍ¡£×÷ÕßÑÝʾÁËÈçºÎÉú³É¹¤³Ì£¬ÈçºÎ°ÑXML×¢ÊÍÊä³öΪÓÐÓÃÎĵµ£¬ÈçºÎ°ÑÕâЩעÊÍת±äΪ°ïÖúÎļþ¡£ ÔÚÏîÄ¿¿ª·¢ÖУ¬ºÜ¶àÈ˲¢²»ÀÖÒâд·±ÔÓµÄÎĵµ¡£µ«ÊÇ£¬¿ª·¢×鳤ϣÍû´úÂë×¢Ê;¡¿ÉÄÜÏêϸ£»ÏîÄ¿¹æ»®ÈËԱϣÍû´úÂëÉè¼ÆÎĵµ¾¡¿ÉÄÜÏ꾡£»²âÊÔ¡¢¼ì²éÈËԱϣÍû¹¦ÄÜ˵Ã÷Ê龡¿ÉÄÜÏêϸµÈµÈ¡£ Èç¹ûÕâЩÎĵµ¶¼±»ÒªÇóдµÄ»°£¬±£³ÖËüÃÇͬ²½±È½øÐÐÒ»¸öÕ½ÒÛ»¹Í´¿à¡£
ΪºÎ²»°ÑÕâЩÐÅÏ¢±£´æÔÚÒ»¸öµØ·½ÄØ£¿£¿×îÃ÷ÏÔÏëµ½µÄµØ·½¾ÍÊÇ´úÂëµÄ×¢ÊÍÖУ»µ«ÊÇÄãºÜÄÑͨÀÀ³ÌÐò£¬²¢ÇÒÓÐЩÐèÒªÕâЩÎĵµµÄÈ˲¢²»¶®±àÂë¡£
ÕâÆªÎÄÕ½«Õ¹Ê¾ÈçºÎͨ¹ýʹÓÃXML×¢ÊÍÀ´½â¾öÕâЩÎÊÌâ¡£´úÂë×¢ÊÍ¡¢Óû§Êֲᡢ¿ª·¢ÈËÔ±Êֲᡢ²âÊԼƻ®µÈºÜ¶àÎĵµ¿ÉÒԺܷ½±ãµÄ´ÓXML×¢ÊÍÖлñµÃ¡£ÎÒ½«ÏÈÑÝʾÈçºÎ²åÈëXML×¢ÊÍ¡¢ÈçºÎ°ÑÕâЩXML×¢Ê͵¼³öΪÁíÒ»¸öÎĵµ¡£È»ºóÔÙÌÖÂÛÿ¸öXML±ê¼ÇµÄÒâ˼£¬ÒÔ¼°Ê¹ÓÃXMLºÍXSLÉú³É°ïÖúÎļþ¡£
XML ×¢ÊÍ
ËùÓеÄXML×¢ÊͶ¼ÔÚÈý¸öÏòǰµÄбÏßÖ®ºó(///)¡£Á½ÌõбÏß±íʾÊÇÒ»¸ö×¢ÊÍ£¬±àÒëÆ÷½«ºöÂÔºóÃæµÄÄÚÈÝ¡£ÈýÌõбÏ߸æËß±àÒëÆ÷£¬ºóÃæÊÇXML×¢ÊÍ£¬ÐèÒªÊʵ±µØ´¦Àí¡£
µ±¿ª·¢ÈËÔ±ÊäÈëÈý¸öÏòǰµÄбÏߺó£¬Microsoft Visual Studio .NET IDE ×Ô¶¯¼ì²éËüÊÇ·ñÔÚÀà»òÕßÀà³ÉÔ±µÄ¶¨ÒåµÄÇ°Ãæ¡£Èç¹ûÊǵϰ£¬Visual Studio .NET IDE ½«×Ô¶¯²åÈë×¢Êͱê¼Ç£¬¿ª·¢ÈËÔ±Ö»ÐèÒªÔö¼ÓЩ¶îÍâµÄ±ê¼ÇºÍÖµ¡£ÏÂÃæ¾ÍÊÇÔÚ³ÉÔ±º¯ÊýǰÔö¼ÓÈý¸öбÏߣ¬×Ô¶¯Ôö¼ÓµÄ×¢ÊÍ£º
/// <summary>
///
/// </summary>
/// <param name="strFilePath"></param>
public void LoadXMLfromFile(string strFilePath)
ÕâÀïǶÈëµÄ±ê¼Ç½ö½öÊÇVisual Studio .NET IDE µÄÒ»²¿·Ö±ê¼Ç£¬È»¶øÔÚIntelliSense for xmlÖУ¬²¢Ã»ÓаÑc#¹æ·¶ÖÐËùÓеıê¼ÇÁгöÀ´£¬ÒÅʧµÄ²¿·ÖÖ»ÄÜÓÃÊÖ¹¤²åÈë¡£
ÕâЩÊÖ¹¤±ê¼ÇÊǷdz£ÓÐÓõģ¬Èç¹ûÇ¡µ±µØÉèÖÃËûÃÇ£¬¶Ôµ¼³ö³
Ïà¹ØÎĵµ£º
»ùÓÚdom4jµÄXML¸ñʽת»¯Àà
package com.lixi.util;
import java.io.BufferedWriter;
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.OutputStreamWriter;
import org.dom4j.Document;
import org.do ......
XML How to Program
Beginning Xml Databases
Beginning XSLT and XPath Transforming XML Documents and Data
ASP.NET 2.0 XML
XML ÊÖ²á 4th Edition
XML Schema Complete Reference
......
дÕâÆªÎÄÕµÄÔÒòÓÐÈçϼ¸µã£º1)C++±ê×¼¿âÖÐûÓвÙ×÷XMLµÄ·½·¨£¬ÓÃC++²Ù×÷XMLÎļþ±ØÐëÊìϤһÖÖº¯Êý¿â£¬LIBXML2ÊÇÆäÖÐÒ»ÖÖºÜÓÅÐãµÄXML¿â£¬¶øÇÒËüͬʱ֧³Ö¶àÖÖ±à³ÌÓïÑÔ£»2)LIBXML2¿âµÄTutorialдµÃ²»Ì«ºÃ£¬ÓÈÆäÊDZàÂëת»»µÄ²¿·Ö£¬²»ÊÊÓÃÓÚÖÐÎıàÂëµÄת»»£»3)ÍøÉϵĴó¶àÊý¹ØÓÚLibxml2µÄ½éÉܽö½öÊÇ·ÒëÁË×Ô´øµÄ×ÊÁÏ£¬Ã»ÓÐÏêϸ½é ......
using System;
using System.Data;
using System.Drawing;
using System.Globalization;
using System.IO;
using System.Windows.Forms;
using Excel = Microsoft.Office.Interop.Excel;
// Ìí¼ÓÒýÓÃ -> .NET -> Microsoft.Office.Interop.Excel(2003->11.0, 2007->12.0)
namespace WinFormTable
{
& ......
SQLServer2005·Ö½â²¢µ¼ÈëxmlÎļþ ÊÕ²Ø
²âÊÔ»·¾³SQL2005£¬windows2003
DECLARE @idoc int;
DECLARE @doc xml;
SELECT @doc=bulkcolumn from OPENROWSET(
BULK 'D: \test.xml',
SINGLE_BLOB) AS x
EXEC sp_xml_preparedocument @Idoc OUTPUT, @doc
......