xmlÓëDataSetµÄ»¥×ª»»Àà
ÒÔÇ°ÔÚ²©¿ÍÉÏ·¢¹ý£¬¾ÈËÌáÐÑDataSetÒÑ×Ô´ø¶ÁдXMLµÄ¹¦ÄÜ£¬ÓÚÊDZãɾÁË£¬
²»¹ýÔÚʵ¼ùÖиоõ·â×°Ò»²ãºó£¬Ê¹ÓÃÆðÀ´»¹ÊÇÂù·½±ãµÄ¡£¹ÊÔÙ´ÎÖØ·¢¡£
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.IO;
using System.Xml;
namespace XmlDesign
{
class XmlDatasetConvert
{
//½«xml¶ÔÏóÄÚÈÝ×Ö·û´®×ª»»ÎªDataSet
public static DataSet ConvertXMLToDataSet(string xmlData)
{
StringReader stream = null;
XmlTextReader reader = null;
try
{
DataSet xmlDS = new DataSet();
stream = new StringReader(xmlData);
//´Óstream×°Ôص½XmlTextReader
reader = new XmlTextReader(stream);
xmlDS.ReadXml(reader);
return xmlDS;
}
catch (System.Exception ex)
{
throw ex;
}
finally
{
if (reader != null) reader.Close();
}
}
//½«xmlÎļþת»»ÎªDataSet
public static DataSet ConvertXMLFileToDataSet(string xmlFile)
{
StringReader stream = null;
XmlTextReader reader = null;
try
{
XmlDocument xmld = new XmlDocument();
xmld.Load(xmlFile);
DataSet xmlDS = new DataSet();
stream = new StringReader(xmld.InnerXml);
//´Óstream×°Ôص½XmlTextReader
reader = new XmlTextReader(stream);
xmlDS.ReadXml(reader);
//xmlDS.ReadXml(xmlFile);
return xmlDS;
}
catch (System.Exception ex)
{
throw ex;
}
finally
{
if (reader != null) reader.Close();
}
}
//½«DataSetת»»Îªxml¶ÔÏó×Ö·û´®
public static string ConvertDataSetToXML(DataSet xmlDS)
{
MemoryStream stream = null;
XmlTextWriter writer = null;
try
{
stream = new MemoryStream();
//´Óstream×°Ôص½XmlTextReader
writer = new XmlTextWriter(stream, Encoding.Unicode);
//ÓÃWriteXml·½·¨Ð´ÈëÎļþ.
xmlDS.WriteXml(writer);
int count = (int)stream.Length;
byte[] arr = new byte[count];
stream.Seek(0, SeekOrigin.Begin);
stream.Read(arr, 0, count);
UnicodeEncoding utf = new UnicodeEncoding();
return utf.GetString(arr).Trim();
}
catch (System.Exception ex)
{
throw ex;
}
finally
{
if (writer != null) writer.Close();
}
}
//½«DataSetת»»ÎªxmlÎļþ
public static void ConvertDataSetToXMLFile(Dat
Ïà¹ØÎĵµ£º
Ò»¸öC# xml ÐòÁл¯´íÎó
Ê·¢ÏÖ³¡£º
xmlÐòÁл¯µÄÊý¾ÝÖд洢µÄ½ÚµãÊý¾ÝÊÇ
<Module>536870912</Module> £¨xmlÎļþÖУ©
¶ÔÓ¦µÄÀàÊôÐÔÊÇ
public short Module { get; set; } £¨C#ÀàÖУ©
ÐòÁл¯µÄ´úÂ룺
public static FMDSTimeSeriesDefinitio ......
JSON¶¨Òå
JSON(JavaScript Object Notation) ÊÇÒ»ÖÖÇáÁ¿¼¶µÄÊý¾Ý½»»»¸ñʽ£¬Ò×ÓÚÔĶÁºÍ±àд£¬Í¬Ê±Ò²Ò×ÓÚ»úÆ÷½âÎöºÍÉú³É¡£Ëü»ùÓÚECMA262ÓïÑԹ淶£¨1999-12µÚÈý°æ£©ÖÐJavaScript±à³ÌÓïÑÔµÄÒ»¸ö×Ó¼¯¡£ JSON²ÉÓÃÓë±à³ÌÓïÑÔÎ޹صÄÎı¾¸ñʽ£¬µ«ÊÇҲʹÓÃÁËÀàCÓïÑÔ£¨°üÀ¨C£¬ C++£¬ C#£¬ Java£¬ JavaScript£¬ Per ......
1.books.html
<!--
To change this template, choose Tools | Templates
and open the template in the editor.
-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title ......
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)
¸Ã· ......