Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SpreadDataSource Class / GetData Method
Example


In This Topic
    GetData Method
    In This Topic
    Returns the data of this data source.
    Syntax
    'Declaration
     
    Public Function GetData() As IEnumerable
    'Usage
     
    Dim instance As SpreadDataSource
    Dim value As IEnumerable
     
    value = instance.GetData()
    public IEnumerable GetData()
    Example

    This example binds a cell range and uses many methods of the SpreadDataSource and SpreadDataSourceView classes.

    FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Value = "UserName";
    FpSpread1.Sheets[0].Cells[0, 0].Value = "Test";
    FpSpread1.Sheets[0].Cells[1, 0].Value = "Ann";
    FpSpread1.Sheets[0].Cells[2, 0].Value = "Doug";
    FarPoint.Web.Spread.SpreadDataSource spreadDS = new FarPoint.Web.Spread.SpreadDataSource();
    spreadDS.SheetName = FpSpread1.ActiveSheetView.SheetName;
    spreadDS.SpreadID = "FpSpread1";//FpSpread1.ID;
    spreadDS.CellRange = new FarPoint.Web.Spread.Model.CellRange(0, 0, 3, 1);
    
    //Add the Spread data source to the page
    this.Controls.Add(spreadDS);
    
    // GetData() method
    System.Collections.IEnumerable enmrable;
    System.Collections.IEnumerator enmr;
    enmrable = spreadDS.GetData();                       
    enmr = enmrable.GetEnumerator();
    ListBox1.DataTextField = "UserName";
    while (enmr.MoveNext()) 
       { 
        ListBox1.Items.Add(Convert.ToString(enmr.Current)); 
        }
           
    // GetViewNames() method
    System.Collections.ICollection c;
    c = spreadDS.GetViewNames();        
    string[] arr= new string[2];
    c.CopyTo(arr, 0);
    ListBox1.Items.Add(c.Count.ToString());
    if (arr[0] == "") 
       {
        ListBox1.Items.Add("return correct value");
       }
           
    // GetView() method
    System.Web.UI.DataSourceView DSView;              
    DSView = spreadDS.GetView(arr[0]);        
    ListBox1.Items.Add(DSView.CanDelete.ToString());
    ListBox1.Items.Add(DSView.CanInsert.ToString());
    ListBox1.Items.Add(DSView.CanUpdate.ToString());
    ListBox1.Items.Add(DSView.CanSort.ToString());
    
    FpSpread1.Sheets(0).ColumnHeader.Cells(0, 0).value = "UserName"
    FpSpread1.Sheets(0).Cells(0, 0).Value = "Test"
    FpSpread1.Sheets(0).Cells(1, 0).Value = "Ann"
    FpSpread1.Sheets(0).Cells(2, 0).Value = "Doug"
    
    Dim spreadDS As New FarPoint.Web.Spread.SpreadDataSource()
    spreadDS.SheetName = FpSpread1.ActiveSheetView.SheetName
    spreadDS.SpreadID = "FpSpread1"
    spreadDS.CellRange = New FarPoint.Web.Spread.Model.CellRange(0, 0, 3, 1)
    
    'Add the Spread Data Source to the page
    Controls.Add(spreadDS)
    
    Dim spreadDSV = New FarPoint.Web.Spread.SpreadDataSourceView(spreadDS)
    ListBox1.Items.Add(spreadDSV.CanDelete.ToString())
    ListBox1.Items.Add(spreadDSV.CanInsert.ToString())
    ListBox1.Items.Add(spreadDSV.CanUpdate.ToString())
    ListBox1.Items.Add(spreadDSV.CanSort.ToString())
    
    ' for GetData() method
    Dim enmrable As System.Collections.IEnumerable
    Dim enmr As System.Collections.IEnumerator
    enmrable = spreadDS.GetData()
    enmr = enmrable.GetEnumerator()
    ListBox1.DataTextField = "UserName"
    While enmr.MoveNext()
       ListBox1.Items.Add(Convert.ToString(enmr.Current))
    End While
    
    ' for GetViewNames() method
    Dim c As System.Collections.ICollection
    c = spreadDS.GetViewNames()
     Dim arr(2) As String
    c.CopyTo(arr, 0)
    ListBox1.Items.Add(c.Count.ToString())
    If arr(0) = "" Then
       ListBox1.Items.Add("return correct value")
    End If
    
    ' for GetView() method
    Dim DSView As System.Web.UI.DataSourceView
    DSView = spreadDS.GetView(arr(0))
    ListBox1.Items.Add(DSView.CanDelete.ToString())
    ListBox1.Items.Add(DSView.CanInsert.ToString())
    ListBox1.Items.Add(DSView.CanUpdate.ToString())
    ListBox1.Items.Add(DSView.CanSort.ToString())
    
    See Also