What means this error message?

[giannis]

I am a newbie at VB.
When i try to remove an item from the BindingSource and try to delete this
item from the database:

BindingSource.RemoveCurrent()

Me.TABLETableAdapter.Update(Me.DataSet.TABLE)
i receive the message :

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

What means this error message and how resolve this ?
Any code is it will acceptable.
Sorry for my english and thank you !

[Miro]

You looking fo something like this?

http://msdn2.microsoft.com/en-us/lib...23(VS.80).aspx

Miro

"giannis" <zz********@freemail.grwrote in message
news:eN*************@TK2MSFTNGP05.phx.gbl...

>I am a newbie at VB.
When i try to remove an item from the BindingSource and try to delete this
item from the database:

BindingSource.RemoveCurrent()

Me.TABLETableAdapter.Update(Me.DataSet.TABLE)
i receive the message :

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

What means this error message and how resolve this ?
Any code is it will acceptable.
Sorry for my english and thank you !

[giannis]

Miro wrote:

You looking fo something like this?

http://msdn2.microsoft.com/en-us/lib...23(VS.80).aspx

No

[RobinS]

"giannis" <zz********@freemail.grwrote in message
news:eJ**************@TK2MSFTNGP04.phx.gbl...

Miro wrote:

>You looking fo something like this?

http://msdn2.microsoft.com/en-us/lib...23(VS.80).aspx

No

Yes you are. Look at the bottom of that article at "To delete records from
a database using command objects".

You don't have a DeleteCommand object defined for your data adapter or
TableAdapter object.

Robin S.

[giannis]

The answer is very simple :
"In some situations, the SELECT statement does not provide enough
information for the adapter to generate the commands necessary to create
the INSERT,UPDATE,and DELETE commands required for a successful save.
This often occurs when the database table does not have a primary key
column."
Therefore I need a primary key.
Now (i added a primary key) the :
Me.TABLETableAdapter.Update(Me.DataSet.TABLE)
works fine !!!

giannis wrote:

I am a newbie at VB.
When i try to remove an item from the BindingSource and try to delete
this item from the database:

BindingSource.RemoveCurrent()

Me.TABLETableAdapter.Update(Me.DataSet.TABLE)
i receive the message :

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

What means this error message and how resolve this ?
Any code is it will acceptable.
Sorry for my english and thank you !