VB Forum / Database Access / December 2006

OK, I'm confused. The below code works fine until I select a
supplierperson that returns a large number of rows.  Why does the
MsgBox("HERE") display when in fact the sqlDataAdapter has not
returned the data? I can see a horizontal scroll bar on the
datagridview that I am using, but no data ever appears. What can I do
to let the user know that nothing is happening?

Private ds As DataSet

Dim sqlCN As New SqlClient.SqlConnection
Dim sqlCMD As New SqlClient.SqlCommand
Dim intNumRows As Integer = 0

...connection Stuff goes here (which works fine)
...NOTE: I have taken alot of proprietary stuff out of the
sqlCMD.commandText, but it does work.

sqlCMD.CommandText = "select s.supplierperson,p.personid "
"FROM PRODUCT p WITH (NOLOCK) " & _
"LEFT OUTER JOIN supplier s on s.supplierpersonsid =
sp.supplierpersonsid " &_ "WHERE  s.supplierperson LIKE " & "'" &
Me.txtFind.Text & "%'"

Dim da As New SqlDataAdapter(sqlCMD)

Try
    ds = New DataSet
               da.Fill(ds, "Product")
Catch ex As Exception
           MsgBox(ex.Message)
End Try

intNumRows = ds.Tables(0).Rows.Count
MsgBox("HERE")

If intNumRows > 0 Then
        SetupGridSupplierPerson()
End If