Spread for ASP.NET 9.0 Product Documentation
IsEmpty Method (DefaultSheetDataModel)
Example 


Determines whether the data model is empty.
Syntax
'Declaration
 
Public Overrides Function IsEmpty() As Boolean
'Usage
 
Dim instance As DefaultSheetDataModel
Dim value As Boolean
 
value = instance.IsEmpty()
public override bool IsEmpty()

Return Value

true if the model has no data; false otherwise
Remarks
To check if the cell contents are editable, use the IsEditable method.
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
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members

 

 


Copyright © GrapeCity, inc. All rights reserved.