Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / DefaultSheetDataModel Class / IsColumnBound Method
Column index to check
Example


In This Topic
    IsColumnBound Method (DefaultSheetDataModel)
    In This Topic
    Determines whether the specified column is bound to a data source column.
    Syntax
    'Declaration
     
    Public Function IsColumnBound( _
       ByVal column As Integer _
    ) As Boolean
    'Usage
     
    Dim instance As DefaultSheetDataModel
    Dim column As Integer
    Dim value As Boolean
     
    value = instance.IsColumnBound(column)
    public bool IsColumnBound( 
       int column
    )

    Parameters

    column
    Column index to check

    Return Value

    true if the column is bound; false otherwise
    Example
    This example binds the DefaultSheetDataModel to a DataTable and the values of the IsColumnBound, IsEditable, IsEmpty and IsRowUsed are returned to a list box.
    Private void Page_Load(object sender, System.EventArgs e)
    {
      If (this.IsPostBack) Return;
    
      bool b, b1, b2, b3;
      DataTable dt = New DataTable("FarPoint");
      dt.Columns.Add("Product");
      dt.Rows.Add(New Object[] {"SpreadWebv2"});
      dt.Rows.Add(New Object[] {"InputPro for WinForms"});
      DataRow nrow;
      nrow = dt.NewRow();
      nrow["Product"] = "To Be Announced";
      dt.Rows.Add(nrow);
      dt.AcceptChanges();
      FarPoint.Web.Spread.Model.DefaultSheetDataModel dm = New FarPoint.Web.Spread.Model.DefaultSheetDataModel(dt);
      FpSpread1.ActiveSheetView.DataModel = dm;
      FpSpread1.ActiveSheetView.Columns[0].Width = 240;
      b = dm.IsColumnBound(0);
      b1 = dm.IsEditable(0,0);
      b2 = dm.IsEmpty();
      b3 = dm.IsRowUsed(1);
      ListBox1.Items.Add(b.ToString());
      ListBox1.Items.Add(b1.ToString());
      ListBox1.Items.Add(b2.ToString());
      ListBox1.Items.Add(b3.ToString());
    }
    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    
       If (Me.IsPostBack) Then Return
    
       Dim b, b1, b2, b3 As Boolean
       Dim dt As New DataTable("FarPoint")
       dt.Columns.Add("Product")
       dt.Rows.Add(New Object() {"SpreadWebv2"})
       dt.Rows.Add(New Object() {"InputPro for WinForms"})
       Dim nrow As DataRow
       nrow = dt.NewRow()
       nrow("Product") = "To Be Announced"
       dt.Rows.Add(nrow)
       dt.AcceptChanges()
       Dim dm As FarPoint.Web.Spread.Model.DefaultSheetDataModel = New FarPoint.Web.Spread.Model.DefaultSheetDataModel(dt)
       FpSpread1.ActiveSheetView.DataModel = dm
       FpSpread1.ActiveSheetView.Columns(0).Width = 240
       b = dm.IsColumnBounded(0)
       b1 = dm.IsEditable(0, 0)
       b2 = dm.IsEmpty()
       b3 = dm.IsRowUsed(1)
       ListBox1.Items.Add(b.ToString())
       ListBox1.Items.Add(b1.ToString())
       ListBox1.Items.Add(b2.ToString())
       ListBox1.Items.Add(b3.ToString())
    
     End Sub
    See Also