Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

C# »ñÈ¡ÎļþÐÅÏ¢²¢µ¼³öExcel£¬Xml±¨±í

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
{
    public partial class FormTable : Form
    {
        #region
        private DataTable table;
        private ChineseLunisolarCalendar lunarCalendar;
        #endregion
        public FormTable()
        {
            #region
            InitializeComponent();
            lunarCalendar = new ChineseLunisolarCalendar(); // ÖйúÒõÀú¡£
            table = new DataTable("File");
            table.Locale = CultureInfo.InvariantCulture; // ¹Ì¶¨ÇøÓò¡£
            DataColumn column = table.Columns.Add("Name", typeof(String));
            table.Columns.Add("Length", typeof(Decimal));
            table.Columns.Add("CreationTime", typeof(DateTime));
            table.Constraints.Add("PK", column, true); // ´´½¨Ö÷¼ü¡£
            table.DefaultView.ApplyDefaultSort = true; // ʹÓÃĬÈÏÅÅÐò¡£
            GridViewStyle();
  &nbs


Ïà¹ØÎĵµ£º

DOMÓëSAX½âÎöxmlµÄÇø±ð


SAX¸ÅÄî
SAXÊÇSimple API for XMLµÄËõд£¬Ëü²¢²»ÊÇÓÉW3C¹Ù·½ËùÌá³öµÄ±ê×¼£¬¿ÉÒÔ˵ÊÇ“Ãñ¼ä”µÄÊÂʵ±ê×¼¡£Êµ¼ÊÉÏ£¬ËüÊÇÒ»ÖÖÉçÇøÐÔÖʵÄÌÖÂÛ²úÎï¡£ËäÈ»Èç´Ë£¬ÔÚXMLÖжÔSAXµÄÓ¦ÓÃË¿ºÁ²»±ÈDOMÉÙ£¬¼¸ºõËùÓеÄXML½âÎöÆ÷¶¼»áÖ§³ÖËü¡£
ÓëDOM±È½Ï¶øÑÔ£¬SAXÊÇÒ»ÖÖÇáÁ¿Ð͵ķ½·¨¡£ÎÒÃÇÖªµÀ£¬ÔÚ´¦ÀíDOMµÄʱºò£¬ÎÒÃÇÐèÒª¶Á ......

XML ,query ºÍ valueÊÇÇø·Ö´óСд µÄ

DECLARE @x xml
SET @x='
<root>
  <ShopAccount>
    <ActivityType>IA - PM Standing WO (for LPI report)</ActivityType>
    <ProjectNo>R</ProjectNo>
  </ShopAccount>
  <ShopAccount>
    ......

10±¾¾­µäXML¼°WebÏà¹Øµç×ÓÊé


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
......

ѧϰASP.NETÐèÇóµÄ»ù±¾µÄc#֪ʶ£¨×ªÌû+ÒÑÐ޸ģ©

£¨±¸×¢£ºÎÄÖкìÉ«×ÖÌåÊÇÎÒÔÚÔ­ÎĵĻù´¡ÉÏÌí¼ÓµÄ½âÊÍ˵Ã÷£©
 Î¢ÈíµÄʵÀý½Ì²ÄÖн²ÁËÈýÖÖÓïÑÔ£ºc#¡¢vb   ¡¢Jscript£¬ÎªÁËÈôó¼Ò¹ýÒ»°Ñж«Î÷ñ«£¬ÎÒÃÇ»¹ÊÇѧc#°É¡£Õâ¸ö×îºÃÓÐÒ»µãc++»ù´¡¡£    
  ²»¹ýûÓÐҲûÓйØÏµ£¬´ó²»Á˶à·ÑµãÁ¦ÁË¡£    
  ÈκÎÒ»ÃÅÓ ......

javaÖÐʹÓÃdom4jдxmlÎļþºÍ¼òµ¥½Ì³Ì

 
ÏÂÔØ dom4j-1.6.1.jar¡£
1: package org.zzp.common.xml.dom4j;
2:
3: import java.io.FileWriter;
4: import java.io.IOException;
5: import org.dom4j.Document;
6: import org.dom4j.DocumentHelper;
7: import org.dom4j.Element;
8: import org.dom4j.io.OutputFormat;
9: impor ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