AddRange Method (CellStyleCollection)

Visual Basic (Declaration)
Visual Basic (Usage)
C#

Public Sub AddRange( _
   ByVal items As IEnumerable(Of CellStyle) _
)

Dim instance As CellStyleCollection
Dim items As IEnumerable(Of CellStyle)
 
instance.AddRange(items)

public void AddRange( 
   IEnumerable<CellStyle> items
)

Parameters

items: The target CellStyle collection.

Exception	Description
System.ArgumentNullException	One of the items is a null reference (Nothing in Visual Basic).

The following code example shows how to combine two predefined CellStyles to generate the required CellStyle object. The program sets the RoundedBorder to alternating columns. This code example is part of a larger example provided for the NamedCellStyle class.

C#

void SetBorderToAlternatingColumns(object sender, EventArgs e)
        {
            CellStyle borderCellStyle = new CellStyle();
            borderCellStyle.Border = new RoundedBorder(LineStyle.Thin, Color.Gray, 0.5f);

            CellStyle colorStyle = new CellStyle();
            colorStyle.BackColor = Color.Yellow;

            //The combinedCellStyle1 will merge borderCellStyle and AlternatingColumnsDefaultCellStyle.
            CombinedCellStyle combinedCellStyle1 = new CombinedCellStyle();
            combinedCellStyle1.Items.AddRange(new CellStyle[] { borderCellStyle, colorStyle });
            this.gcMultiRow1.NamedCellStyles["AlternatingColumnsDefaultCellStyle"] = combinedCellStyle1;
        }

VB.NET

Private Sub SetBorderToAlternatingColumns(ByVal sender As Object, ByVal e As EventArgs) Handles setBorder.Click
        Dim borderCellStyle As New CellStyle()
        borderCellStyle.Border = New RoundedBorder(LineStyle.Thin, Color.Gray, 0.5F)

        Dim colorStyle As New CellStyle()
        colorStyle.BackColor = Color.Yellow

        'The combinedCellStyle1 will merge borderCellStyle and AlternatingColumnsDefaultCellStyle.
        Dim combinedCellStyle1 As New CombinedCellStyle()
        combinedCellStyle1.Items.AddRange(New CellStyle() {borderCellStyle, colorStyle})
        Me.gcMultiRow1.NamedCellStyles("AlternatingColumnsDefaultCellStyle") = combinedCellStyle1
    End Sub

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

CellStyleCollection Class
CellStyleCollection Members