can anyone help me on how to know EOF of excel using vb.net?

i have this code but it crash when i try delete the proceeding rows from row 6 to downward.

my problem is, my code was still reading a null values of rows that i deleted in excel..

this is my code:

        Dim xlsConn As New OleDbConnection
        Dim xlsAdapter As New OleDbDataAdapter
        Dim xlsDataSet As New DataSet

    xlsConn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & pathName & " ; Extended Properties=Excel 8.0")
            strSQL = "SELECT * FROM [Sheet1$]"
            xlsAdapter.SelectCommand = New OleDbCommand(strSQL, xlsConn)
            xlsDataSet.Clear()
            xlsAdapter.Fill(xlsDataSet)
            ListView1.Items.Clear()

Dim listItem As ListViewItem
            For ctr As Integer = 0 To xlsDataSet.Tables(0).Rows.Count - 1
                listItem = ListView1.Items.Add(xlsDataSet.Tables(0).Rows(ctr).Item("EmpNo").ToString)
listItem.SubItems.Add(xlsDataSet.Tables(0).Rows(ctr).Item("EmpName").ToString)
            Next

Can anyone help me to fix this bugs!