Spread ASP.NET 14
Spread for ASP.NET 14 Product Documentation / Developer's Guide / Managing Data Binding / Adding an Unbound Row
In This Topic
    Adding an Unbound Row
    In This Topic

    You can add an unbound row of cells to a sheet in a component that is bound to a data source.

    Using a ShortCut

    1. Bind the data.
    2. Use the AddUnboundRows method after adding any data to the data set.
    3. Use the AddRowToDataSource method to add the row to the data source.


    This example code adds an unbound row, adds data to the row, and then adds the row to the data source.

    Copy Code
    private void FpSpread1ChildViewCreated(object sender, FarPoint.Web.Spread.CreateChildViewEventArgs e)
    FarPoint.Web.Spread.SheetView sv;
    sv = e.SheetView;
    sv.AddUnboundRows(0, 1);
    sv.Cells[0, 0].Value = "Dallas";
    sv.Cells[0, 1].Value = "0";
    sv.Cells[0, 2].Value = "Texas";
    sv.AddRowToDataSource(0, true);
    Copy Code
    Private Sub FpSpread1ChildViewCreated(ByVal sender As Object, ByVal e As FarPoint.Web.Spread.CreateChildViewEventArgs) Handles FpSpread1.ChildViewCreated
    Dim sv As FarPoint.Web.Spread.SheetView
    sv = e.SheetView
    sv.AddUnboundRows(0, 1)
    sv.Cells(0, 0).Value = "Dallas"
    sv.Cells(0, 1).Value = "0"
    sv.Cells(0, 2).Value = "Texas"
    sv.AddRowToDataSource(0, True)
    End Sub 
    See Also