DataGridView与XML文件的相互转存

来源：互联网发布：中国城市轨道交通知乎编辑：程序博客网时间：2024/05/17 16:14

注1：仍存在以下问题:

1. XML转存至dataGridview中时，不能自动生成行列，必须手动指定view的行列值。

2. datagridView转存至XML中时，丢失一行数据

注2：本人解决问题：

1.解决了 datagridView转存至XML后，丢失一行数据的问题

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.IO;using System.Windows.Forms;namespace DataDisplay{    class DataToXml    {        #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();            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}

private void btToXml_Click(object sender, EventArgs e)        {            //SaveFileDialog            dataGridView1.AutoGenerateColumns = true;            dataGridView1.ColumnCount = 5;            dataGridView1.RowCount = 5;            dataGridView1.AllowUserToAddRows = true;            for (int i = 0; i < 5; i++)            {                for (int j = 0; j < 5; j++)                {                    dataGridView1[i, j].Value = (i+j*2+3).ToString();                }            }               GridViewToXml.SerialDebug dia = new SerialDebug();            dia.DataGridViewToXml(this.dataGridView1,"data.xml");        }        private void btToView_Click(object sender, EventArgs e)        {            dataGridView2.AutoGenerateColumns = true;            dataGridView2.RowCount = 5;            dataGridView2.ColumnCount = 5;            GridViewToXml.SerialDebug dia = new SerialDebug();            dia.Xml2DataGridView(dataGridView2,"data.xml");        }

作者：wanglei_wan

出处：http://www.cnblogs.com/because/

0 0