xml create

 //---test.aspx.cs
//---update 2009-11-12 am 10:40
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using DCRM.BizRules;
using System.IO;
using System.Xml;
using System.Text;

namespace DCRM.Personnel.Web
{
    public partial class test : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            BizRules.PersonnelDAL pl = new PersonnelDAL();
            DataTable dt = pl.Getposition();
            StringBuilder str = new StringBuilder();
            str.Append(DataTableToXml(dt));
            this.CreateXml(str.ToString(), "test.xml");
            Response.Write("生成test.xml成功");
        }

        /// <summary>
        /// 生成文件
        /// </summary>
        /// <param name="val"></param>
        /// <param name="filename"></param>
        public void CreateXml(string val, string filename)
        {
            UnicodeEncoding ucode = new UnicodeEncoding();
            StreamWriter sw = new StreamWriter(Server.MapPath(filename));
            sw.WriteLine("<?xml version=/"1.0/" encoding=/"utf-8/"?>");
            sw.WriteLine(val);
            sw.Close();
            sw.Dispose();
        }

        /// <summary>
        /// 转换成XML格式字符串
        /// </summary>
        /// <param name="dt"></param>
        /// <returns></returns>
        public string DataTableToXml(DataTable dt)
        {
            StringBuilder strXml = new StringBuilder();
            strXml.AppendLine("<XmlTable>");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                strXml.AppendLine(" <rows>");
                for (int j = 0; j < dt.Columns.Count; j++)
                {
                    strXml.AppendLine("  <" + dt.Columns[j].ColumnName + ">" + dt.Rows[i][j] + "</" + dt.Columns[j].ColumnName + ">");
                }
                strXml.AppendLine(" </rows>");
            }
            strXml.AppendLine("</XmlTable>");
            return strXml.ToString();
        } 

    }
}

 

//---2001

        #region 获取职务DataTable
        /// <summary>
        ///
        /// </summary>
        /// <returns></returns>
        public DataTable Getposition()
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append(" select position_id,position_name,position_desc ");
            strSql.Append(" from " + Utils.getFianaceDbMain() + ".dbo.position");
            DAOClient daoCRM = new DAOClient("CRM");
            DataTable dt = daoCRM.GetDataTable(strSql.ToString());

            return dt;
        }
        #endregion

 //---3001

 

protected void Page_Load(object sender, EventArgs e)
{
  if (!Page.IsPostBack)
  {
      string strPath = Server.MapPath("source/media.XML");
      LoadDataFromXML(strPath);
      UserControlId.SelectedIndex = UserControlId.Items.IndexOf(UserControlId.Items.FindByValue(SetValue.ToString()));
      UserControlId.Enabled = SetEnabled;
  }
}

protected void LoadDataFromXML(string strPath)
{
  DataSet ds = new DataSet();
  ds.ReadXml(strPath);
  UserControlId.DataSource = ds.Tables[0];
  UserControlId.DataTextField = "mediaName";
  UserControlId.DataValueField = "mediaID";
  UserControlId.DataBind();
}