Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / IsRowBound Method
Row index
Example


In This Topic
    IsRowBound Method (SheetView)
    In This Topic
    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