°Ñxml תdataset
///ͨ¹ý´«ÈëµÄÌØ¶¨XML×Ö·û´®£¬Í¨¹ý ReadXmlº¯Êý¶ÁÈ¡µ½DataSetÖС£
protected static DataSet GetDataSetByXml(string xmlData)
{
try
{
DataSet ds = new DataSet();
using (StringReader xmlSR = new StringReader(xmlData))
{
ds.ReadXml(xmlSR, XmlReadMode.InferTypedSchema); //ºöÊÓÈκÎÄÚÁª¼Ü¹¹£¬´ÓÊý¾ÝÍÆ¶Ï³öÇ¿ÀàÐͼܹ¹²¢¼ÓÔØÊý¾Ý¡£Èç¹ûÎÞ·¨Íƶϣ¬Ôò½âÊͳÉ×Ö·û´®Êý¾Ý
if (ds.Tables.Count > 0)
{
return ds;
}
}
return null;
}
catch (Exception)
{
return null;
}
}
/// ͨ¹ý´«ÈëµÄxmlÎļþ·¾¶(º¬ÎļþÃû),½«¸ñʽ»¯µÄXmlÎļþ×Ô¶¯¶Áȡת»»ÎªDataSet¡£
public s
Ïà¹ØÎĵµ£º
ÒÑÖªÓÐÒ»¸öXMLÎļþ£¨bookstore.xml£©ÈçÏ£º
<?xml version="1.0" encoding="gb2312"?>
<bookstore>
<book genre="fantasy" ISBN="2-3631-4">
<title>Oberon's Legacy</title>
<author>Corets, Eva</author>
&nb ......
USE Test
--Create 2 tables as an example
CREATE TABLE ExampleTable
(
[ID] int PRIMARY KEY
,[Name] nvarchar(256)
)
CREATE TABLE ExampleTable2
(
[ID] int PRIMARY KEY
,[Name] nvarchar(256)
)
----way1
SELECT *
from sys.objects [table]
WHERE
[Name] LIKE 'ExampleTable%'
FOR XML AUTO, ROOT ......
PHP´ÓPHP5¿ªÊ¼£¬³¹µ×ÖØÐ±àдµÄºÍÐÂÔöÁ˶ÔXMLµÄÀ©Õ¹£¬Èç SAX ½âÎöÆ÷¡¢DOM¡¢SimpleXML¡¢XMLReader¡¢XMLWriter ºÍ XSLT ´¦Àí³ÌÐò¡£ËùÓÐÕâЩÀ©Õ¹¶¼ÒÔ libxml2 Ϊ»ù´¡¡£
=============================
1¡¢DOMDocument¶ÔÏó³£Ó÷½·¨£º
=============================
a£©createElement(elementName)
¸Ã· ......
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import javax.xml.transform.OutputKeys;
import javax.xml.transform.Transformer;
import javax.xml.transform.TransformerException;
import javax.xml.transform.TransformerFactory;
imp ......