110,539
社区成员
发帖
与我相关
我的任务
分享
- <xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
- <s:Schema id="RowsetSchema">
- <s:ElementType name="row" content="eltOnly">
- <s:AttributeType name="c0" rs:name="单据编号" rs:number="1" rs:writeunknown="true">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="20" rs:maybenull="false" />
</s:AttributeType>
- <s:AttributeType name="c1" rs:name="购方税号" rs:number="2" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="20" />
</s:AttributeType>
- <s:AttributeType name="c2" rs:name="购方名称" rs:number="3" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="100" />
</s:AttributeType>
- <s:AttributeType name="c3" rs:name="购方地址电话" rs:number="4" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="100" />
</s:AttributeType>
- <s:AttributeType name="c4" rs:name="购方银行帐号" rs:number="5" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="100" />
</s:AttributeType>
- <s:AttributeType name="c5" rs:name="水费编号" rs:number="6" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="20" />
</s:AttributeType>
- <s:AttributeType name="c6" rs:name="客户编号" rs:number="7" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="20" />
</s:AttributeType>
- <s:AttributeType name="c7" rs:name="开票金额" rs:number="8" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="number" rs:dbtype="numeric" dt:maxLength="19" rs:scale="2" rs:precision="18" rs:fixedlength="true" />
</s:AttributeType>
- <s:AttributeType name="c8" rs:name="类别代码" rs:number="9" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="10" />
</s:AttributeType>
- <s:AttributeType name="c9" rs:name="发票号码" rs:number="10" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="10" />
</s:AttributeType>
- <s:AttributeType name="c10" rs:name="开票机号" rs:number="11" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="i2" dt:maxLength="2" rs:precision="5" rs:fixedlength="true" />
</s:AttributeType>
- <s:AttributeType name="c11" rs:name="日期" rs:number="12" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="dateTime" rs:dbtype="timestamp" dt:maxLength="16" rs:scale="3" rs:precision="23" rs:fixedlength="true" />
</s:AttributeType>
- <s:AttributeType name="c12" rs:name="发票金额" rs:number="13" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="number" rs:dbtype="numeric" dt:maxLength="19" rs:scale="2" rs:precision="18" rs:fixedlength="true" />
</s:AttributeType>
- <s:AttributeType name="c13" rs:name="发票状态" rs:number="14" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="ui1" dt:maxLength="1" rs:precision="3" rs:fixedlength="true" />
</s:AttributeType>
- <s:AttributeType name="c14" rs:name="备注" rs:number="15" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="240" />
</s:AttributeType>
<s:extends type="rs:rowbase" />
</s:ElementType>
</s:Schema>
- <rs:data>
<z:row c0="1049311" c1="310101132303205" c2="上海群力草药店" c3="金陵东路396号 63288888" c4="黄浦支行金分 012689-2098268909007016397" c5="10237" c6="10237" c7="337446.65" c8="3205491170" c9="1459428" c10="0" c11="2009-10-10T00:00:00" c12="337446.65" c13="0" c14="" />
<z:row c0="1049312" c1="140931662367552" c2="山西瑞星医药有限公司" c3="太原市迎泽区青年路50号 0351-4669301" c4="中国银行青年路支行 107351452608048052" c5="10231" c6="10231" c7="30878.05" c8="3205491170" c9="1459429" c10="0" c11="2009-10-10T00:00:00" c12="30878.05" c13="0" c14="" />
</rs:data>
</xml>
static DataTable ParseXml(string strXML)
{
XmlDocument xmldoc = new XmlDocument();
xmldoc.Load(strXML);
DataTable dt = new DataTable();
DataColumn dc;
XmlNamespaceManager XNM = new XmlNamespaceManager(xmldoc.NameTable);
XNM.AddNamespace("s", "uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882");
XNM.AddNamespace("dt", "uuid:C2F41010-65B3-11d1-A29F-00AA00C14882");
XNM.AddNamespace("rs", "urn:schemas-microsoft-com:rowset");
XNM.AddNamespace("z", "#RowsetSchema");
int TotalFieldCount = 0;
for (; ; TotalFieldCount++)
{
string ColumnName = "c" + TotalFieldCount.ToString();
XmlNode Node = xmldoc.SelectSingleNode("//xml/s:Schema/s:ElementType/s:AttributeType[@name=\"" + ColumnName + "\"]/@rs:name", XNM);
XmlNode Node1 = xmldoc.SelectSingleNode("//xml/s:Schema/s:ElementType/s:AttributeType[@name=\"" + ColumnName + "\"]/s:datatype/@dt:type", XNM);
if (Node == null)
break;
//Console.WriteLine(Node1.InnerText);
dc = new DataColumn();
dc.ColumnName = ColumnName; //Node.InnerText;
dc.DataType = typeof(System.String); //Type.GetType("System."+Node1.InnerText);
dt.Columns.Add(dc);
}
//打印列名
//foreach (DataColumn dc1 in dt.Columns)
//{
// Console.WriteLine(dc1.ColumnName.ToString());
//}
XmlNodeList Nodes = xmldoc.SelectNodes("//xml/rs:data/z:row", XNM);
foreach (XmlNode Node in Nodes)
{
DataRow dr = dt.NewRow();
for (int i = 0; i < TotalFieldCount; i++)
{
string ColumnName = "c" + i.ToString();
dr[ColumnName] = Node.Attributes[ColumnName].InnerText;
}
dt.Rows.Add(dr);
}
return dt;
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Xml;
namespace WindowsApplication265
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
XmlDocument Doc = new XmlDocument();
Doc.Load(@"c:\a.xml");
XmlNamespaceManager XNM = new XmlNamespaceManager(Doc.NameTable);
XNM.AddNamespace("s", "uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882");
XNM.AddNamespace("dt", "uuid:C2F41010-65B3-11d1-A29F-00AA00C14882");
XNM.AddNamespace("rs", "urn:schemas-microsoft-com:rowset");
XNM.AddNamespace("z", "#RowsetSchema");
DataGridView DGV = new DataGridView();
DGV.Parent = this;
DGV.Dock = DockStyle.Fill;
DGV.AllowUserToAddRows = false;
DataTable DT = new DataTable();
int TotalFieldCount = 0;
for (; ; TotalFieldCount++)
{
String ColumnName = "c" + TotalFieldCount.ToString();
XmlNode Node = Doc.SelectSingleNode
("//xml/s:Schema/s:ElementType/s:AttributeType[@name=\""
+ ColumnName + "\"]/@rs:name", XNM);
if (Node == null)
break;
DT.Columns.Add(ColumnName);
DT.Columns[DT.Columns.Count - 1].Caption = Node.InnerText;
}
XmlNodeList Nodes = Doc.SelectNodes("//xml/rs:data/z:row", XNM);
foreach (XmlNode Node in Nodes)
{
Object[] Objs = new Object[TotalFieldCount];
for (int i = 0; i < TotalFieldCount; i++)
{
String ColumnName = "c" + i.ToString();
Objs[i]= Node.Attributes[ColumnName].InnerText;
}
DT.Rows.Add(Objs);
}
DGV.DataSource = DT;
foreach (DataGridViewColumn Column in DGV.Columns)
Column.HeaderText = DT.Columns[Column.DataPropertyName].Caption;
}
}
}
static void ParseXML(string strXML)
{
XmlDocument xmldoc = new XmlDocument();
xmldoc.Load(strXML);
foreach (XmlNode node in xmldoc.SelectNodes("//AttributeType"))
{
Console.WriteLine(node.Attributes["rs:name"].Value);
}
}
static DataTable ParseXml(string strXML)
{
XmlDocument xmldoc = new XmlDocument();
xmldoc.Load(strXML);
DataTable dt = new DataTable();
DataColumn dc;
XmlNamespaceManager XNM = new XmlNamespaceManager(xmldoc.NameTable);
XNM.AddNamespace("s", "uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882");
XNM.AddNamespace("dt", "uuid:C2F41010-65B3-11d1-A29F-00AA00C14882");
XNM.AddNamespace("rs", "urn:schemas-microsoft-com:rowset");
XNM.AddNamespace("z", "#RowsetSchema");
int TotalFieldCount = 0;
for (; ; TotalFieldCount++)
{
string ColumnName = "c" + TotalFieldCount.ToString();
XmlNode Node = xmldoc.SelectSingleNode("//xml/s:Schema/s:ElementType/s:AttributeType[@name=\""+ColumnName+"\"]/@rs:name",XNM);
XmlNode Node1 = xmldoc.SelectSingleNode("//xml/s:Schema/s:ElementType/s:AttributeType[@name=\""+ColumnName+"\"]/s:datatype/@dt:type", XNM);
if (Node == null)
break;
//Console.WriteLine(Node1.InnerText);
dc = new DataColumn();
dc.ColumnName = ColumnName; //Node.InnerText;
dc.DataType = typeof(System.String); //Type.GetType("System."+Node1.InnerText);
dt.Columns.Add(dc);
}
//打印列名
//foreach (DataColumn dc1 in dt.Columns)
//{
// Console.WriteLine(dc1.ColumnName.ToString());
//}
XmlNodeList Nodes = xmldoc.SelectNodes("//xml/rs:data/z:row", XNM);
foreach (XmlNode Node in Nodes)
{
DataRow dr = dt.NewRow();
for (int i = 0; i < TotalFieldCount; i++)
{
string ColumnName = "c" + i.ToString();
dr[ColumnName] = Node.Attributes[ColumnName].InnerText;
}
dt.Rows.Add(dr);
}
return dt;
}
<?xml version="1.0" encoding="GB2312" ?>
<xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
<s:Schema id="RowsetSchema">
<s:ElementType name="row" content="eltOnly">
<s:AttributeType name="c0" rs:name="单据编号" rs:number="1" rs:writeunknown="true">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="20" rs:maybenull="false" />
</s:AttributeType>
<s:AttributeType name="c1" rs:name="购方税号" rs:number="2" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="20" />
</s:AttributeType>
<s:AttributeType name="c2" rs:name="购方名称" rs:number="3" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="100" />
</s:AttributeType>
<s:AttributeType name="c3" rs:name="购方地址电话" rs:number="4" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="100" />
</s:AttributeType>
<s:AttributeType name="c4" rs:name="购方银行帐号" rs:number="5" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" dt:maxLength="100" />
</s:AttributeType>
<s:AttributeType name="c5" rs:name="水费编号" rs:number="6" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="20" />
</s:AttributeType>
<s:AttributeType name="c6" rs:name="客户编号" rs:number="7" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="20" />
</s:AttributeType>
<s:AttributeType name="c7" rs:name="开票金额" rs:number="8" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="number" rs:dbtype="numeric" dt:maxLength="19" rs:scale="2" rs:precision="18" rs:fixedlength="true" />
</s:AttributeType>
<s:AttributeType name="c8" rs:name="类别代码" rs:number="9" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="10" />
</s:AttributeType>
<s:AttributeType name="c9" rs:name="发票号码" rs:number="10" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="10" />
</s:AttributeType>
<s:AttributeType name="c10" rs:name="开票机号" rs:number="11" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="i2" dt:maxLength="2" rs:precision="5" rs:fixedlength="true" />
</s:AttributeType>
<s:AttributeType name="c11" rs:name="日期" rs:number="12" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="dateTime" rs:dbtype="timestamp" dt:maxLength="16" rs:scale="3" rs:precision="23" rs:fixedlength="true" />
</s:AttributeType>
<s:AttributeType name="c12" rs:name="发票金额" rs:number="13" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="number" rs:dbtype="numeric" dt:maxLength="19" rs:scale="2" rs:precision="18" rs:fixedlength="true" />
</s:AttributeType>
<s:AttributeType name="c13" rs:name="发票状态" rs:number="14" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="ui1" dt:maxLength="1" rs:precision="3" rs:fixedlength="true" />
</s:AttributeType>
<s:AttributeType name="c14" rs:name="备注" rs:number="15" rs:nullable="true" rs:writeunknown="true">
<s:datatype dt:type="string" rs:dbtype="str" dt:maxLength="240" />
</s:AttributeType>
<s:extends type="rs:rowbase" />
</s:ElementType>
</s:Schema>
<rs:data>
<z:row c0="1049311" c1="310101132303205" c2="上海群力草药店" c3="金陵东路396号 63288888" c4="黄浦支行金分 012689-2098268909007016397" c5="10237" c6="10237" c7="337446.65" c8="3205491170" c9="1459428" c10="0" c11="2009-10-10T00:00:00" c12="337446.65" c13="0" c14="" />
<z:row c0="1049312" c1="140931662367552" c2="山西瑞星医药有限公司" c3="太原市迎泽区青年路50号 0351-4669301" c4="中国银行青年路支行 107351452608048052" c5="10231" c6="10231" c7="30878.05" c8="3205491170" c9="1459429" c10="0" c11="2009-10-10T00:00:00" c12="30878.05" c13="0" c14="" />
</rs:data>
</xml>
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Xml;
namespace WindowsApplication265
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
XmlDocument Doc = new XmlDocument();
Doc.Load(@"c:\a.xml");
XmlNamespaceManager XNM = new XmlNamespaceManager(Doc.NameTable);
XNM.AddNamespace("s", "uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882");
XNM.AddNamespace("dt", "uuid:C2F41010-65B3-11d1-A29F-00AA00C14882");
XNM.AddNamespace("rs", "urn:schemas-microsoft-com:rowset");
XNM.AddNamespace("z", "#RowsetSchema");
DataGridView DGV = new DataGridView();
DGV.Parent = this;
DGV.Dock = DockStyle.Fill;
DGV.AllowUserToAddRows = false;
int TotalFieldCount = 0;
for (; ; TotalFieldCount++)
{
String ColumnName = "c" + TotalFieldCount.ToString();
XmlNode Node = Doc.SelectSingleNode
("//xml/s:Schema/s:ElementType/s:AttributeType[@name=\""
+ ColumnName + "\"]/@rs:name", XNM);
if (Node == null)
break;
DGV.Columns.Add(ColumnName, Node.InnerText);
}
XmlNodeList Nodes = Doc.SelectNodes("//xml/rs:data/z:row", XNM);
foreach (XmlNode Node in Nodes)
{
DGV.Rows.Add(1);
for (int i = 0; i < TotalFieldCount; i++)
{
String ColumnName = "c" + i.ToString();
DGV[ColumnName, DGV.RowCount - 1].Value = Node.Attributes[ColumnName].InnerText;
}
}
}
}
}
static void ParseXml(string strXML)
{
XmlDocument xmldoc = new XmlDocument();
xmldoc.LoadXml(strXML);
XmlNode xmlnode1 = xmldoc.SelectSingleNode("RowsetSchema");
foreach (XmlElement xmlnode in xmlnode1.ChildNodes)
{
Console.WriteLine("单据编号" + xmlnode.GetAttribute("c0"));
Console.WriteLine("购方税号" + xmlnode.GetAttribute("c1"));
Console.WriteLine("购方名称" + xmlnode.GetAttribute("c3"));
Console.WriteLine("备注" + xmlnode.GetAttribute("c14"));
foreach (XmlElement xmlele1 in xmlnode.ChildNodes)
{
Console.WriteLine("c1=" + xmlele1.GetAttribute("c1"));
Console.WriteLine("c2=" + xmlele1.GetAttribute("c2"));
Console.WriteLine("c3=" + xmlele1.GetAttribute("c3"));
Console.WriteLine("c14=" + xmlele1.GetAttribute("c14"));
}
}
}
XmlDocument xmldoc = new XmlDocument();
xmldoc.LoadXml(TextBox3.Text);
XmlNode xmlnode1 = xmldoc.SelectSingleNode("RowsetSchema");
foreach (XmlElement xmlnode in xmlnode1.ChildNodes)
{
Response.Write("单据编号" + xmlnode.GetAttribute("c0"));
Response.Write("购方税号" + xmlnode.GetAttribute("c1"));
Response.Write("购方名称" + xmlnode.GetAttribute("c3"));
....
Response.Write("备注" + xmlnode.GetAttribute("c14"));
Response.Write("<br>");
foreach (XmlElement xmlele1 in xmlnode.ChildNodes)
{
Response.Write("c1=" + xmlele1.GetAttribute("c1"));
Response.Write("c2=" + xmlele1.GetAttribute("c2"));
Response.Write("c3=" + xmlele1.GetAttribute("c3"));
....
Response.Write("c14=" + xmlele1.GetAttribute("c14"));
}
}
XmlDocument xmldoc = new XmlDocument();
xmldoc.LoadXml(TextBox3.Text);
XmlNode xmlnode1 = xmldoc.SelectSingleNode("RowsetSchema");
foreach (XmlElement xmlnode in xmlnode1.ChildNodes)
{
Response.Write("单据编号=" + xmlnode.GetAttribute("xx"));
.....
foreach (XmlElement xmlele1 in xmlnode.ChildNodes)
{
Response.Write(...);
...
}
}