DataSet XMl DateTable »¥×ª
/// <summary>
/// DataTable-------------------->XML --String
/// </summary>
public static String ToXmlString(DataTable dt)
{
StringWriter tr = new StringWriter();
try
{
dt.WriteXml(tr);
return tr.ToString();
}
catch
{
throw;
}
finally
{
tr.Dispose();
}
}
/// <summary>
/// DataSet----------------->XML---String
/// </summary>
public static String ToXmlString(DataSet ds)
{
StringWriter tr = new StringWriter();
try
{
ds.WriteXml(tr, XmlWriteMode.IgnoreSchema);
return tr.ToString();
}
catch
{
throw;
}
finally
{
tr.Dispose();
}
}
/// <summary>
/// xmlת»»ÎªÊý¾Ý¼¯
/// </summary>
public static DataSet XmlToDataSet(string xml)
{
try
{
StringReader sr = new StringReader(xml);
DataSet ds = new DataSet();
ds.ReadXml(sr);
return ds;
}
catch
{
throw;
}
}
/// <summary>
/// Xmlת»»ÎªÊý¾Ý±í
/// </summary>
public static DataTable ToDataTable(string xmlData, int TableIndex)
{
try
{
return XmlToDataSet(xmlData).Tables[TableIndex];
}
catch
{
throw;
}
}
Ïà¹ØÎĵµ£º
XML¿ª·¢ÈëÃÅ»ù´¡£ºXMLÓï·¨¹æÔò(2) - ÍøÒ³Éè¼Æ×¨À¸ - ±à³ÌÈëÃÅÍø
http://www.bianceng.cn/web/XML/200911/11986_2.htm
×Ö·û ʵÌåÒýÓÃ
> &n ......
MSDNÉϵ͍Ò壺
XML ÐòÁл¯½«¶ÔÏóµÄ¹«¹²×ֶκÍÊôÐÔ»òÕß·½·¨µÄ²ÎÊýºÍ·µ»ØÖµ×ª»»£¨ÐòÁл¯£©Îª·ûºÏÌØ¶¨ XML ¼Ü¹¹¶¨ÒåÓïÑÔ (XSD) ÎĵµµÄ XML Á÷¡£XML ÐòÁл¯Éú³ÉÇ¿ÀàÐ͵ÄÀ࣬²¢Îª´æ´¢»ò´«ÊäÄ¿µÄ½«Æä¹«¹²ÊôÐÔºÍ×Ö¶Îת»»ÎªÐòÁиñʽ£¨ÔÚ´ËÇé¿öÏÂΪ XML)¼òµ¥µÄ˵¾ÍÊǽ«Ò»¸ö¶ÔÏóת»»³ÉXMLÁ÷»òÊÇÎļþµÄ¹ý³Ì¡£
×¢ÒâÊÂÏҪÐòÁл¯µÄÀ ......
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
create procedure [dbo].[MachiningPayedGetListByCondition]
@CustomerName varchar(50),
@CustomerPhone varchar(50),
@PactNumber varchar(50),
@Ispay bit
as
begin
set nocount on;
SELECT
dp.ID as 'MachiningPayed/@ID',
&nbs ......
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="fw_student">
<resultMap class="com.sias.Student" id="student">
<result column="name" property="na ......
1¡¢µ¼³öµ½XMl select * from Brand for xml auto ,root('Brands')
<Brands>
<Brand BrandID="E584596D-4D66-4F2F-B6F7-71C3BEB4CA21" Name="inganico" />
<Brand BrandID="19B04451-DDC4-4CDF-BE30-CB4E703B27DA" Name="°²¸¶´ï" />
<Brand BrandID="3C6C8E12-7C4A-4F1 ......