class1.cs

C#2005 实例源代码

using System;
using System.Data;
using System.Data.SqlClient;
using System.Xml;

namespace XmlDataDocument_DataSetToXml
{

	/// <summary>
	/// 使用XmlDataDocument加载关系数据
	/// </summary>
	class T
	{
		/// <summary>
		/// 使用XmlDataDocument加载关系数据
		/// </summary>
		public void DataSetToXml()
		{
			//连接数据库
			SqlConnection myCon = new SqlConnection();
			myCon.ConnectionString = "Persist Security Info=False;User id=sa;pwd=sa;database=northwind;server=172.28.75.13";
			myCon.Open();

			//使用SqlCommand提交查询命令
			SqlCommand selectCMD = new SqlCommand("SELECT top 10 CustomerID, CompanyName FROM Customers", myCon);

			//获取数据适配器
			SqlDataAdapter custDA = new SqlDataAdapter();
			custDA.SelectCommand = selectCMD;

			//填充DataSet
			DataSet custDS = new DataSet();
			custDA.Fill(custDS, "Customers");
			custDS.EnforceConstraints=false;
			//显示XML格式的数据
			//Console.WriteLine("{0}",custDS.GetXml());

			//构造XML
			XmlDataDocument xddoc=new XmlDataDocument(custDS);
			
			//查找并修改
			string xpath="descendant::CompanyName[/NewDataSet/Customers[CustomerID='ANATR']]";
			XmlNode xnode=xddoc.SelectSingleNode(xpath);
			//Console.WriteLine(xnode.InnerText);
			xnode.InnerText="Test Company!";

			//输出在屏幕
			xddoc.Save(Console.Out);
			custDS.AcceptChanges();
		}


		/// <summary>
		/// 应用程序的主入口点。
		/// </summary>
		[STAThread]
		static void Main(string[] args)
		{
			T t=new T();
			t.DataSetToXml();
		}
	}
}