Spread ASP.NET 6.0 Product Documentation
Insert Method
See Also  Example Send Feedback
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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.