SQL DataAdapter timeout issue

Hello experts!

I have an application that queries a database and populates a datagrid based on the results.  On the top of the form, there are a few optional parameters where users can enter data to filter the search query.  When the user enters data into the PartNmb parameter field, the application throws a timeout exception when populating the SQL Data Adapter.

Is there any way I can adjust the default timeout for the SQL adapter?  I have already set the default ConnectString timeout to 60, however this doesnt seem to come in to play.


Thank you in advance for you help!


Start Free Trial

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:

Dim PBPUconn As String = "Persist Security Info=False;Integrated Security=SSPI;database=PBPSalesHistory;server=FPSQL01\SQL2005;Connect Timeout=60"
 
' populate the DataGrid
Me.Cursor = Cursors.WaitCursor
Dim myTable As New DataTable
Dim cmdFillForm As New SqlDataAdapter(QueryString, PBPUconn)
Try
    cmdFillForm.Fill(myTable)
 
    Catch ex As Exception
         MessageBox.Show(ex.Message)
End Try
 
DataGridView1.DataSource = myTable
cmdFillForm.Dispose()
myTable.Dispose()
Me.Cursor = Cursors.Default