xml 如下
<?xml version="1.0" encoding="utf-8" ?>
- <stories>
- <story>
<title>C#</title>
- <author>
<name>T.T</name>
<nationality>China</nationality>
</author>
<rating>eerie</rating>
</story>
- <story>
<title>SQL SERVER 2005</title>
- <author>
<name>Jone</name>
<nationality>USA</nationality>
</author>
<rating>gegsEG</rating>
</story>
- <story>
<title>A Single Man</title>
- <author>
<name>Wisz</name>
<nationality>England</nationality>
</author>
<rating>a bi</rating>
</story>
</stories>我是这样写的 private void button1_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable("xmlFile");
dt.Columns.Add(new DataColumn("title",typeof(string)));
dt.Columns.Add(new DataColumn("name", typeof(string)));
dt.Columns.Add(new DataColumn("nationality", typeof(string)));
dt.Columns.Add(new DataColumn("rating", typeof(string)));
XmlDocument document = new XmlDocument();
document.Load(@"C:\C#Demo\XMLFile1.xml");
XmlNode node = document.DocumentElement;
//XmlNodeList nodelist;
foreach (XmlNode xnode in document.SelectNodes("stories/story"))
{
DataRow row = dt.NewRow();
row[xnode.Name] = xnode.InnerText;
dt.Rows.Add(row);
}
DataSet ds = new DataSet();
ds.Tables.Add(dt);
dataGridView1.DataSource = ds.Tables["xmlFile"];
}编译通过了,但是datagridview 没数据 怎么办。。
<?xml version="1.0" encoding="utf-8" ?>
- <stories>
- <story>
<title>C#</title>
- <author>
<name>T.T</name>
<nationality>China</nationality>
</author>
<rating>eerie</rating>
</story>
- <story>
<title>SQL SERVER 2005</title>
- <author>
<name>Jone</name>
<nationality>USA</nationality>
</author>
<rating>gegsEG</rating>
</story>
- <story>
<title>A Single Man</title>
- <author>
<name>Wisz</name>
<nationality>England</nationality>
</author>
<rating>a bi</rating>
</story>
</stories>我是这样写的 private void button1_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable("xmlFile");
dt.Columns.Add(new DataColumn("title",typeof(string)));
dt.Columns.Add(new DataColumn("name", typeof(string)));
dt.Columns.Add(new DataColumn("nationality", typeof(string)));
dt.Columns.Add(new DataColumn("rating", typeof(string)));
XmlDocument document = new XmlDocument();
document.Load(@"C:\C#Demo\XMLFile1.xml");
XmlNode node = document.DocumentElement;
//XmlNodeList nodelist;
foreach (XmlNode xnode in document.SelectNodes("stories/story"))
{
DataRow row = dt.NewRow();
row[xnode.Name] = xnode.InnerText;
dt.Rows.Add(row);
}
DataSet ds = new DataSet();
ds.Tables.Add(dt);
dataGridView1.DataSource = ds.Tables["xmlFile"];
}编译通过了,但是datagridview 没数据 怎么办。。
解决方案 »
- C#中怎么将int数组传递给ref int型参数
- int?是什么意思
- 怎么调用视频采集卡中SDK开发包实现保存视频,抓图,云台等功能,求源码!!!!!急!!!!!有请发送到我邮箱,谢谢[email protected]
- MembershipUser 修改密码问题
- 更新了引用的dll,编译通不过
- 求教一个Windows Form程序报“Setup Error”错误的问题
- 安装项目能调试吗?
- C#中datagridview选中行后textbox显示选中的内容
- IrisSkin2.dll改名
- 怎么把二进制的文件的数据写进CSV文件中
- 编译器失败,错误代码为 128。 这是什么原因啊
- 高分求解:asp.net mvc在请求管道中的请求过程.
显示列“story”不属于表 xmlFile。
如果我新建一个列dt.Columns.Add(new DataColumn("story",typeof(string)));
的话 有数据 但是数据全部写在story这一列里了。。
判断添加值到datatable
单步判断
foreach (XmlNode xnode in xmlDoc.SelectNodes("stories/story"))
{
DataRow row = dt.NewRow();
row["title"] = xnode.SelectSingleNode("title").InnerText.ToString();
row["name"] = xnode.SelectSingleNode("author/name").InnerText.ToString();
row["nationality"] = xnode.SelectSingleNode("author/nationality").InnerText.ToString();
row["rating"] = xnode.SelectSingleNode("rating").InnerText.ToString();
dt.Rows.Add(row);
}
dataGridView1.DataSource = dt;