C# DataGridView中如何合并某一行所有单元格??

时间:2022-09-20 00:57:17
在DataGridView中新添加一行,第一个单元格的内容为ssss,其他为空,并对这一行的所有单元格进行合并,并设置一个特殊颜色来标记

7 个解决方案

#2


没明白楼主的意思

#3


引用 2 楼 plahushiyu 的回复:
没明白楼主的意思


就是在这个datagridview里面任意位置插入一行,这一行的第一个单元格内容是ssss。插入这一行之后对其所有单元格进行合并

#4


#region"合并单元格的测试"
        private int? nextrow = null;
        private int? nextcol = null;
        private void dataGridView1_CellFormatting(object sender, System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
        ...{
            if (this.dataGridView1.Columns["description"].Index == e.ColumnIndex && e.RowIndex >= 0)
            ...{
                if (this.nextcol != null & e.ColumnIndex == this.nextcol)
                ...{
                    e.CellStyle.BackColor = Color.LightBlue;
                    this.nextcol = null;
                }
                if (this.nextrow != null & e.RowIndex == nextrow)
                ...{
                    e.CellStyle.BackColor = Color.LightPink;
                    this.nextrow = null;
                }
                if (e.RowIndex != this.dataGridView1.RowCount - 1)
                ...{
                    if (e.Value.ToString() == this.dataGridView1.Rows[e.RowIndex + 1].Cells[e.ColumnIndex].Value.ToString())
                    ...{
                        e.CellStyle.BackColor = Color.LightPink;
                        nextrow = e.RowIndex + 1;
                    }
                }

            }
            if (this.dataGridView1.Columns["name"].Index == e.ColumnIndex && e.RowIndex >= 0)
            ...{
                if (e.Value.ToString() == this.dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex + 1].Value.ToString())
                ...{
                    e.CellStyle.BackColor = Color.LightBlue;
                    nextcol = e.ColumnIndex + 1;
                }
            }
        }
        //==========================
       
        //绘制单元格
        private void dataGridView1_CellPainting(object sender, System.Windows.Forms.DataGridViewCellPaintingEventArgs e)
        ...{

 

            //纵向合并
            if (this.dataGridView1.Columns["description"].Index == e.ColumnIndex && e.RowIndex >= 0)
            ...{

                using (
                    Brush gridBrush = new SolidBrush(this.dataGridView1.GridColor),
                    backColorBrush = new SolidBrush(e.CellStyle.BackColor))
                ...{
                    using (Pen gridLinePen = new Pen(gridBrush))
                    ...{
                        // 擦除原单元格背景
                        e.Graphics.FillRectangle(backColorBrush, e.CellBounds);
                        /**/////绘制线条,这些线条是单元格相互间隔的区分线条,
                        ////因为我们只对列name做处理,所以datagridview自己会处理左侧和上边缘的线条
                        if (e.RowIndex != this.dataGridView1.RowCount - 1)
                        ...{
                            if (e.Value.ToString() != this.dataGridView1.Rows[e.RowIndex + 1].Cells[e.ColumnIndex].Value.ToString())
                            ...{

                                e.Graphics.DrawLine(gridLinePen, e.CellBounds.Left, e.CellBounds.Bottom - 1,
                                e.CellBounds.Right - 1, e.CellBounds.Bottom - 1);//下边缘的线
                                //绘制值
                                if (e.Value != null)
                                ...{
                                    e.Graphics.DrawString((String)e.Value, e.CellStyle.Font,
                                        Brushes.Crimson, e.CellBounds.X + 2,
                                        e.CellBounds.Y + 2, StringFormat.GenericDefault);
                                }
                            }
                        }
                        else
                        ...{
                            e.Graphics.DrawLine(gridLinePen, e.CellBounds.Left, e.CellBounds.Bottom - 1,
                                e.CellBounds.Right - 1, e.CellBounds.Bottom - 1);//下边缘的线
                            //绘制值
                            if (e.Value != null)
                            ...{
                                e.Graphics.DrawString((String)e.Value, e.CellStyle.Font,
                                    Brushes.Crimson, e.CellBounds.X + 2,
                                    e.CellBounds.Y + 2, StringFormat.GenericDefault);
                            }
                        }
                        //右侧的线
                        e.Graphics.DrawLine(gridLinePen, e.CellBounds.Right - 1,
                            e.CellBounds.Top, e.CellBounds.Right - 1,
                            e.CellBounds.Bottom - 1);

                        e.Handled = true;
                    }
                }
            }

            //横向合并
            if (this.dataGridView1.Columns["name"].Index == e.ColumnIndex && e.RowIndex >= 0)
            ...{

                using (
                    Brush gridBrush = new SolidBrush(this.dataGridView1.GridColor),
                    backColorBrush = new SolidBrush(e.CellStyle.BackColor))
                ...{
                    using (Pen gridLinePen = new Pen(gridBrush))
                    ...{
                        // 擦除原单元格背景
                        e.Graphics.FillRectangle(backColorBrush, e.CellBounds);

                        if (e.Value.ToString() != this.dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex + 1].Value.ToString())
                        ...{

                            //右侧的线
                            e.Graphics.DrawLine(gridLinePen, e.CellBounds.Right - 1, e.CellBounds.Top,
                                e.CellBounds.Right - 1, e.CellBounds.Bottom - 1);
                            //绘制值
                            if (e.Value != null)
                            ...{
                                e.Graphics.DrawString((String)e.Value, e.CellStyle.Font,
                                    Brushes.Crimson, e.CellBounds.X + 2,
                                    e.CellBounds.Y + 2, StringFormat.GenericDefault);
                            }
                        }

                        //下边缘的线
                        e.Graphics.DrawLine(gridLinePen, e.CellBounds.Left, e.CellBounds.Bottom - 1,
                                                    e.CellBounds.Right - 1, e.CellBounds.Bottom - 1);
                        e.Handled = true;
                    }
                }

            }

        }

        #endregion

