ͨ¹ýLINQ to XMLÉú³É XML
±êÇ©£ºÊý¾Ý·ÃÎÊ ADO.NET
ͨ¹ýLINQ to XMLÉú³É XML XML³£³£ÓÃÓïÔÚ¿Í»§»úºÍ·þÎñÆ÷Ö®¼ä½»Á÷Êý¾Ý£¬»òÕß¶à²ãÓ¦ÓóÌÐòÖ®¼ä½»Á÷¡£
ÓÃLINQ to SQL²éѯÊý¾Ý£¬ÔÙÓÃLINQ to XML°ÉÊý¾Ýת»»ÎªXML.
Àý£º
.......
AreslabDataContext aresData = new aresData(); //´´½¨DataContextʵÀý
XElement aresCustomerOrders = new XElement("customers", //´´½¨XMLƬ¶ÎʵÀý from c in aresData.Customers //ÀûÓÃLINQ²éѯÊý¾Ý£¬DataContext¶ÔÏóµÄCustomers³ÉÔ±×÷ΪÊý¾ÝÔ´ select new XElement("customer", //¹¹½¨selectͶÉä new XAtrribute("ID", c.CustomerID), new XAtrribute("Company", c.CompanyName),
Ïà¹ØÎĵµ£º
IsolatedStorageFile£º°üº¬ÎļþºÍÊý¾ÝµÄ¶ÀÁ¢´æ´¢Çø
datasetÊý¾Ý´æ´¢µ½±¾µØxmlÎĵµ£¬´úÂë´¦ÀíÈçÏÂ
public static void WriteDataToXML(DataSet dataset, string dataname)
{
try
{
IsolatedStorageFile isoStore = IsolatedStorageFile.GetUserStoreForAssembly(); / ......
/// <summary>
/// DataTable-------------------->XML --String
/// </summary>
public static String ToXmlString(DataTable dt)
{
StringWriter tr = new StringWriter();
try
{
dt.WriteXml(tr); ......
from£ºhttp://www.xland.com.cn/article/7/81/0804/28778.htm
±¾ÀàʵÏÖ£º
Êý¾Ý¿âÐÅÏ¢µ¼³ö£ºword£¬excel£¬json£¬xml£¬sql
Êý¾Ý¿â»Ö¸´£º´Ósql£¬´ÓÎļþ
¾ßÌåÓ÷¨:
Ê×ÏÈн¨²âÊÔÓÃÊý¾Ý¿âmytest£¬È»ºóÔÚÀïÃæ½¨Õűí
PHP´úÂë:
ÒÔÏÂÊÇ´úÂëÆ¬¶Î£º
--
-- ±íµÄ½á¹¹ `test`
--
CREATE TABLE `test` (
`id ......
ÏÖÔÚÎÒÃÇÔÝÇÒʹÓÓ¼Çʱ¾”À´´´½¨ÎÒÃǵÄXMLÎļþ°É¡£ÏÈ¿´Ò»¸öXMLÎļþ£º
¡¡¡¡Àý1
¡¡¡¡¡´?xml version="1.0" encoding="gb2312" ?¡µ
¡¡¡¡¡´²Î¿¼×ÊÁÏ¡µ
¡¡¡¡ ¡´Êé¼®¡µ
¡¡¡¡ ¡´Ãû³Æ¡µXMLÈëÞ«½â¡´/Ãû³Æ¡µ
¡¡¡¡ ¡´×÷Õß¡µÕÅÈý¡´/×÷Õß¡ ......
±¾ÎÄת×Ô£ºhttp://www.10086web.com/html/wangluobiancheng/Xmlbiancheng/2009/0612/90.html
Ò»¸ö¿Í»§Ìṩһ¸ö¹É¼ÛµÄÐÅÏ¢£¬ÒªÇó·ÅÔÚÒ³ÃæÉÏ£¬ÏÔʾһЩÊý¾Ý£¬ÐèÒª´ÓÔ¶³Ì»ñÈ¡xml£¬È»ºó½âÎöдÔÚÍøÒ³ÉÏ£¬¿ªÊ¼²»»á¾õµÃºÜÄÑ£¬ÆäʵÂù¼òµ¥µÄ£¬ÏÈÓÃjavascriptдÁËÒ»¸ö£º
<mce:script language=javascript><!--
......