I have this sub to remove a record from the datagrid and table, but it just removes the record from datagrid and it does not from the table.
I already defined the dataset and everything else before and these is the delete sub:
Private Sub cmdRemoveLoan_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdRemoveLoan.Click
Dim rno As String = dgAddedLoans.CurrentRowIndex
Catch ex As Exception