Deleted row is not deleted (using DataSet)

[gigazelle]

Hi everyone,

I'm a newbie in VB.net. I have a problem, when I delete a row (using DtTbl.Rows.Remove(DtRow) syntax), and then I save the records into Database (using DtAdapter.Update(Dtset, "TblNm") syntax), the deleted record is still exist.

Please tell me, what should I do to fix this problem, thanks before...

Here is my code :

Private Sub CmdDelDtl_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CmdDelDtl.Click
    Dim TblDel As DataTable = DtSetDt.Tables("TblNm")
 
    Dim idx As Integer
    idx = DtGrid.CurrentRowIndex()
 
    Dim RowDel As DataRow = TblDel.Rows(idx)
    TblDel.Rows.Remove(RowDel)
 
End Sub
 
Private Sub CmdSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CmdSave.Click
 
    ''--Open the Connection
    ConnOpen()
 
    ''--Save into DB
    DtAdapDt.Update(DtSetDt, "TblNm")
 
    Conn.Close()
 
End Sub
 

[Frinavale]

It looks as if you're doing everything correctly.
Are you getting any error messages or exceptions?

Have you seen this article on How to save dataset changes?

-Frinny