index > Visual Studio Tools for Office > List Object in excel - how to stop user deleting rows

List Object in excel - how to stop user deleting rows

how can i stop the user deleting rows from a data bound list object.

There is no setter on the AllowDelete property of the BindingSource object, detecting when a row is deleted on the underlying dataset and rejecting the changes stops the row from being deleted from the dataset but it leaves an empty list row in the list.

rebinding the BindingSource to the dataset has no effect either

Michael Pritchard

A DataTable does not allow this setting. To achieve this, you need to change the way you are data binding the table to the ListObject.

Instead of specifying the DataTable as the DataSource for the BindingSource, you need to create a DataView object over the DataTable. A DataView allows setting the AllowDelete property and you can set this to false. Then specify this DataView as the DataSource for the BindingSource.

Thanks.

This posting is provided "AS IS" with no warranties, and confers no rights.

Mohit Gupta - MSFT

Ok, so I create my DataView by doing:

DataView dv = new DataView(ds.Table);
dv.AllowDelete = false;
Globals.WorkSheet.tableBindingDataSource.DataSource = dv;

I have also set on the worksheet class:
tableBindingDataSource.DataSource = typeof(DataView); - this was previsouly a typed dataset

The user can still delete rows from the list object.

Using a dataview also removes the constraints on the user being to delete/edit Read Only columns in the typed DataSet

I've also tried:

ds.Table.DefaultView.AllowDelete = false;
Globals.WorkSheet.tableBindingDataSource.DataSource = ds.Table.DefaultView;

and the user can still delete rows and the read-only column constraints are still broke;

Michael Pritchard

seen as no-one can shed any more light on to this I have made minor workaround that disables the right click on the list object, although the user can still add the list object toolbar and delete a row that way.

Anyway, my typed dataset contraints are back working, i.e. some cells are read-only, however - if the user selects the entire row by clicking the row number (e.g. 5) and presses delete, all the data in the list is seemingly deleted - if you however go into the read only cell and press delete, the old value is returned.

Michael Pritchard

reply 4