GetDataTable Method

Visual Basic
C#

'Declaration
 
Public Function GetDataTable() As DataTable

'Usage
 
Dim instance As DefaultSheetDataModel
Dim value As DataTable
 
value = instance.GetDataTable()

public DataTable GetDataTable()

Return Value

DataTable containing the data table

This example attaches a DataTable to a DefaultSheetDataModel, which is then assigned to the DataModel of the spreadsheet. The DataRow, DataTable and DataView are returned to a list box.

C#

private void Page_Load(object sender, System.EventArgs e)
  {
  if (this.IsPostBack) return;

  DataTable dt = new DataTable("FarPoint");
  dt.Columns.Add("Product");
  dt.Rows.Add(new Object[] {"Spread"});
  dt.Rows.Add(new Object[] {"Input Pro"});
  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;
  DataRowView drv;
  DataView dv;
  drv = dm.GetDataRow(1);
  dv = dm.GetDataView();
  ListBox1.Items.Add(Convert.ToString(drv.RowVersion));
  ListBox1.Items.Add(Convert.ToString(dm.GetDataTable()));
  ListBox1.Items.Add(Convert.ToString(dv.Count));
}

Visual Basic

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

   If (Me.IsPostBack) Then Return

   Dim dt As New DataTable("FarPoint")
   dt.Columns.Add("Product")
   dt.Rows.Add(New Object() {"Spread"})
   dt.Rows.Add(New Object() {"Input Pro"})
   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
   Dim drv As DataRowView
   Dim dv As DataView
   drv = dm.GetDataRow(1)
   dv = dm.GetDataView()
   ListBox1.Items.Add(drv.RowVersion.ToString())
   ListBox1.Items.Add(dm.GetDataTable.ToString)
   ListBox1.Items.Add(dv.Count.ToString)

 End Sub

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

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members