´ó¼ÒºÃ£¬ÎÒÎʸöDataRowת»»ÎªxmlµÄ - .NET¼¼Êõ / C#
C# code:
DataRow dr = new DataRow();//Êý¾ÝÐÐ
DataSet ds = new DataSet();
string xml = ds.GetXml();
using (System.IO.StreamWriter sw = new System.IO.StreamWriter("d:\\1.xml", false, Encoding.UTF8))
{
sw.Write(xml);
}
´ó¼ÒºÃ£¬ÎÒÓÐÒ»ÐÐÊý¾Ýdr,ÎÒÏë°ÑËûת»»ÎªÒ»¸öxmlÎļþÀ´´¦Àí¡£
DataSet ÓÐGetXml()£¬ÄÇDataRowÓÐʲô£¿
Èç¹ûÊÇ×Ô¼ºÊÖ¶¯À´Éú³É£¬×Ö¶ÎÌ«¶à£¬ÀÛËÀÁË£¡
WriteXml¡£
DataTableºÍDataSet²»ÊÇ ¶¼ÓÐô£¿
DataRowÒ»ÐÐת³ÉXML£¿
Ò»°ã¶¼ÊÇÕû¸öTableת»»XML,²»¹ýÒ»ÐÐÄãÒ²¿ÉÒÔµ±Ö»ÓÐÒ»ÐÐÊý¾ÝµÄtable
C# code:
/// ½«DataSet¶ÔÏóÊý¾Ý±£´æÎªXMLÎļþ
/// </summary>
/// <param name="dt">DataSet</param>
/// <param name="xmlFilePath">XMLÎļþ·¾¶</param>
/// <returns>boolÖµ</returns>
public static bool CDataToXmlFile(DataTable dt, string xmlFilePath)
{
if ((dt != null) && (!string.IsNullOrEmpty(xmlFilePath)))
{
//string path =System.Windows.Forms.Application.StartupPath + System.Configuration.ConfigurationManager.AppSettings["flow"]+ xmlFilePath;
strin
Ïà¹ØÎÊ´ð£º
DataSetµ¼³öxml Åú´¦Àí(Ñ»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
<B>
<C>
</C>
&nb ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽÎļþ
<folder state="unchecked" label="È«²¿">
¡¡¡¡<folder state="unchecked" isBra ......
<?xml version="1.0"?>
<root>
<status>433</status>
<msg>Õâ¸öÊǺº×Ö</msg>
<serialno>123</serialno>
</root>
ÈçºÎÓÃASP¶ÁÈ¡ statusÖµ ......
ÎÒÓÃjqueryÎÞË¢ÐÂÉÏ´«Í¼Æ¬ºó·µ»Øjson¸ñʽµÄÊý¾Ý±¨´í
£¨Êµ¼ÊÉÏͼƬÊÇÉÏ´«³É¹¦µÄÁË£¬Ö»ÊÇ·µ»Øjson¸ñʽ×ܶÁ²»µ½£¬×ÜÊDZ¨´í£©
ÎÒµ÷ÊÔÉÏ´«µÄashxÒ³ÈçÏÂ
ÎÞ·¨ÏÔʾ XML Ò³¡£
ʹÓà Ñùʽ±íÎÞ·¨²é¿´ XML ÊäÈë¡£Çë¸ü ......
ΪʲôÎҵijÌÐòµ÷ÓÃXMLÅäÖÃÎļþÖеİ¢À²®ÎÄÏÔʾ²»³öÀ´£¿ÆäËûµÄÓïÖÖ¶¼¿ÉÒÔ£¬ÈçÖÐÎÄ£¬Ó¢ÎÄ£¬µÂÎͼ¿É¡£
ÎÒ½«XMLµÄ±àÂë¸ÄΪutf-8ºÍunicodeµÄµ½µÃ½á¹û¶¼Ò»Ñù.
°¢À²®ÎĵÄ×Ö¿âÄãÓÐô£¿
ÓÐ,ÎÒµÄEXEÊÇ·ÅÔÚpc»úÉÏÖ´Ðе ......