Spread for ASP.NET 7.0 Product Documentation
Insert Method
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > FilterColumnDefinitionCollection Class : Insert Method


index
Zero-based index at which to insert the filter column definition
fcd
Filter column definition to insert into the collection

Glossary Item Box

Inserts a filter column definition into the collection at the specified index.

Syntax

Visual Basic (Declaration) 
Public Overridable Sub Insert( _
   ByVal index As Integer, _
   ByVal fcd As FilterColumnDefinition _
) 
Visual Basic (Usage)Copy Code
Dim instance As FilterColumnDefinitionCollection
Dim index As Integer
Dim fcd As FilterColumnDefinition
 
instance.Insert(index, fcd)
C# 
public virtual void Insert( 
   int index,
   FilterColumnDefinition fcd
)

Parameters

index
Zero-based index at which to insert the filter column definition
fcd
Filter column definition to insert into the collection

Exceptions

ExceptionDescription
System.ArgumentNullException Filter column definition is not specified or is null

Example

This example inserts a filtered column into the collection.
C#Copy Code
FarPoint.Web.Spread.NamedStyle instyle = new FarPoint.Web.Spread.NamedStyle(); 
FarPoint.Web.Spread.NamedStyle outstyle = new FarPoint.Web.Spread.NamedStyle(); 
instyle.BackColor = Color.Yellow; 
outstyle.BackColor = Color.Aquamarine; 
FarPoint.Web.Spread.FilterColumnDefinitionCollection fcdc = new FarPoint.Web.Spread.FilterColumnDefinitionCollection(); 
FarPoint.Web.Spread.FilterColumnDefinition fcd = new FarPoint.Web.Spread.FilterColumnDefinition(1, FarPoint.Web.Spread.FilterListBehavior.SortByMostOccurrences
| FarPoint.Web.Spread.FilterListBehavior.Default); 
FarPoint.Web.Spread.FilterColumnDefinition fcd1 = new FarPoint.Web.Spread.FilterColumnDefinition(2, FarPoint.Web.Spread.FilterListBehavior.Default);

FarPoint.Web.Spread.FilterColumnDefinition fcd2 = new FarPoint.Web.Spread.FilterColumnDefinition(3); 
fcdc.Insert(0, fcd); 
fcdc.Insert(1, fcd1); 
fcdc.Insert(2, fcd2); 
FarPoint.Web.Spread.StyleRowFilter sf = new FarPoint.Web.Spread.StyleRowFilter(FpSpread1.ActiveSheetView, instyle, outstyle);

foreach (FarPoint.Web.Spread.FilterColumnDefinition x in fcdc) 
{ 
 sf.AddColumn(x); 
}
int i = fcdc.IndexOf(fcd);
Visual BasicCopy Code
Dim instyle As New FarPoint.Web.Spread.NamedStyle
Dim outstyle As New FarPoint.Web.Spread.NamedStyle
instyle.BackColor = Color.Yellow
outstyle.BackColor = Color.Aquamarine
Dim fcdc As New FarPoint.Web.Spread.FilterColumnDefinitionCollection
Dim fcd As New FarPoint.Web.Spread.FilterColumnDefinition(1, FarPoint.Web.Spread.FilterListBehavior.SortByMostOccurrences
Or FarPoint.Web.Spread.FilterListBehavior.Default)
Dim fcd1 As New FarPoint.Web.Spread.FilterColumnDefinition(2, FarPoint.Web.Spread.FilterListBehavior.Default)
Dim fcd2 As New FarPoint.Web.Spread.FilterColumnDefinition(3)
fcdc.Insert(0, fcd)
fcdc.Insert(1, fcd1)
fcdc.Insert(2, fcd2)
Dim sf As New FarPoint.Web.Spread.StyleRowFilter(FpSpread1.ActiveSheetView, instyle, outstyle)
Dim x As FarPoint.Web.Spread.FilterColumnDefinition
For Each x In fcdc
      sf.AddColumn(x)
Next
Dim i As Integer
i = fcdc.IndexOf(fcd)

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.