Determines whether the specified row is not empty.
Syntax
Visual Basic (Declaration) | |
---|
Public Overrides Function IsRowUsed( _
ByVal row As Integer _
) As Boolean |
Parameters
- row
- Index of row to check
Return Value
true if the row contains data;
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.
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 Basic | Copy 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 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also