GetDataRow Method

Visual Basic
C#

'Declaration
 
Public Function GetDataRow( _
   ByVal row As Integer _
) As DataRowView

'Usage
 
Dim instance As DefaultSheetDataModel
Dim row As Integer
Dim value As DataRowView
 
value = instance.GetDataRow(row)

public DataRowView GetDataRow( 
   int row
)

Parameters

row: Row index

Return Value

DataRowView object at the specified row

This example illustrates the use of this member by returning the data row for the specified index.

C#

DataTable dt = new DataTable("Testing");
DataRowView drv;
dt.Columns.Add("Number");
dt.Columns.Add("Letter");
dt.Rows.Add(new Object[]{"1", "One"});
dt.Rows.Add(new Object[] {"2", "Two"});
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(dt);
fpSpread1.ActiveSheet.Models.Data = dataModel;
drv = dataModel.GetDataRow(1);
listBox1.Items.Add(drv[0].ToString());

Visual Basic

Dim dt As New DataTable("Testing")
Dim drv As DataRowView
dt.Columns.Add("Number")
dt.Columns.Add("Letter")
dt.Rows.Add(New Object() {"1", "One"})
dt.Rows.Add(New Object() {"2", "Two"})
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(dt)
FpSpread1.ActiveSheet.Models.Data = dataModel
drv = dataModel.GetDataRow(1)
ListBox1.Items.Add(drv.Item(0).ToString())

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

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members