Spread for ASP.NET 8.0 Product Documentation > Developer's Guide > Managing Data Binding > Adding an Unbound Row |
You can add an unbound row of cells to a sheet in a component that is bound to a data source.
This example code adds an unbound row, adds data to the row, and then adds the row to the data source.
C# |
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); } |
VB |
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 |