DataGridView的一些操作

        /// <summary>
        /// 设定DataGridView中的表头文字-已经绑定了数据，只是添加一个表头（汉字）
        /// </summary>
        /// <param name="str">表头字符串，一“，”分割</param>
        /// <param name="DGV">dataGridView</param>
        public static void BindDataGridViewHead(string str, DataGridView DGV)
        {
            if (str != string.Empty)
            {
                string[] temp = str.Split(',');
                int i = 0;
                foreach (string strHead in temp)
                {
                    DGV.Columns[i].HeaderText = strHead;
                    i++;
                }
            }
        }


        /// <summary>
        /// 绑定一个空的DataGridView（没有数据）
        /// </summary>
        /// <param name="str">表头字符串，一“，”分割</param>
        /// <param name="DGV"></param>
        public static void BindDataGridViewHeadNull(string str, DataGridView DGV)
        {
            if (str != string.Empty)
            {
                string[] temp = str.Split(',');
                DataTable newTable = new DataTable();
                foreach (string strHead in temp)
                {
                    newTable.Columns.Add(strHead, typeof(string));
                }
                DGV.DataSource = newTable;
            }
        }

 

 

        /// <summary>
        /// DataGridView的行号显示
       /// </summary>
       /// <param name="GV"></param>
       /// <param name="e"></param>
        public static void DisDataGridViewRowsNum(DataGridView GV, DataGridViewRowPostPaintEventArgs e)
        {
            try
            {
                Rectangle rec = new Rectangle(e.RowBounds.Location.X, Convert.ToInt32(e.RowBounds.Location.Y + (e.RowBounds.Height - GV.RowHeadersDefaultCellStyle.Font.Size) / 2), GV.RowHeadersWidth - 4, e.RowBounds.Height);
                TextRenderer.DrawText(e.Graphics, (e.RowIndex + 1).ToString(), GV.RowHeadersDefaultCellStyle.Font, rec, GV.RowHeadersDefaultCellStyle.ForeColor, TextFormatFlags.Right);
            }
            catch (Exception)
            {
                throw;
            }
        }


         /// <summary>
        /// 将DataGridView控件中数据导出到Excel
        /// </summary>
        /// <param name="gridView">DataGridView对象</param>
        /// <param name="isShowExcle">是否显示Excel界面</param>
        /// <returns></returns>
        public static bool ExportDataGridview(DataGridView gridView, bool isShowExcle)
        {
            if (gridView.Rows.Count == 0)
                return false;
            //建立Excel对象
            Excel.Application excel = new Excel.Application();
            excel.Application.Workbooks.Add(true);
            excel.Visible = isShowExcle;
            //生成字段名称
            for (int i = 0; i < gridView.ColumnCount; i++)
            {
                excel.Cells[1, i + 1] = gridView.Columns[i].HeaderText;
            }
            //填充数据
            for (int i = 0; i < gridView.RowCount; i++)
            {
                for (int j = 0; j < gridView.ColumnCount; j++)
                {
                    if (gridView[j, i].ValueType == typeof(string))
                    {
                        excel.Cells[i + 2, j + 1] = "'" + gridView[j, i].Value.ToString();
                    }
                    else
                    {
                        excel.Cells[i + 2, j + 1] = gridView[j, i].Value.ToString();
                    }
                }
            }
            return true;
        }