Gridview on Delete button and Sorting

[Esll]

Hi, I have a problem with my gridview for the deleting and sorting part.
When I try to delete after I sort, it did not delete the correct items that I wanted it to delete.
Can someone help me on this?

Protected Sub LinkButton1_Command(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.CommandEventArgs)
        If e.CommandName = "SortByName" Then
            If Sort = "ASC" Then
                Sort = "DESC"
            Else
                Sort = "ASC"
            End If
 
            DataSet.Tables(0).DefaultView.Sort = "Name " & Sort
            Gridview.DataSource = DataSet.Tables(0).DefaultView
            Gridview.DataBind()
 
        End If
End Sub
 
Protected Sub Gridview_RowDeleting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewDeleteEventArgs) Handles Gridview.RowDeleting
    Dim name As String = CType(Gridview.Rows(e.RowIndex).FindControl("Label1"), Label).Text
    database.OpenConn()
    Dim strsql As String = "Delete from table where Name = '" & name & "'"
    database.ExecuteUpdate(strsql)
    database.CloseConn()
 
End Sub