Delete Row from TableAdapter?

Question

I have to Delete one row from datagridview which is connected to database SQL but i dont know how to call method in Button_click(Delete).(ex. this.nameTableAdapter.DeleteQuery() ).

Error show: _ID, _KlID does now exist ?? And Sql Query is :

DELETE FROM Artikulli WHERE (ID = @_ID) AND (KlID = @_KlID) OR (ID = @_ID) AND (KlID = @_KlID)

Answer 1

In your DataSet right click the TableAdapter then AddQuery and define your delete query. Then you can call the delete method via your table adapter.

Then

Now write your query, (use query builder if it is complicated).

Notice: your parameter names are prefixed with @. here I have one parameter named @Id