从DataSet中写入读取XML
来源:互联网 发布:怎么在淘宝上卖二手书 编辑:程序博客网 时间:2024/04/29 16:52
1、写入XML
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace UpdatingData
{
class Program
{
static void Main(string[] args)
{
SqlConnection thisConnection = new SqlConnection(@"Server = .sqlexpress;Integrated Security = true;" + "Database = northwind");
SqlDataAdapter thisAdapter = new SqlDataAdapter("SELECT CustomerID,CompanyName FROM Customers", thisConnection);
SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter);
DataSet thisDataSet = new DataSet();
SqlDataAdapter CustAdapter = new SqlDataAdapter("SELECT * FROM Customers", thisConnection);
SqlDataAdapter OrderAdapter = new SqlDataAdapter("SELECT * FROM Orders", thisConnection);
CustAdapter.Fill(thisDataSet,"Customers");
OrderAdapter.Fill(thisDataSet,"Orders");
DataRelation thisRelation = thisDataSet.Relations.Add("CustOrder",
thisDataSet.Tables["Customers"].Columns["CustomerID"],
thisDataSet.Tables["Orders"].Columns["CustomerID"]);
thisRelation.Nested = true;//relation对象的nested属性通知WriteXML()方法 将订单细节和订单嵌套在XML每个父客户之下 易于分析XML文件
thisDataSet.WriteXml(@"C: /tmp/winddata.xml");
Console.WriteLine(@"Successfully wrote xml output to file C:/tmp/winddata.xml");
//foreach (DataRow custRow in thisDataSet.Tables["Customers"].Rows)
//{
// Console.WriteLine(custRow["CustomerID"] +" "+ custRow["CompanyName"]);
// foreach (DataRow orderRow in custRow.GetChildRows(thisRelation))
// {
// Console.WriteLine(orderRow["OrderID"]);
// }
//}
//thisAdapter.Update(thisDataSet, "Customers");
thisConnection.Close();
}
}
}
红字是从DataSet中写入XML 兰字从DataSet中写入数据库
2、读取XML
DataSet thisDataSet = new DataSet();
thisDataSet.ReadXml(@"C:/tmp/nwinddata.xml");
foreach (DataRow custRow in thisDataSet.Tables["Customers"].Rows)
{
Console.WriteLine("CustomerID:" + custRow["CustomerID"] + "Name:" + custRow["CompanyName"]);
}
- 从DataSet中写入读取XML
- 通过DataSet从文件中读取Xml文档
- 将dataset中的数据写入xml中
- Android中写入读取XML
- Android中写入读取XML
- Android中写入读取XML
- dataset写入xml
- 从数据库中写入XML
- 从数据库中读取数据,并写入xml文件中(dom4j)
- 从XML读取记录集 DataSet ComBox下拉框
- Extjs2.0+gridPanel+checkbox读取从数据库中写入到xml文件的字段
- dataset读取xml
- DataSet 读取xml文件
- DataSet读取XML字串
- DataSet 读取XML
- DataSet 读取 Xml 文件
- PDA中XML的读取和写入
- MFC中读取写入XML文件
- c#.NET中开发可用于Web网页的ActiveX控件
- 给IT新人的建议
- Visual Studio 2010 IDE中的新功能(2)
- 新手小错
- Vi常用命令(二)编辑
- 从DataSet中写入读取XML
- 今天早上写的二叉树的建立及遍历
- Visual C++.net与Visual C++6.0使用之差别
- DateSet中访问多个表
- 游戏开发真功夫:游戏开发定律
- Models--自动生成实体层代码
- 数据库访问及其基本操作(sql server和添加删除查找替换)
- filestream和streamwrite/streamreader区别
- C#文件属性总结