我有1个xml文档,我想将其中数据插入数据库,通过模型层的对象来实现,因为一个节点相当于1个表
xml文档:
<books>
<book>
<aut>aaa</aaa>
<Createtime>2009</Createtime>
</book>
<book>
<aut>aaa</aaa>
<Createtime>2009</Createtime>
</book>
<book>
<aut>aaa</aaa>
<Createtime>2009</Createtime>
</book>
</books>
Model中bookpublic class book
{
private string aut;
private datetime Createtime; public string aut
{
get{return aut};
set{aut=value};
} public datetiem Createtime
{
get{return Createtime};
set{Createtime=value};
}
public book(int aut,datetime Createtiem)
{
this.aut=aut;
this.Createtime=Createtime;
}
}
怎么把xml通过模型层book进行数据库保存啊
xml文档:
<books>
<book>
<aut>aaa</aaa>
<Createtime>2009</Createtime>
</book>
<book>
<aut>aaa</aaa>
<Createtime>2009</Createtime>
</book>
<book>
<aut>aaa</aaa>
<Createtime>2009</Createtime>
</book>
</books>
Model中bookpublic class book
{
private string aut;
private datetime Createtime; public string aut
{
get{return aut};
set{aut=value};
} public datetiem Createtime
{
get{return Createtime};
set{Createtime=value};
}
public book(int aut,datetime Createtiem)
{
this.aut=aut;
this.Createtime=Createtime;
}
}
怎么把xml通过模型层book进行数据库保存啊
解决方案 »
- C#调用C++的Dll,从dll中返回一个IntPrt怎样得到IntPrt的Byte[]
- 大家做添加新闻页面是不是都使用FreeTextBox控件?
- html自定义属性后怎么以xml格式提取出来
- 如何使用Parameter【】传递存储过程的参数??有例子最好,谢谢!!!
- 菜鸟请教Webservice问题
- 用TcpListener开始监听,关闭的时候怎么中止全部子线程?
- C# 窗体程序里生成一张图片???
- 最近学习C#做一个行业软件
- 女朋友做手术成功!从死神拿夺了一条命回来,散分祝贺!
- C# 如何获得 数组值的下标?
- 大家做的项目 千行代码bug率是多少
- winfrom 水晶报表上加条码?急。。。。
XmlDocument xml = new XmlDocument();
xml.Load(Path.Combine(Application.StartupPath, "xxx.xml"));//应用程序同一目录 .exe目录
XmlNodeList xn = xml.SelectNodes("books/book");
DataTable xmltable = new DataTable();
//定义表标题
foreach (XmlNode x in xn)
{
foreach (XmlNode xx in x.ChildNodes)
{
DataColumn col = new DataColumn(xx.Name.ToString());
xmltable.Columns.Add(col);
}
break;
}
foreach (XmlNode x in xn)
{
DataRow dr = xmltable.NewRow();
for (int i = 0; i < x.ChildNodes.Count; i++)
{
XmlNode xx = x.SelectSingleNode(xmltable.Columns.ToString());
dr = xx.InnerText;
}
xmltable.Rows.Add(dr);
}然后批插入
xml.Load(Path.Combine(Application.StartupPath, "xml.xml"));//应用程序同一目录 .exe目录
XmlNodeList xn = xml.SelectNodes("books/book");
DataTable xmltable = new DataTable();
//定义表标题
foreach (XmlNode x in xn)
{
foreach (XmlNode xx in x.ChildNodes)
{
DataColumn col = new DataColumn(xx.Name.ToString());
xmltable.Columns.Add(col);
}
break;
}
foreach (XmlNode x in xn)
{
DataRow dr = xmltable.NewRow();
for (int i = 0; i < x.ChildNodes.Count; i++)
{
XmlNode xx = x.SelectSingleNode(xmltable.Columns[i].ToString());
dr[i] = xx.InnerText;
}
xmltable.Rows.Add(dr);
} dataGridView1.DataSource = xmltable;