Delete row from database c#

Question

Why is this code not working?

        (this.namesBindingSource.Current as DataRowView).Delete();         
        this.namesTableAdapter.Update(database1DataSet1);

Error : Update requires a valid DeleteCommand when passed DataRow collection with deleted rows.

Database is service-based database added to project with only one table which is show in dataGridView and this code is linked to button. You will click on row for delete and then pres button and get error....

What is wrong? I'm getting crazy......

What is the value of namesTableAdapter.DeleteCommand property? — alex.b
– alex.b, Commented Jan 10, 2013 at 10:20

Tim Schmelter · Accepted Answer · 2013-01-10 10:19:53Z

2

The error message is self explanatory. You need a valid DeleteCommand for namesTableAdapter. Otherwise it does not know you to delete your "deleted" rows. The same is true for Update or Insert-Commands.

Delete() just changes the RowState. If you use a DataAdapter (or TableAdapter) it needs to know what to do if the state is Deleted or Modified.

How to: Create TableAdapter Queries

answered Jan 10, 2013 at 10:19

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ScareCrow Over a year ago

HI Tim, thank you very much for answer, but unfortunatelly I don´t have idea how to implemend this. I need to delete row from table when button is pressed.

Manoj Purohit · Accepted Answer · 2013-01-10 10:35:49Z

0

use CommandBuilder but remember you need to use table with a key column in it.

answered Jan 10, 2013 at 10:35

Manoj Purohit

3,4631 gold badge17 silver badges17 bronze badges

Collectives™ on Stack Overflow

Delete row from database c#

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related