Gets or sets whether to allow the user to add a new row when the sheet is bound.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property DataAllowAddNew As Boolean |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As SheetView
Dim value As Boolean
instance.DataAllowAddNew = value
value = instance.DataAllowAddNew |
| C# | |
|---|
public bool DataAllowAddNew {get; set;} |
Property Value
true if allowed to add new row; otherwise,
falseExample
This example uses the DataAllowAddNew property.
| C# | Copy Code |
|---|
DataSet ds = new DataSet();
DataTable emp = new DataTable("Employees");
DataTable div = new DataTable("Division");
emp.Columns.Add("LastName");
emp.Columns.Add("FirstName");
emp.Rows.Add(new Object[] {"Jones", "Marianne"});
emp.Rows.Add(new Object[] {"Fieldes", "Anna"});
div.Columns.Add("Section");
div.Columns.Add("Specialty");
div.Rows.Add(new Object[] {"Finance", "Taxes"});
div.Rows.Add(new Object[] {"Mergers", "Legal"});
ds.Tables.AddRange(new DataTable[] {emp, div});
fpSpread1.DataSource = ds;
fpSpread1.DataMember = "Division";
fpSpread1.Sheets[0].DataAllowAddNew = true; |
| VB.NET | Copy Code |
|---|
Dim ds As New DataSet()
Dim emp As New DataTable("Employees")
Dim div As New DataTable("Division")
emp.Columns.Add("LastName")
emp.Columns.Add("FirstName")
emp.Rows.Add(New Object() {"Jones", "Marianne"})
emp.Rows.Add(New Object() {"Fieldes", "Anna"})
div.Columns.Add("Section")
div.Columns.Add("Specialty")
div.Rows.Add(New Object() {"Finance", "Taxes"})
div.Rows.Add(New Object() {"Mergers", "Legal"})
ds.Tables.AddRange(New DataTable() {emp, div})
fpSpread1.DataSource = ds
fpSpread1.DataMember = "Division"
fpSpread1.Sheets(0).DataAllowAddNew = True |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also
