用XML填充DataSet

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Xml;

public partial class Default4 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            DataSet ds = GetDataSet();
            MyGridView.DataSource = ds;
            MyGridView.DataBind();
        }
    }


    private DataSet GetDataSet()
    {
        DataSet ds = new DataSet();
        DataTable dataTable = new DataTable("Users");
        dataTable.Columns.Add("UserID", typeof(int));
        dataTable.Columns.Add("UserName");
        dataTable.Columns.Add("RealName");
        dataTable.Columns.Add("CreateDate", typeof(DateTime));
        try
        {
            XmlDocument doc = new XmlDocument();
            doc.Load(Server.MapPath("xmlfile.xml"));
            if (doc == null)
            {
                return null;
            }
            XmlNodeList nodeList = doc.SelectNodes("/Users/Users");
            foreach (XmlNode node in nodeList)
            {
                DataRow row = dataTable.NewRow();
                row["UserID"] = Convert.ToInt32(node.Attributes["UserID"].Value);
                row["UserName"] = node.Attributes["UserName"].Value;
                row["RealName"] = node.Attributes["RealName"].Value;
                row["CreateDate"] = Convert.ToDateTime(node.Attributes["CreateDate"].Value);
                dataTable.Rows.Add(row);
            }
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }
        ds.Tables.Add(dataTable);
        return (ds);
    }


}
//下面是对应xmlfile.xml的结构


<?xml version="1.0"?>
<Users>
  <Users UserID="1" UserName="Admin" RealName="Admin" Password="Admin" Address="1" Phone="010-10000000" Mobile="123@123.com" Email="13810000000" CreateDate="1980-10-01T00:00:00" Status="1" RoleID="1" Remark="" />
</Users>