DataGridView导出数据到XML

原文链接:http://www.cnblogs.com/WilliamJiang/archive/2012/06/04/2534985.html
using System;
using System.IO;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Drawing;
using System.Windows.Forms;

namespace Config
{

    class ExportHelper
    {

        #region " DataGridViewToXml "

        public void DataGridViewToXml(DataGridView dataGridView, String filePath)
        {
            DataGridViewToXml(new DataGridViewExportOptions(dataGridView), filePath);
        }

        public void DataGridViewToXml(DataGridViewExportOptions dataGridViewExportOption, String filePath)
        {
            DataGridViewToXml(new List<DataGridViewExportOptions>(new DataGridViewExportOptions[] { dataGridViewExportOption }), filePath);
        }

        public void DataGridViewToXml(List<DataGridViewExportOptions> dataGridViewExportOptions, String filePath)
        {
            if (dataGridViewExportOptions == null || dataGridViewExportOptions.Count == 0) return;

            DataSet dataSet = new DataSet("Lists");

            int sheetIndex = 1;
            List<String> sheetNames = new List<String>();
            try
            {
                foreach (DataGridViewExportOptions option in dataGridViewExportOptions)
                {
                    #region " 处理在多个 DataGridView 设置为相同的表名称的问题 "
                    if (sheetNames.Contains(option.WorkSheetName))
                    {
                        int i = 1;
                        while (true)
                        {
                            string newSheetName = option.WorkSheetName + i.ToString();
                            if (!sheetNames.Contains(newSheetName))
                            {
                                sheetNames.Add(newSheetName);
                                option.WorkSheetName = newSheetName;
                                break;
                            }
                            i++;
                        }
                    }
                    else
                    {
                        sheetNames.Add(option.WorkSheetName);
                    }
                    DataGridViewFillToDataSet(dataSet, option);
                    sheetIndex++;
                    #endregion
                }
                ExportToXml(dataSet, filePath);
            }
            finally
            {
                dataSet.Dispose();
                GC.Collect();
            }
        }

        // 处理 DataGridView 中的数据以填充到指定的 DataSet 中    
        private void DataGridViewFillToDataSet(DataSet dataSet, DataGridViewExportOptions Option)
        {
            DataTable Table = new DataTable();
            Table.TableName = Option.WorkSheetName;

            if (Option.DataGridView == null) return;

            #region " 填充表头内容 "

            foreach (DataColumnExportOptions option in Option.VisibleColumnOptions)
            {
                if (!option.Visible) continue;
                Table.Columns.Add(new DataColumn(option.ColumnName));
            }

            #endregion

            #region " 填充表格正文内容 "

            foreach (DataGridViewRow dataRow in Option.DataGridView.Rows)
            {
                if (dataRow.IsNewRow) continue;

                DataRow Row = Table.NewRow();
                foreach (DataColumnExportOptions option in Option.VisibleColumnOptions)
                {
                    if (dataRow.Cells[option.ColumnName].Value == null)
                    {
                        Row[option.ColumnName] = "";
                    }
                    else
                    {
                        Row[option.ColumnName] = dataRow.Cells[option.ColumnName].Value.ToString();
                    }
                }
                Table.Rows.Add(Row);
            }

            #endregion
            dataSet.Tables.Add(Table);
        }

        #endregion

        #region " ExportToXml "
        /// <summary>    
        /// 保存 DataSet 数据到 Xml 文件    
        /// </summary>    
        /// <param name="dataSet">DataSet数据对象</param>    
        /// <param name="filePath">Xml 文件地址</param>
        private void ExportToXml(DataSet dataSet, String filePath)
        {
            #region " 判断文件是否存在,存在则删除原有文件 "
            try
            {
                if (File.Exists(filePath)) File.Delete(filePath);
            }
            catch
            {
                return;
            }
            #endregion

            dataSet.WriteXml(filePath);
        }
        #endregion

