Spread Windows Forms 8.0 Product Documentation
IsRowBound Method (DefaultSheetDataModel)
Example 


Index of row to check
Determines whether the specified row is bound to a data source row.
Syntax
'Declaration
 
Public Function IsRowBound( _
   ByVal row As Integer _
) As Boolean
'Usage
 
Dim instance As DefaultSheetDataModel
Dim row As Integer
Dim value As Boolean
 
value = instance.IsRowBound(row)
public bool IsRowBound( 
   int row
)

Parameters

row
Index of row to check

Return Value

Boolean: true if the row is bound; false otherwise
Example
Dim ds As New DataSet()
Dim emp As New DataTable("Employees")
Dim div As New DataTable("Division")
emp.Columns.Add("LastName")
emp.Columns.Add("FirstName")
emp.Rows.Add(New Object() {"Jones", "Marianne"})
emp.Rows.Add(New Object() {"Fieldes", "Anna"})
div.Columns.Add("Section")
div.Columns.Add("Specialty")
div.Rows.Add(New Object() {"Finance", "Taxes"})
div.Rows.Add(New Object() {"Mergers", "Legal"})
ds.Tables.AddRange(New DataTable() {emp, div})
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel()
dataModel.DataSource = ds
dataModel.DataMember = "Division"
dataModel.AddUnboundRows(1, 3)
ListBox1.Items.Add(dataModel.IsRowBound(1).ToString())
FpSpread1.ActiveSheet.Models.Data = dataModel
DataSet ds = new DataSet();
DataTable emp = new DataTable("Employees");
DataTable div = new DataTable("Division");
emp.Columns.Add("LastName");
emp.Columns.Add("FirstName");
emp.Rows.Add(new Object[] {"Jones", "Marianne"});
emp.Rows.Add(new Object[] {"Fieldes", "Anna"});
div.Columns.Add("Section");
div.Columns.Add("Specialty");
div.Rows.Add(new Object[] {"Finance", "Taxes"});
div.Rows.Add(new Object[] {"Mergers", "Legal"});
ds.Tables.AddRange(new DataTable[] {emp, div});
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5);
dataModel.DataSource = ds;
dataModel.DataMember = "Division";
dataModel.AddUnboundRows(1, 3);
listBox1.Items.Add(dataModel.IsRowBound(1).ToString());
fpSpread1.ActiveSheet.Models.Data = dataModel;
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members

 

 


Copyright © GrapeCity, inc. All rights reserved.