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
Ïà¹ØÎĵµ£º
DECLARE @x xml
SET @x='
<root>
<ShopAccount>
<ActivityType>IA - PM Standing WO (for LPI report)</ActivityType>
<ProjectNo>R</ProjectNo>
</ShopAccount>
<ShopAccount>
......
×î½ü×öÒ»¸öÍøÕ¾£¬¸ÃÍøÕ¾ÐèÒªÌí¼Ó4000¶à ²úÆ·ÐÅÏ¢£¬Èç¹ûÓÃÈ˹¤·½·¨È¥±ðµÄÍøÕ¾copyÄÇÖÁÉÙÒª»¨·Ñ°ëÔÂʱ¼ä²ÅÄÜÍê³É£¬ËùÒÔÎÒ¸ö°ì·¨Ê¹ÓÃc#×÷³öÀ´ÁËÒ»¸öÍøÒ³Êý¾Ý²É¼¯Èí¼þ
Ïêϸ³ö´¦²Î¿¼£ºhttp://www.jb51.net/article/21468.htm
//ÌáÈ¡²úÆ·ÁбíÒ³ÖвúÆ·×îÖÕÒ³µÄÍøÒ³
private void button1_Click(object sender, EventArgs e)
......
XML ×÷ΪÊý¾ÝÔ´µÄʵÀý£¨TESTED£©
<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute" preinitialize="preInit()" fontSize="12" height="500">
<mx:Script>
  ......
XStreamʹÓÃ
XStreamÊÇÒ»¸öJava¶ÔÏóºÍXMLÏ໥ת»»µÄ¹¤¾ß£¬ºÜºÃºÜÇ¿´ó¡£ÌṩÁËËùÓеĻù´¡ÀàÐÍ¡¢Êý×é¡¢¼¯ºÏµÈÀàÐÍÖ±½Óת»»µÄÖ§³Ö¡£Òò´ËXML³£ÓÃÓÚÊý¾Ý½»»»¡¢¶ÔÏóÐòÁл¯£¨ÕâÖÖÐòÁл¯ºÍJava¶ÔÏóµÄÐòÁл¯¼¼ÊõÓÐ×ű¾ÖʵÄÇø±ð£©¡£
XStreamÖеĺËÐÄÀà¾ÍÊÇXStreamÀ࣬һ°ãÀ´Ëµ£¬ÊìϤÕâ¸öÀà»ù±¾¾Í¹»ÓÃÁË£¬Èç¹ûÄãÓõĸü¶à£¬¹À¼ÆÊÇÄ ......
ÔںܶàÇé¿öÏÂ, ÎÒÃÇ»áÓõ½XML,±ÈÈç˵ÅäÖÃÎļþµÈ.C#ÌṩÁËXMLÀà.
ÕâÀïÎÒÖ»ÊǼòµ¥µÄдһÏÂXMLÎļþµÄÉú³É,½âÎö¾Í²»¶à˵ÁË.
µÚÒ»ÖÖ·½·¨
DataBase db = DataBaseFactory.CreateDataBase(DataBaseType.MySql, strMysql);
......