本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/csharp_start/archive/2007/09/30/1808000.aspx

#5


gg

#7


要是把一列的不通的值显示在一行,条件是其他的属性都一样,该怎么办??

#1


#2


没明白楼主的意思

#3


引用 2 楼 plahushiyu 的回复:
没明白楼主的意思


就是在这个datagridview里面任意位置插入一行,这一行的第一个单元格内容是ssss。插入这一行之后对其所有单元格进行合并

#4


#region"合并单元格的测试"
        private int? nextrow = null;
        private int? nextcol = null;
        private void dataGridView1_CellFormatting(object sender, System.Windows.Forms.DataGridViewCellFormattingEventArgs e)
        ...{
            if (this.dataGridView1.Columns["description"].Index == e.ColumnIndex && e.RowIndex >= 0)
            ...{
                if (this.nextcol != null & e.ColumnIndex == this.nextcol)
                ...{
                    e.CellStyle.BackColor = Color.LightBlue;
                    this.nextcol = null;
                }
                if (this.nextrow != null & e.RowIndex == nextrow)
                ...{
                    e.CellStyle.BackColor = Color.LightPink;
                    this.nextrow = null;
                }
                if (e.RowIndex != this.dataGridView1.RowCount - 1)
                ...{
                    if (e.Value.ToString() == this.dataGridView1.Rows[e.RowIndex + 1].Cells[e.ColumnIndex].Value.ToString())
                    ...{
                        e.CellStyle.BackColor = Color.LightPink;
                        nextrow = e.RowIndex + 1;
                    }
                }

            }
            if (this.dataGridView1.Columns["name"].Index == e.ColumnIndex && e.RowIndex >= 0)
            ...{
                if (e.Value.ToString() == this.dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex + 1].Value.ToString())
                ...{
                    e.CellStyle.BackColor = Color.LightBlue;
                    nextcol = e.ColumnIndex + 1;
                }
            }
        }
        //==========================
       
        //绘制单元格
        private void dataGridView1_CellPainting(object sender, System.Windows.Forms.DataGridViewCellPaintingEventArgs e)
        ...{

 

            //纵向合并
            if (this.dataGridView1.Columns["description"].Index == e.ColumnIndex && e.RowIndex >= 0)
            ...{

                using (
                    Brush gridBrush = new SolidBrush(this.dataGridView1.GridColor),
                    backColorBrush = new SolidBrush(e.CellStyle.BackColor))
                ...{
                    using (Pen gridLinePen = new Pen(gridBrush))
                    ...{
                        // 擦除原单元格背景
                        e.Graphics.FillRectangle(backColorBrush, e.CellBounds);
                        /**/////绘制线条,这些线条是单元格相互间隔的区分线条,
                        ////因为我们只对列name做处理,所以datagridview自己会处理左侧和上边缘的线条
                        if (e.RowIndex != this.dataGridView1.RowCount - 1)
                        ...{
                            if (e.Value.ToString() != this.dataGridView1.Rows[e.RowIndex + 1].Cells[e.ColumnIndex].Value.ToString())
                            ...{

                                e.Graphics.DrawLine(gridLinePen, e.CellBounds.Left, e.CellBounds.Bottom - 1,
                                e.CellBounds.Right - 1, e.CellBounds.Bottom - 1);//下边缘的线
                                //绘制值
                                if (e.Value != null)
                                ...{
                                    e.Graphics.DrawString((String)e.Value, e.CellStyle.Font,
                                        Brushes.Crimson, e.CellBounds.X + 2,
                                        e.CellBounds.Y + 2, StringFormat.GenericDefault);
                                }
                            }
                        }
                        else
                        ...{
                            e.Graphics.DrawLine(gridLinePen, e.CellBounds.Left, e.CellBounds.Bottom - 1,
                                e.CellBounds.Right - 1, e.CellBounds.Bottom - 1);//下边缘的线
                            //绘制值
                            if (e.Value != null)
                            ...{
                                e.Graphics.DrawString((String)e.Value, e.CellStyle.Font,
                                    Brushes.Crimson, e.CellBounds.X + 2,
                                    e.CellBounds.Y + 2, StringFormat.GenericDefault);
                            }
                        }
                        //右侧的线
                        e.Graphics.DrawLine(gridLinePen, e.CellBounds.Right - 1,
                            e.CellBounds.Top, e.CellBounds.Right - 1,
                            e.CellBounds.Bottom - 1);

                        e.Handled = true;
                    }
                }
            }

            //横向合并
            if (this.dataGridView1.Columns["name"].Index == e.ColumnIndex && e.RowIndex >= 0)
            ...{

                using (
                    Brush gridBrush = new SolidBrush(this.dataGridView1.GridColor),
                    backColorBrush = new SolidBrush(e.CellStyle.BackColor))
                ...{
                    using (Pen gridLinePen = new Pen(gridBrush))
                    ...{
                        // 擦除原单元格背景
                        e.Graphics.FillRectangle(backColorBrush, e.CellBounds);

                        if (e.Value.ToString() != this.dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex + 1].Value.ToString())
                        ...{

                            //右侧的线
                            e.Graphics.DrawLine(gridLinePen, e.CellBounds.Right - 1, e.CellBounds.Top,
                                e.CellBounds.Right - 1, e.CellBounds.Bottom - 1);
                            //绘制值
                            if (e.Value != null)
                            ...{
                                e.Graphics.DrawString((String)e.Value, e.CellStyle.Font,
                                    Brushes.Crimson, e.CellBounds.X + 2,
                                    e.CellBounds.Y + 2, StringFormat.GenericDefault);
                            }
                        }

                        //下边缘的线
                        e.Graphics.DrawLine(gridLinePen, e.CellBounds.Left, e.CellBounds.Bottom - 1,
                                                    e.CellBounds.Right - 1, e.CellBounds.Bottom - 1);
                        e.Handled = true;
                    }
                }

            }

        }

        #endregion

本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/csharp_start/archive/2007/09/30/1808000.aspx

#5


gg

#6


#7


要是把一列的不通的值显示在一行,条件是其他的属性都一样,该怎么办??