        #region ImportXML
        public void Xml2DataGridView(DataGridView dataGridView, String filePath)
        {
            System.Data.DataSet dataSet1 = new System.Data.DataSet(); ;
            dataGridView.Rows.Clear();
            dataSet1.ReadXml(filePath, XmlReadMode.Auto);

            DataTable dt = dataSet1.Tables[0];
            dataGridView.Rows.Add(dt.Rows.Count);
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                object[] data = dt.Rows[i].ItemArray;
                for (int j = 0; j < data.Length; j++)
                {
                    dataGridView[j, i].Value = data[j];
                }
            }
        }
        #endregion


    }


    #region " DataColumnExportOptions "
    /// <summary>    
    /// 导出数据字段属性选项类    
    /// </summary>
    class DataColumnExportOptions
    {
        private String _ColumnName;
        private String _Caption;
        private Boolean _Visible;
        /// <summary>    
        /// 字段名称    
        /// </summary>
        public String ColumnName
        {
            get { return _ColumnName; }
            set { _ColumnName = value; }
        }
        /// <summary>    
        /// 字段标题    
        /// </summary>
        public String Caption
        {
            get { return _Caption; }
            set { _Caption = value; }
        }
        /// <summary>    
        /// 是否显示(导出)    
        /// </summary>
        public Boolean Visible
        {
            get { return _Visible; }
            set { _Visible = value; }
        }
        /// <summary>    
        /// 构造函数    
        /// </summary>    
        /// <param name="fColumnName">字段名称</param>
        public DataColumnExportOptions(String columnName)
            : this(columnName, columnName)
        {

        }
        /// <summary>    
        /// 构造函数    
        /// </summary>    
        /// <param name="fColumnName">字段名称</param>    
        /// <param name="fCaption">字段标题</param>
        public DataColumnExportOptions(String columnName, String caption)
            : this(columnName, caption, true)
        {

        }
        /// <summary>    
        /// 构造函数    
        /// </summary>    
        /// <param name="fColumnName">字段名称</param>    
        /// <param name="fCaption">字段标题</param>    
        /// <param name="fVisible">是否显示(导出)</param>
        public DataColumnExportOptions(String columnName, String caption, Boolean visible)
        {
            this._ColumnName = columnName;
            this._Caption = caption;
            this._Visible = visible;
        }
    }
    #endregion

    #region " DataGridViewExportOptions “

    class DataGridViewExportOptions
    {
        private DataGridView _DataGridView;
        private List<DataColumnExportOptions> _ColumnOptions;
        private List<DataColumnExportOptions> _VisibleColumnOptions;
        private String _WorkSheetName;

        /// <summary>    
        /// 要导出到DataGridView对象    
        /// </summary>
        public DataGridView DataGridView
        {
            get { return _DataGridView; }
            set { _DataGridView = value; }
        }
        /// <summary>    
        /// 导出的字段属性列表    
        /// </summary>
        public List<DataColumnExportOptions> ColumnOptions
        {
            get { return _ColumnOptions; }
            set { _ColumnOptions = value; }
        }
        /// <summary>    
        /// 要导出的字段列表(只读)    
        /// </summary>
        public List<DataColumnExportOptions> VisibleColumnOptions
        {
            get { return _VisibleColumnOptions; }
        }
        /// <summary>    
        /// 导出的工作表名称    
        /// </summary>
        public String WorkSheetName
        {
            get { return _WorkSheetName; }
            set { _WorkSheetName = value; }
        }
        /// <summary>    
        /// 构造函数    
        /// </summary>    
        /// <param name="dataGridView">要导出到DataGridView对象</param>
        public DataGridViewExportOptions(DataGridView dataGridView)
            : this(dataGridView, null)
        { }
        /// <summary>    
        /// 构造函数    
        /// </summary>    
        /// <param name="dataGridView">要导出到DataGridView对象</param>    
        /// <param name="columnOptions">导出的字段属性列表</param>
        public DataGridViewExportOptions(DataGridView dataGridView, List<DataColumnExportOptions> columnOptions)
            : this(dataGridView, columnOptions, null) { }
        /// <summary>    
        /// 构造函数    
        /// </summary>    
        /// <param name="dataGridView">要导出到DataGridView对象</param>    
        /// <param name="columnOptions">导出的字段属性列表</param>    
        /// <param name="workSheetName">导出生成的工作表名称</param>
        public DataGridViewExportOptions(DataGridView dataGridView, List<DataColumnExportOptions> columnOptions, String workSheetName)
        {
            if (dataGridView == null) return;

            this._DataGridView = dataGridView;
            if (columnOptions == null)
            {
                this._ColumnOptions = new List<DataColumnExportOptions>();
                foreach (DataGridViewColumn dataColumn in dataGridView.Columns)
                    this._ColumnOptions.Add(new DataColumnExportOptions(dataColumn.Name, dataColumn.HeaderText, dataColumn.Visible));
            }
            else
            {
                this._ColumnOptions = columnOptions;
            }

            if (String.IsNullOrEmpty(workSheetName))
                this._WorkSheetName = dataGridView.Name;
            else
                this._WorkSheetName = workSheetName;

            this._VisibleColumnOptions = new List<DataColumnExportOptions>();
            foreach (DataColumnExportOptions option in this._ColumnOptions)
            {
                if (option.Visible)
                    this._VisibleColumnOptions.Add(option);
            }
        }
    }

    #endregion






}

转载于:https://www.cnblogs.com/WilliamJiang/archive/2012/06/04/2534985.html

上一篇:在CentOS上安装ZooKeeper集群


下一篇:布尔单元格的Winforms DataGridView中的自定义图像替换默认复选框