Spread for Windows Forms 6.0
Adding an Unbound Row to a Bound Sheet

Once you bind a sheet to a data set you might want to add an unbound row to contain additional data.

The following figure shows a sheet in a Spread component that contains data from a data set and an unbound row at the bottom that calculates the averages.

Sheet with unbound row

Return to the overall list of tasks in Adding to Bound Data.

Using a Shortcut

  1. Create your data set.
  2. Set the FpSpread or Sheet DataSource property equal to the data set.
  3. Call the Sheet AddUnboundRows method to specify where to add the unbound row.
  4. Set properties for the unbound row.

    Example

    This example code binds the Spread component to a data set then adds an unbound row.

    [C#]

    // Bind the component to the data set.

    fpSpread1.DataSource = dbDataSet;

    // Add an unbound row.

    fpSpread1.Sheets[0].AddUnboundRows(20, 1);

    [Visual Basic]

    ' Bind the component to the data set.

    FpSpread1.DataSource = dbDataSet

    ' Add an unbound row.

    FpSpread1.Sheets(0).AddUnboundRows(20, 1)

Using Code

  1. Create your data set.
  2. Create a new SheetView object.
  3. Set the SheetView object DataSource property equal to the data set.
  4. Call the SheetView object AddUnboundRows method to specify where to add the unbound row.
  5. Set properties for the unbound row.
  6. Assign the SheetView object to a sheet in the component.

    Example

    This example code creates a bound SheetView object and adds an unbound row to it, then assigns it to a sheet in a Spread component.

    [C#]

    // Create a new SheetView object.

    FarPoint.Win.Spread.SheetView newsheet = new FarPoint.Win.Spread.SheetView();

    // Bind the SheetView object to the data set.

    newsheet.DataSource = dataSet1;

    // Add an unbound row.

    newsheet.AddUnboundRows(20, 1);

    // Assign the SheetView object to the first sheet.

    fpSpread1.Sheets[0] = newsheet;

    [Visual Basic]

    ' Create a new SheetView object.

    Dim newsheet As New FarPoint.Win.Spread.SheetView()

    ' Bind the SheetView object to the data set.

    newsheet.DataSource = DataSet1

    ' Add an unbound row.

    newsheet.AddUnboundRows(20, 1)

    ' Assign the SheetView object to the first sheet.

    FpSpread1.Sheets(0) = newsheet