62,050
社区成员
发帖
与我相关
我的任务
分享问个xpath与dataSet的问题!
string xmlfile="xml/200601.xml",xpath;
private void Page_Load(object sender, System.EventArgs e)
{
xpath=Server.MapPath(xmlfile);
XPathDocument Doc=new XPathDocument(xpath);
XPathNavigator nav=Doc.CreateNavigator();
//怎么把子节点表帮定到ds上？
????? ds=nav.Select("xml/200601/commodity/classs");
dataSet1.ReadXml(ds);
DataGrid1.DataSource = dataSet1;
DataGrid1.DataBind();
}
private void Page_Load(object sender, System.EventArgs e)
{
xpath=Server.MapPath(xmlfile);
XPathDocument Doc=new XPathDocument(xpath);
XPathNavigator nav=Doc.CreateNavigator();
//怎么把子节点表帮定到ds上？
????? ds=nav.Select("xml/200601/commodity/classs");
dataSet1.ReadXml(ds);
DataGrid1.DataSource = dataSet1;
DataGrid1.DataBind();
}
...全文
请发表友善的回复…
发表回复
YSEE 2005-12-13
- 打赏
- 举报
-_-~~~
saucer 2005-12-13
- 打赏
- 举报
which is null? dataSet1 or node?? show your code and a sample of xml
purplesunshine 2005-12-13
- 打赏
- 举报
学习之~~~
saucer 2005-12-13
- 打赏
- 举报
make sure the nodes under "class" is good for DataSet, the following works for me
1. TestData.xml:
<?xml version="1.0" standalone="yes"?>
<root>
<mydata>
<NewDataSet>
<Order>
<ID>0</ID>
<Name>Name0</Name>
</Order>
<Order>
<ID>1</ID>
<Name>Name1</Name>
</Order>
<Order>
<ID>2</ID>
<Name>Name2</Name>
</Order>
<Order>
<ID>3</ID>
<Name>Name3</Name>
</Order>
<Order>
<ID>4</ID>
<Name>Name4</Name>
</Order>
</NewDataSet>
</mydata>
</root>
2.
DataSet dataSet1 = new DataSet();
XmlDocument doc = new XmlDocument();
doc.Load("TestData.xml");
XmlNode node = doc.SelectSingleNode("root/mydata/NewDataSet");
dataSet1.ReadXml(new XmlNodeReader(node), XmlReadMode.InferSchema);
dataSet1.WriteXml(Console.Out);
foreach(DataTable dt in dataSet1.Tables)
{
Console.WriteLine("{0} has {1} rows", dt.TableName, dt.Rows.Count);
}
1. TestData.xml:
<?xml version="1.0" standalone="yes"?>
<root>
<mydata>
<NewDataSet>
<Order>
<ID>0</ID>
<Name>Name0</Name>
</Order>
<Order>
<ID>1</ID>
<Name>Name1</Name>
</Order>
<Order>
<ID>2</ID>
<Name>Name2</Name>
</Order>
<Order>
<ID>3</ID>
<Name>Name3</Name>
</Order>
<Order>
<ID>4</ID>
<Name>Name4</Name>
</Order>
</NewDataSet>
</mydata>
</root>
2.
DataSet dataSet1 = new DataSet();
XmlDocument doc = new XmlDocument();
doc.Load("TestData.xml");
XmlNode node = doc.SelectSingleNode("root/mydata/NewDataSet");
dataSet1.ReadXml(new XmlNodeReader(node), XmlReadMode.InferSchema);
dataSet1.WriteXml(Console.Out);
foreach(DataTable dt in dataSet1.Tables)
{
Console.WriteLine("{0} has {1} rows", dt.TableName, dt.Rows.Count);
}
YSEE 2005-12-13
- 打赏
- 举报
异常详细信息: System.NullReferenceException: 未将对象引用设置到对象的实例。
行 53： dataSet1.ReadXml(new XmlNodeReader(node), XmlReadMode.InferSchema);
行 53： dataSet1.ReadXml(new XmlNodeReader(node), XmlReadMode.InferSchema);
YSEE 2005-12-12
- 打赏
- 举报
异常详细信息: System.Xml.XPath.XPathException: 传递给此方法的表达式应产生 NodeSet。
行 50：XmlNode node = doc.SelectSingleNode("xml/200601/commodity/classs");
saucer 2005-12-12
- 打赏
- 举报
instead of using XPathDocument, try XmlDocument
XmlDocument doc = new XmlDocument();
doc.Load("...");
XmlNode node = doc.Select("....");
dataSet1.ReadXml(new XmlNodeReader(node), XmlReadMode.InferSchema);
....
XmlDocument doc = new XmlDocument();
doc.Load("...");
XmlNode node = doc.Select("....");
dataSet1.ReadXml(new XmlNodeReader(node), XmlReadMode.InferSchema);
....
