作者:笑笑

连接:笑笑博客 http://www.oucao.com.cn

文档对象模型（Document Object Model,DOM）:
是XML文档的编程接口
定义如何在程序中访问和操作XML文档
是与平台和语言无关的借口
以树结构表示XML文档
通过提供一组对象对XML文档结构的访问
定义用于访问和操作XML文档的API

新建控制台应用程序敲入以下代码均可实现功能

using System;
using System.Collections.Generic;
using System.Text;
using System.Xml;
using System.Data;
using System.Data.SqlClient;

namespace readSql
{
    class Program
    {
        static void Main(string[] args)
        {
            //创建document对象
            XmlDocument doc = new XmlDocument();
            //根元素
            XmlElement root = doc.CreateElement("students");
            doc.AppendChild(root);

            SqlCommand cmd = new SqlCommand();
            cmd.Connection = new SqlConnection("SERVER=.;DATABASE=stu;UID=sa;PWD=ok");

            cmd.CommandText = "select stuId ,stuName ,stuAge from student";

            cmd.Connection.Open();
            SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

            if(dr.HasRows)
            {
                while(dr.Read())
                {
                    XmlElement stu = doc.CreateElement("student");
                    root.AppendChild(stu);

                    stu.SetAttribute("stuId", ((int)dr[0]).ToString());

                    XmlElement name = doc.CreateElement("stuName");
                    name.InnerText = (string)dr[1];
                    stu.AppendChild(name);

                    XmlElement age = doc.CreateElement("stuAge");
                    age.InnerText = (string)dr[2];
                    stu.AppendChild(age);

                }
              
            }
            dr.Close();
            doc.Save("students.xml");

        }
    }
}