Spread ASP.NET 6.0 Product Documentation
IsEmpty Method
See Also  Example Send Feedback
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > DefaultSheetDataModel Class : IsEmpty Method


Glossary Item Box

Determines whether the data model is empty.

Syntax

Visual Basic (Declaration) 
Public Overrides Function IsEmpty() As Boolean
Visual Basic (Usage)Copy Code
Dim instance As DefaultSheetDataModel
Dim value As Boolean
 
value = instance.IsEmpty()
C# 
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.
C#Copy Code
 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());
 }
Visual BasicCopy Code
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 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.