Delete DataRow In DataTable

[Agnes]

Dim drTemp As DataRow
For Each drTemp In dtInvCharges.Select("invno ='" &
Me.txtInvNo.Text.Trim & "' ")
dtInvCharges.Rows.Remove(drTemp)
Next
I got a "Delete button" to delete all rows in that Table. and the process
"SAVE", In the screen , i can see the datagrid got nothing,
however, as i check back my table in SQL, The data still here ?? Please
help
bmInvInfo.EndCurrentEdit()
If dsInvInfo.HasChanges() Then
daInvChg.Update(dsInvInfo, strdtChg)
daInvInfo.Update(dsInvInfo, strdtInfo)
dsInvInfo.AcceptChanges()
ENDIF

[Cor Ligthert [MVP]]

Agnes,

I thought that I had answered this question already 9 months ago to you

http://groups.google.com/group/micro...dd12fa1f12e784

A 'remove' removes a datarow from a datatable, therefore with an update it
cannot remove it from the database because there is nothing more.

A delete marks a not newly added datarow as to delete. After an update of
that original datatable or an acceptchanges the datarow will be removed from
the datatable.

I don't know if this helps now, however I hope it.

:-)

Cor

[Marina]

You removed the rows. Not marked them as deleted. So as far as the datatable
is concerned, it has no rows in it - and no changes to send. Call the
Delete method on the rows you want to delete.

"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:uA**************@TK2MSFTNGP09.phx.gbl...

Dim drTemp As DataRow
For Each drTemp In dtInvCharges.Select("invno ='" &
Me.txtInvNo.Text.Trim & "' ")
dtInvCharges.Rows.Remove(drTemp)
Next
I got a "Delete button" to delete all rows in that Table. and the process
"SAVE", In the screen , i can see the datagrid got nothing,
however, as i check back my table in SQL, The data still here ?? Please
help
bmInvInfo.EndCurrentEdit()
If dsInvInfo.HasChanges() Then
daInvChg.Update(dsInvInfo, strdtChg)
daInvInfo.Update(dsInvInfo, strdtInfo)
dsInvInfo.AcceptChanges()
ENDIF

[Cor Ligthert [MVP]]

doh,

Although that answer was AFAIK now wrong.

Now I know that a delete from a datagrid using the AltKey does a delete.

Nevertheless is a remove as in your code the remove I was refering to.

Cor