[RESOLVED] [2005] How to know if no rows are returned?

[rim78]

I have a Find button on my form that binds to a dataset. How do check when there is no rows returned and inform the user?

Thanks.

Private Sub FindNameToolStripButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles FindNameToolStripButton.Click
        Me.Cursor = Cursors.WaitCursor
        Try
            Me.MAILTableAdapter.FillByName(Me.DetailsDataSet.MAIL, Me.NameToolStripTextBox.Text)
 
        Catch ex As Exception
            MessageBox.Show("Error: " & ex.Message)
 
        End Try
        Me.Cursor = Cursors.Default
    End Sub