Spread for ASP.NET 11 Product Documentation
IsRowBound Method (SheetView)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : IsRowBound Method
Row index
Gets whether the specified row is bound to a data source.
Syntax
'Declaration
 
Public Function IsRowBound( _
   ByVal row As Integer _
) As Boolean
'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim value As Boolean
 
value = instance.IsRowBound(row)
public bool IsRowBound( 
   int row
)

Parameters

row
Row index

Return Value

true if the row is bound; otherwise false
Example
This example returns whether the specified row is bound.
DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add("Test");
dr = dt.NewRow();
dr[0] = 1;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = 2;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = 3;
dt.Rows.Add(dr);
FpSpread1.Sheets[0].DataSource = dt; 

FarPoint.Web.Spread.SheetView sv;
sv = FpSpread1.ActiveSheetView;
bool b;
b = sv.IsRowBound(0);
Response.Write("Is the row bound is " + b.ToString());
Dim dt As New DataTable
Dim dr As DataRow
dt.Columns.Add("Test")
dr = dt.NewRow
dr.Item(0) = 1
dt.Rows.Add(dr)
dr = dt.NewRow
dr.Item(0) = 2
dt.Rows.Add(dr)
dr = dt.NewRow
dr.Item(0) = 3
dt.Rows.Add(dr)
FpSpread1.ActiveSheetView.DataSource = dt

Dim sv As FarPoint.Web.Spread.SheetView
sv = FpSpread1.ActiveSheetView
Dim b As Boolean
b = sv.IsRowBound(0)
Response.Write("Is the row bound is " & b.ToString())
See Also

Reference

SheetView Class
SheetView Members

User-Task Documentation

Managing Data Binding